Chapter 38 Creating Menu Structures with the Ribbon
Chapter 38 Creating Menu Structures with the Ribbon
B
ack in Chapter 11 of this book, you learned how to create custom ribbons for use on
forms and reports. But what if you wanted to create a full menu structure for your
application with trees of drop-down menus similar to versions before Access 2007?
This is still possible within the XML structure of the ribbon. As before you need to create
a system table called USysRibbons if you do not have it already. You need to create two
fields in this new table. The first is called RibbonName and is a text field to hold the name
you give to your custom ribbon. The second field is called RibbonXML and needs to be set to
a memo field.
As before, you will also need the 2007 Custom UI Editor for Microsoft Office, which can
be downloaded for free from http://www.openxmldeveloper.org/articles/CustomUIeditor.aspx.
Load a blank Excel XML file into the Custom UI Editor by choosing File | Open from the
menu. Enter the following XML into the Custom UI Editor:
345