Different Ribbons at Different Times

[speakers_86]

So I was playing with how to show a different ribbon for each form, and I get that fine. The db itself has no custom ribbon, while the form does. However, what about when no forms are open? How do you hide the standard tabs? I have a blank ribbon that only hides stuff. I tried making that the db's ribbon, but it seems to override the form's ribbon.

 

[Ari]

Hi

To hide the standard tabs use the default attribute startFromScratch="true". Example of clean ribbon for Access 2007:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<commands>
<command idMso="ApplicationOptionsDialog" enabled = "false"/>
<command idMso="FileExit" enabled = "false"/>
<command idMso="Help" enabled = "false"/>
</commands>
<ribbon startFromScratch="true">
<officeMenu>
<button idMso="FileNewDatabase" visible = "false"/>
<button idMso="FileOpenDatabase" visible = "false"/>
<splitButton idMso="FileSaveAsMenuAccess" visible = "false"/>
<button idMso="FileCloseDatabase" visible = "false"/>
</officeMenu>
</ribbon>
</customUI>


Simply indicate the Options Access> Current Database> select name ribbon in combobox

Every time we do not have the ribbon form will assume Ribbon Main.

 

[Mr. B]

You need a custom ribbon much like the one provided by Ari, but you need to specify your cusomt ribbon as the ribbon to use for the database in the Database Options.

 

[speakers_86]

I think I see where my confusion came from. It does not seem like you can toggle the start from scratch property between ribbons. If start from scratch is true in the db's ribbon, it is true for subsequent ribbons too.

 

[NigelShaw]

Hi

You could load all ribbons then turn off the reqs with InValidate? Set your groups as Boolean and then invalidate them

I have a large thread on this, search my stuff


N