Access.2007.VBA.Bibl..

FIGURE 14.6

An error when creating the Value field in the UsysRegInfo table.

If you copy the USysRegInfo table from another add-in, it has a default value of GenUniqueID()

for the Type field, and also has some useful information in the Description column telling you the

value needed for each field data type, as shown in Figure 14.7.

FIGURE 14.7

An imported USysRegInfo table with Description information.

Each type of add-in requires a set of records in the USysRegInfo table, as described in the following

sections. The Extras 2007 add-in that is the sample add-in for this chapter is a set of menu add-ins,

which will be described in detail; for the other add-in types I will reference two add-ins that I cre-

ated in earlier versions of Access.

You might think that add-ins would be found on the Add-Ins tab of the Ribbon in Access

2007 (this tab may not be visible if you are running Windows Vista). But this is not the

case. Your Access add-ins are located on the Add-ins menu of the Database Tools tab. The Add-Ins tab

has a set of menus like those in previous versions of Access, except that they don’t work. The purpose

of these non-functional menus is to display commands placed on the Access 2003 (or earlier) menus

by add-ins working with the CommandBars collection. This is a very awkward method of implement-

ing backwards compatibility; if you have such an add-in, you will probably want to redo it to place

commands on various tabs of the Ribbon, as described in Chapter 15.

NOTENOTE

Creating Access Add-ins 14