Microsoft Access 2010 Bible

Part II: Programming Microsoft Access

392

Think of a module as a collection of procedures. Your Access databases can contain thousands of

modules, although most Access applications include only a few dozen standard modules.

Cross-Reference
You’ll see many examples of creating functions and procedures in Chapters 11 through 14.

For this example, you can use the Chapter10.accdb database or open a new blank database.

Add a new module by selecting the Create tab of the Access ribbon, and then clicking on the

Module button in the Other ribbon group (see Figure 10.8).

FIGURE 10.8

Adding a new module to an Access database

Access opens the VBA editor and adds a new module with a default name (see Figure 10.9).

FIGURE 10.9

The newly opened module in the VBA editor