Special Edition Using Access 97, Second Edition

Exploring the Module Window

You write Access VBA functions and procedures in the Module window. To display a Module window, click the Module tab of the Database window, and then double-click the name of the module you want to display. To open a new Access VBA module, click the New button. A Module code-editing window appears, as shown in Figure 26.8. This figure shows part of the IsItAReplica() function of the Startup module that is included in Access 97's Northwind.mdb example database. You choose the function or procedure to display from the procedures drop-down list at the upper-right portion of the Module window. The Module window incorporates a text editor, similar to Windows Notepad, in which you type your Access VBA code. Access VBA color-codes ...