Access.2007.VBA.Bibl..

6. The name displayed in the “Add-Ins available” list is the one entered as the add-in’s name
   in the Designer, but curiously, the description entered into the Designer’s Description
   field does not appear on this dialog.


7. If your COM add-in doesn’t appear in the list of available add-ins, click the Add button to
   browse for it; after locating it, click OK in the Add Add-In dialog, as shown in Figure 13.12.

FIGURE 13.12

Browsing for a COM Add-in DLL file.

8. The COM add-in should now appear in the COM Add-Ins dialog. You can check its
   checkbox (if needed) and close the dialog; its button(s) should then appear on the Add-
   Ins tab of the Ribbon, in the appropriate context; for example, a button intended to dis-
   play on the Form Design toolbar (like the one shown in Figure 13.6) will appear when
   you have a form open in design view.

In Access 2000 through 2003, COM add-in buttons appeared on the designated toolbar

or menu; in the case of this add-in, that would be the form or report design toolbar. In

Access 2007, all the buttons appear directly on the Toolbar Commands group on the Add-Ins tab. If you

are running Windows Vista, you won’t see the Add-Ins tab unless you run Access as an administrator, as

described in Step 1 above.

You can clear the add-in’s checkbox to temporarily unload it, or you can select it and click Remove

to uninstall it completely.

Troubleshooting a COM Add-in ..............................................................................

If you copy the LNC Renaming.dll file to another computer, install the add-in, and find that you

get an error message when running it from its button, open the LNC Renaming.vpb file in VB 6

and make the DLL again; this should fix the problem.

NOTENOTE

Part III Adding More Functionality to Office