• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Exploring the VBA Editor

You write VBA functions and procedures in the VBA editor. To open the VBA editor, click the Module shortcut of the Database window, and then double-click the name of the module you want to display. To open a new VBA module, click the New button; the VBA editor window appears with default Options set, as shown in Figure 27.8. The VBA editor window incorporates a text editor, similar to Windows Notepad, in which you type your VBA code. VBA color-codes keywords and comments. By default, the VBA editor opens with all of its windows docked.

The Toolbar of the Module Window

Table 27.3 lists the purpose of each item in the toolbar of the Module window (refer to Figure 27.8) and the menu commands and key combinations that you can substitute for toolbar components. Buttons marked with an asterisk (*) in the Item column were changed by Access 2000. There are no Access 2002 changes to the editor other than the appearance of active toolbar buttons, elimination of the Office Assistant barrier to obtaining online help for VBA, and the addition of the Ask a Question text box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint