Datasheet

Discovering Code as You Go
588
When you convert a macro to VBA code, you actually convert all the macros
in the macro group to code. Follow these steps for the basic procedure of
converting macros to VBA:
1. Choose Macros from the top of the Navigation Pane. Or choose All
Access Objects and expand the Macros category.
2. Click the name of the macro you want to convert.
3. Click the Database Tools tab.
4. Click the Convert Macros to Visual Basic button shown at the mouse
pointer in Figure 1-17.
Figure 1-17:
Convert
Macros to
Visual Basic
button.
Figure 1-16:
Sample
TinyMacro
macro.
Figure 1-15:
Create a
new macro.
38_036494 bk08ch01.qxp 11/17/06 8:34 AM Page 588