31.10. Modifying the Ribbon in Access

Access often takes its own, sometimes rather indirect, path to accomplish a given task. Ribbon customization is no exception. You can still use the Office 2007 Custom UI Editor (or any other XML editor) to validate your XML code, but you can't use it to store the XML in an Access database. You must do that by hand, by storing it in a cell in a special table.

In the following example, you'll see how to modify the Access Ribbon by adding a new tab, group, and toggle button to the Ribbon — just as in the previous section we added these elements to Word's Ribbon. When the Access Ribbon has been modified, you can click the new toggle button and see the message "Button Down" or "Button Up." The result is the same ...

Get Mastering VBA for Microsoft Office 2007, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.