Access.2007.VBA.Bibl..

TABLE 14.1

Types of Access Add-ins

Wizard Builder Menu Add-in

Called when a new table, Lets you set properties in Not context-specific, called from
query, form, report, or design view the Add-ins menu
control is created

Subtypes

Table Wizards Property Builders

Query Wizards Expression Builders

Form Wizards

Report Wizards

Control Wizards

Creating a Library Database ..............................................................................................

This section walks you through creating a library database. To do this, start by creating a new

Access database in the database format of your choice. You can create and save a database directly

in the older .mda library database format, but for the new .accda format, you need to first create

the database as an .accdb database, then change its extension to .accda later, in an Explorer pane,

ignoring the dire warning that the file might become unusable.

Next, you need to create the USysRegInfo table to hold the crucial Registry information. As a short-

cut, you can import this table from another library database (either .mda or .accda format), if you

have one available; you may have to first make system tables visible, as described in this section. I

recommend importing this table, because it will save you time in entering some very cryptic infor-

mation, though of course you have to add (or modify) rows in the table with specific data for your

add-in.

The USysRegInfo table is a system table, so you won’t see it (or be able to edit its contents) unless

you check the “Show System Objects” checkbox. In previous versions of Access, this checkbox was

located on the View page of the Options dialog; in Access 2007 it is on the Navigation Options dia-

log, which can be opened in the following manner:

1. Click the Office button in the upper-left corner of the Access window.


2. Next, click the Access Options button on the Office menu, as shown in Figure 14.2.

Creating Access Add-ins 14