Where can I find the idMSO for a Ribbon Control or imageMso for a symbol in a Ribbon Control?
Open the dialog "Customize the Quick Access Toolbar".
In the dialog box select a section in "Choose commands from:" and go with the mouse over the required command. The tooltip will show the underlying command and in parentheses the appropriate idMSO for the command and the assigned icon.
In Sample DB 3 you can find all possible "Icons" on tab "IconGallerie" in the group "Office Icons". By click on the desired icon a form will open and you can copy "imageMso".
In the link list you will also find a link to the ControlID list. In there you will find all idMso of Office 2007.
How to execute a function from a Ribbon Control?
For Access 2007: "Office Button" / "Access Options" / "Advanced" / "General" / "Show add-in user interface errors" needs to be checked.
For Access 2010 and Access 2013 use: "File" / "Options" / "Client Settings" / "General" / "Show add-in user interface errors"
With this option switched on all errors generated by Ribbon XML will be shown.
Why do I get an error message during start or when clicking a user-defined button on a ribbon?
User-defined Ribbons require a reference to "Microsoft Office 12.0 Object Library" for Office 2007, for Office 2010 use "Microsoft Office 14.0 Object Library".
To set the reference open any module (to start the Visual Basic Editor), menu "Tools" / "References...", and place a check on "Microsoft Office 1x.0 Object Library". Confirm the references dialog with "OK".
How to remove the Office Button?
You can remove all entries from the Office menu (Instructions), however, the Office Button itself cannot be removed.
I want my database created in A2003 (or before) display my own menubar only.
A2003: "Tools" / "Startup" / "Allow Build-in Toolbars"
Select your menubar from the drop-down "Menu Bar"
A2007: "Office Button" / Button "Access Options" / "Current Database" / "Ribbon and Toolbar Options" / "Allow Build-in Toolbars"
Select your menubar from the drop-down "Menu Bar".
How can I hide tab "Home" and rename tab "Add-In's"?
Remark: You cannot rename the group name "Custom Toolbars"
Can I integrate my own ribbon buttons or other controls inside the Access "Home" tab? Or can I move controls within a standard Access ribbon?
No. Access ribbons cannot be manipulated or only very limited manipulation is possible.
What you can do is create your own group within an Access tab and in there you can create buttons / controls.
Can I hide "Press F1 for more help." in a Screentip / Supertip?
You can hide the screentips in the options of Access.
How to use own image files on a Ribbon without prior copying these into the file system.
Store the desired images in binary format in a table, and load them by means of the callback "getImage" to the Ribbon.
You can find the appropriate sample IconInRibbon in the download area.
I've created a customized Quick Access Toolbar using a Ribbon XML but it's not displayed after reopening the database likewise I'm opening a database adapting the Quick Access Toolbar. The Quick Access Toolbar is not displayed.
As a rule it's insufficient only to close and reopen the current database.
To ensure that the customized Quick ACCESS Toolbar will be displayed you have to close and then restart Access.
Create a "dummy" form in the database which should be opened in the event "OnRibbonLoad" and immediately closed again.
Be aware not to start your database with a double click from the Explorer.
You can find a sample database in the download area.
Do I have the option to hide the " " button on the Ribbon?
May I add comments to my Ribbon XML ?
Do I have the option to show a custom form if the option button is clicked on Office Menu ?
See Access sample database "Access-Options"
How to ensure that no ribbon will be displayed in my database ?
Can I change the Icon of the Office Button ?
How can I hide the Ribbon ?
How to identify the Ribbon state?
This Sample Database shows how to set the Ribbon state by VBA.
I have switched all my command bars to ribbons. How can I delete the command bars ?
Is it possible to use Late Binding instead of Early Binding, i.e. use Ribbons without the need for a reference to Microsoft Office ## Object Library?
No, the reference to Microsoft Office 12 Object Library is required.
Yes, Access 2010 allows Late Binding.
in all declaration statements in all modules.
2. Remove reference to "Microsoft Office 14.0 Object Library".
Remark: After removal of the reference IntelliSense will not be available for these objects any longer.
Am I able to use Application Ribbons for both Access versions (2007 and 2010) within one database?
Setup Ribbon XML for all Ribbons in table USysRibbons.
Go to Options, Current Database, Ribbon and Toolbar Options, enter a Ribbon Name that does NOT exist in USysRibbons, e.g. "DBRibbon".
Make sure function "fnc_LoadRibbon" will be loaded by Autoexec macro.
This sample is available as download.
Special thanks for the inspiration to Albert Kallal and Graham Mandeno.