Datasheet

Finding VBA Code
574
To create a new module, click the Create tab. Then click the arrow under the
Macros button and choose Module (Figure 1-4). The Visual Basic Editor
opens.
Standard modules don’t show up automatically in the shutter bar, not even
when you’re viewing all Access object types. To view standard modules in
your database, you have to click the drop-down button and choose Modules,
as in Figure 1-5. If you’ve already created and saved a standard module, you
can open it by double-clicking its name. If the current database contains no
standard Modules, you won’t even see Modules as a category.
Regardless of whether you create or open a module, you end up in the Visual
Basic Editor. The editor is a completely separate program with its own
taskbar button. The editor retains the old-style Windows look and feel. We
cover that in more detail in a moment. For now, keep in mind that you can
close the Visual Basic Editor and return to Access at any time. Just click the
Close (X) button in the Editor’s upper-right corner.
Figure 1-5:
Open a
pane to see
standard
modules.
Figure 1-4:
Create a
new
module.
38_036494 bk08ch01.qxp 11/17/06 8:34 AM Page 574