Microsoft Access 2010 Bible

Chapter 14: Debugging Your Access Applications

533

FIGURE 14.9

The Debug menu in the VBA code editor window contains valuable debugging tools.

FIGURE 14.10

Viewing a compile error

Tip
After compiling your application, you can’t choose Debug ➪ Compile (it’s grayed out). Before implementing an
application, you should make sure that your application is compiled.

Your database is named with a standard Windows name, such as Chapter14.accdb, but Access

uses an internal project name to reference the VBA code in your application. You’ll see this name

when you compile your database. When the database file is first created, the project name and the

Windows filename will be the same. The project name isn’t changed when you change the

Windows filename of the .accdb file. You can change the project name by choosing

Tools ➪ Project Name Properties (where Project Name is the current internal project name). (The

Project Name property is shown in Figure 14.13, a little later in this chapter.)

Compiling your database only makes sure that you have no syntax errors. The compiler can check

only for language problems by first recognizing the VBA statement and then checking to see that