Datasheet

Chapter 1
46
Try It Out Converting a Macro to VBA
Your first sight of the Visual Basic Editor can be a bit daunting. Don't panic!
We'll lead you through all the details as we continue through the book.
1. Load up the database file IceCream.mdb. In the Database window, select the Macros
tab and then the macNextButton macro that we created earlier.
2. Select File and then Save As… from the main menu.
3. When the Save As dialog appears select As Module and click OK:
4. Another dialog appears. Just accept the default settings of Add error handling and
Include macro comments and press the Convert button:
5. Access will now open the Visual Basic editor and finish the conversion. When the
conversion is complete, click OK.
6. Double-click on the new module that Access has created for us in the project viewer pane: