Chapter 5. Building Procedures


Types of Procedures 67

Passing Arguments 71

Error Handling 73

Types of Procedures

The basic containers for your VBA code are procedures, which hold collections of VBA code statements that are executed line by line. Although individual statements can be executed from the Immediate window of the VBE, you must place your code into procedures to run the statements from your applications. Your procedures are placed into modules, which can be attached to a form or a report object, or they can stand alone. We’ve shown you some short procedures in previous chapters, but this chapter goes into creating and using procedures in more depth.

The first thing to understand is that there are two main kinds of procedures: ...

Get Microsoft® Office Access 2007 VBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.