Access 2002 Programming by Example

Creating Procedures

You have already created a procedure, but take a closer look at the process. Open any Access database. Under Objects, click Modules, and then click New. Click Insert, Procedure. You should see the Add Procedure window into which you enter the name of the procedure (see Figure 10.1). You can also select its type and scope, or you can elect to declare all local variables to be static. You can just as easily skip the insert procedure option and create your function or sub manually, but this saves you a little time.

Figure 10.1. You can use the Add Procedure dialog box to set options for your procedures.

Your choices for the ...