Question Minimise or hide ribbon on load?

[garywood84]

We're recently upgraded to Office 2007, and are running a database I built in Access 2003. In Access 2003, the toolbars were all hidden when the database loaded, so that users had to use the functions provided on my forms only.

In 2007, most of the tabs on the ribbon disappear on load, but there is a Home tab, with most options greyed out. I want to either prevent this from displaying, or, if that's not possible, make the ribbon minimised on load. Please can someone tell me how to do either of these things?

Thanks,

Gary

 

[garywood84]

I've just discovered this web page, which explains how to hide the ribbon on load.

http://msdn.microsoft.com/en-us/library/bb258192.aspx

It works, except that it also modifies the Office button, taking away the "Print" option. Does anyone know how I could modify this code to make Access hide the ribbon but keep the print option?

Thanks,

Gary

 

[NigelShaw]

Hi Gary,

cake & eat it.......

you will need to do more than just turn off the menus as StartFromScratch will turn everything off. you will need to create a little ribbon-

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<commands>
<command idMso="ApplicationOptionsDialog" enabled="false"/>
</commands>
<ribbon startFromScratch="true">
<officeMenu>

<button idMso="FileNewDatabase" visible="false" />
<button idMso="FileOpenDatabase" visible="false" />
<splitButton idMso="FileSaveAsMenuAccess" visible="false" />
<splitButton idMso="FilePrintMenu" visible="true" />
</officeMenu>
</ribbon>

</customUI>

This will hide the ribbon and display the print dialog. it will also disable the access options.

hope this helps


nigel