FIGURE 15.14
A security warning when attempting to install an Access add-in for Access 2007 running on Windows
Vista.See PC Magazine Windows Vista Security Solutions(Wiley, 2007) for more information
on dealing with Vista security issues.In Windows Vista, callback functions won’t run from Ribbon buttons unless you include
the name of the add-in database project before the function name, as I have done in the
XML code listed below.The technique for creating the Ribbon XML and storing it in a table is the same as for a regular
Access 2007 database, as described in the previous section. The Extras (Ribbon) library database
has only one add-in with three records in its USysRegInfo table, to load the ExtrasRibbon from the
USysRibbons table. Its XML code is listed next:<customUI
xmlns=”http://schemas.microsoft.com/office/2006/01/customui”>
<ribbon startFromScratch=”false”>
<tabs>
<tab id=”dbCustomTab”
label=”Extras”
visible=”true”>
<group id=”dbListingGroup”
label=”Listing Fields”>
<button id=”btnListTableFields”
label=”List Table Fields”
enabled=”true”
imageMso=”CreateTable”
size=”normal”
onAction=”Extras(Ribbon).ListTableFields”/>
<button id=”btnListQueryFields”
label=”List Query Fields”
enabled=”true”
imageMso=”CreateQueryInDesignView”
size=”normal”
onAction=”Extras(Ribbon).ListQueryFields”/>
<button id=”btnOpenOptionsDialog”
label=”Select Options”
enabled=”true”
imageMso=”CreateFormBlankForm”
size=”normal”
onAction=”Extras(Ribbon).ExtrasOptions”/>NOTENOTE
CROCROSSSS-REF-REF
Part III Adding More Functionality to Office