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?

Microsoft Access

Last Comment

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon

Joe Howard

1/14/2014

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

1/14/2014

ASKER

Where does this code go, this is a desktop application

Joe Howard

1/14/2014

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

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

Brogrim

1/14/2014

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)

1/14/2014

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Brogrim

1/14/2014

ASKER

Thanks

Joe Howard

1/14/2014

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.

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

1/14/2014

"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