Microsoft Access 2010 Bible

Part II: Programming Microsoft Access

412

or opening parenthesis. The procedure can be a built-in function or subroutine or one that you’ve

written yourself in Access VBA.

Auto Data Tips

The Auto Data Tips option displays the value of variables when you hold the mouse cursor over a

variable with the module in break mode. Auto Data Tips is an alternative to setting a watch on the

variable and flipping to the Debug window when Access reaches the break point.

Cross-Reference
Debugging Access VBA is described in Chapter 14.

The Project Properties dialog box

All the code components in an Access application, including all the modules, procedures, variables,

and other elements are aggregated as the application’s VBA project. The VBA language engine

accesses modules and procedures as members of the project. Access manages the code in your appli-

cation by keeping track of all the code objects that are included in the project, which is different than

and separate from the code added into the application as runtime libraries and wizards.

Each Access project includes a number of important options. The Project Properties dialog box

(shown in Figure 10.22) contains a number of settings that are important for developers. Open the

Project Properties dialog box by opening a module in the code window, and choosing

Tools ➪ Project Name Properties (where Project Name is the name of your database’s project).

FIGURE 10.22

The Project Properties dialog box contains a number of interesting options.