How to hide Access Title Bar and Customize Qucik Access Toolbar - Access Project 2007

Posted on 2009-04-20
Last Modified: 2012-05-06
  I have an Access Project 2007 file (.adp file). I attached a custom Ribbon to it. Click on each button in my Custom Ribbon opens a form with specific funtionality.

All these forms are opened as Tab sheets. This setting is present in Access Options - Current Database - Tabbed Documents option is selected and Display Document Tabs is checked.

For your information - in my Custom ribbon - I have already set 'StartFromScratch=True'.

Till then, everything is fine.

Now, clicking on a button in my Custom Ribbon - I need to open a form in another application (another .ade file).

I have done this also. But the problem is the look and feel of my Main application. I would like to show the form in my second application with exactly the same size of my Main application form like another tab in my Main application. So that the user will not see any difference - whether this form is opened from the Main application or from my sub application...

Now, what happens is, the Form say for eg, frmTest from the second application (child app) opens. But it has its own Title Bar and Customize Quick Access Toolbar button. In my child also, I am loading a custom Ribbon with StartFromScratch= True..

But How can I hide my child application Access Title Bar, Customize Qucik Access Toolbar button so that I can avoid 2 empty bars at the top of my form ' frmTest' which will make frmTest size equivalent to my Main application forms?

My major concern is - there should not be any difference in the look and feel of the application. The end user should not know that there are 2 access applications running...
Question by:xsysys
    LVL 84

    Accepted Solution

    Why not import that Form into your main database (including any dependencies). You'll not be able to "embed" a form into a tab; you could likely open a new session of Access and hide the Access window, then try to position it exactly as needed, but all your user would need to do is just move the main or child app and your look would be off.

    Author Closing Comment

    As there is no other option to hide the title bar, managed with single ade file itself...

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    VBA to filter 17 67
    Access - LDB lock file 4 24
    Microsoft Access Table name 3 20
    Getting #Type! error in expression builder 5 19
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now