Access.2007.VBA.Bibl..

(John Hannent) #1

  1. Now you can see the add-in project in the Project Explorer, and open its module(s) and
    work with them much like modules in the current database, as shown in Figure 14.14.


FIGURE 14.14
Opening an add-in module in the Visual Basic window of a database.

Though you can edit code in a library database after setting a reference to it, and run
the code to test whether the modifications fix a problem, the changes aren’t saved to
the library database, so save any modified code to a text file, which you can then copy and paste into
the library database when you next open it directly.

Interpreting Add-in Error Messages ........................................................................


You may get this error message (Figure 14.15) when running (or attempting to run) an add-in in
Access 2007.

FIGURE 14.15
An error message when running an add-in.

CAUTION CAUTION


Part III Adding More Functionality to Office

Free download pdf