Access.2007.VBA.Bibl..

The Extras (Ribbon) add-in has only a single menu add-in: Enable Extras Tab, which runs a proce-

dure (listed next) that copies the USysRibbons table into the calling database, and attempts to load

the table.

Part III Adding More Functionality to Office

continued

Figure SB-6. Running Access as an administrator

Open the add-in from the Access window, open the UsysRegInfo table and (if necessary) change the

capitalization of “Menu Add-ins” to “Menu Add-Ins” (capitalizing the I). This is only necessary for

running add-ins in Vista; “Menu Add-ins” works fine for Access 97 through 2003.

One extra step may also be needed: If your Access 2007 add-in creates a Ribbon, and its buttons

have callback functions, you also need to include the VBA project’s name before the callback func-

tion name in each onactionargument in the USysRibbons table. Instead of just

onAction=”ListQueryFields”

you need

onAction=”Extras (Ribbon).ListQueryFields”/>

After making the above changes to the add-in’s system tables, compile the add-in’s code, and save

and close it. Now you should be able to install the add-in and run its menu add-in(s), and its Ribbon

buttons should work.