Function Procedures, Sub Procedures, and Modules

Visual Basic for Applications (VBA) is the programming language provided with Office applications, such as Access 2002. The three types of programming structures used in VBA code are sub procedures, function procedures, and property procedures. You can think of these as your “bread and butter” for automating your database. This chapter covers the first two types.

✓ For more information about procedures, see “Functions Versus Subs” in Chapter 10, “Customizing Your Access Database.”

The place to write VBA code in Access is in a module. A module is a set of VBA procedures that are stored together as a unit. Modules don’t run; they contain procedures that run. The two types of Access modules are standard ...

Get Access 2002 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.