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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access