Access.2007.VBA.Bibl..

If you have Visual Studio 2005 (any edition), use its built-in XML editor; otherwise, I recommend

the XML Notepad 2007 editor for working with XML code.

FIGURE 15.3

XML code in the Office 2007 Custom UI Editor.

Customizing the Ribbon in an Access Database ................................................................

If you want to add tabs, groups, or controls to the Ribbon in an Access database, you have to write

XML and (optionally) VBA code — unlike customizing toolbars and menus, you can’t just drag a

command to a location on any toolbar or menu, as in previous versions of Access. The only man-

ual customization available in Access 2007 is adding commands to the Quick Access Toolbar. In a

major change from previous versions of Office, you can’t programmatically add commands to stan-

dard Ribbon groups, or remove standard commands from groups, although you can hide tabs com-

pletely, and add new groups containing custom commands.

Customizing the Ribbon with XML in Access Databases and Add-ins 15