Access.2007.VBA.Bibl..

FIGURE 14.5

System tables in the Navigation Pane.

TABLE 14.2

The USysRegInfo Table Fields

Field Data Type Usage

Subkey Text The name of the Registry subkey where a specific Registry setting is stored; can

be either HKEY_CURRENT_ACCESS_PROFILE or HKEY_LOCAL_MACHINE.

For Access add-ins, the HKEY_CURRENT_ACCESS_PROFILE is preferable,

because it automatically uses the Registry section for the running version of

Access, allowing the same add-in to work in multiple Access versions.

Type Number The type of entry to create; can be key (0), string (1), or DWORD (4)

ValName Text The name of the Registry value

Value Text The value of the Registry value

If you create the USysRegInfo table from scratch, you will get an error when entering

the name “Value” for the last field (as shown in Figure 14.6). This is because Microsoft

has violated its own rules by giving a field a name that is a reserved word (in this case, a property

name). However, you can save the field, and it does work. Don’t change the field name, because each

field in this table must have a specific name to work correctly.

NOTENOTE

Part III Adding More Functionality to Office