asked on

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?

Joe Howard

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.

Brogrim

ASKER

Where does this code go, this is a desktop application

Joe Howard

You have to customize the ribbon, see http://office.microsoft.com/en-us/excel-help/customize-the-ribbon-HA010355697.aspx for info.

This is a helpful reference http://www.rondebruin.nl/win/s2/win001.htm

Brogrim

ASKER

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

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Brogrim

ASKER

Thanks

Joe Howard

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.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"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