MS Access StartUP (2010)

I have created an application with a "Display Form" on startup, I have also unchecked the "Display Navigation  Pane". The application opens as expected but the Access icon remain in the top left hand corner with a pull down for customize toolbar.

How can I chang the settings that the tabs (File  & Home) and the above are not displayed?
BrogrimInformation Systems Development ManagerAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
With 2010, you still have access to command bars and can remove the ribbion entirely with:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

also, in dealing with the ribbon, this site:

http://www.ribboncreator.de/en/

has a wealth of information on working with the ribbon.  Check the FAQ link on the left.

Jim.
0
 
MacroShadowCommented:
You will have to use a custom Ribbon file.

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
  <qat> </qat>
  <tabs>
     <tab idMso="TabHome" visible="true" />
     <tab idMso="TabCreate" visible="true" />   
     <tab idMso="TabExternalData" visible="true" />
     <tab idMso="TabDatabaseTools" visible="true" />     
 </tabs>
</ribbon>
</customUI>

Open in new window


  <qat> </qat> is responsible for an empty Quick Access Toolbar.
0
 
BrogrimInformation Systems Development ManagerAuthor Commented:
Where does this code go, this is a desktop application
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
MacroShadowCommented:
0
 
BrogrimInformation Systems Development ManagerAuthor Commented:
I have followed the link

1.    In the Customize the Ribbon window under the Customize the Ribbon list, click the tab that you want to remove.

2.    Click Remove.
    To see and save your customizations, click OK.

Thi has removed the Home tab bit I cant find the File tab to remove
0
 
BrogrimInformation Systems Development ManagerAuthor Commented:
Thanks
0
 
MacroShadowCommented:
You can't remove the File tab unless you create your own ribbon, for that see the link posted by Jim Dettman and the second link I posted.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"You can't remove the File tab unless you create your own ribbon"
Actually, you cannot remove the File tab no matter what. But you can remove everything on it.

mx
0
All Courses

From novice to tech pro — start learning today.