Extras Options

This selection opens a setup dialog (shown in Figure 14.21) with an option group for selecting the folder for storing database backups, and two subforms listing the table and query prefixes for tables and queries you would like to omit when using the List Query Fields or List Table Fields add-ins. These tables are pre-filled with system prefixes, dashes and underscores, and "Copy Of" (the latter is the prefix used in Access 2007 object copies).

If you select the Custom Path option, a command button is enabled that opens a Folder Picker dialog where you can select a custom backup folder. The backup choice is stored separately for each database, using database properties; the prefixes, however, are stored in the code database, so they are the same for all databases.

You don't need to open the Extras setup dialog to use the other menu add-ins; if you haven't made any selections, the code uses the default backup choice of option 2 (Backups folder under database folder), and the standard prefixes.

FIGURE 14.21

The Extras 2007 add-ins Setup dialog.

FIGURE 14.21

The Extras 2007 add-ins Setup dialog.

0 0

Post a comment