Access.2007.VBA.Bibl..

(John Hannent) #1
Figure 13.6
Entering the COM add-in’s identifying information and other options in the Designer dialog.

The Designer code includes the procedures that implement the add-in’s functionality; they require
little (if any) modification from those that would run in an Access add-in.

Creating the LNC Control Renaming COM Add-in..................................................


The procedures that do the renaming of form and report controls in the LNC Control Renaming
COM add-in are basically the same as the LNC Rename Access add-in, which was covered in detail
in my earlier book Expert One-on-One Microsoft Access Application Development; this chapter concen-
trates on the differences needed to make the code work in a COM add-in.

For more details on the LNC Rename add-in, see my book Expert One-on-One Microsoft
Access Application Development(ISBN: 0764559044).

The SharedCode Module ..............................................................................

Starting with a project created from the COM add-in project template, in the SharedCode module,
I removed the standard declarations (the only declarations I need are the ones in the
AccessDesigner module), and I also removed the standard AddToCommandBarand
DeleteFromCommandBarfunctions. Because I needed to create (and remove) two command bar
buttons, intended specifically for the Access Form Design and Report Design toolbars, I placed
those procedures in the Access Designer.

CROSS-REFCROSS-REF


Part III Adding More Functionality to Office

Free download pdf