Microsoft Office® Access 2007 Inside Out

Converting Your Macros to Visual Basic

As you’ll learn in the rest of this book, Visual Basic, rather than macros, is what you should use to automate any serious applications. If you’ve spent some time getting familiar with programming in Access in macros but would now like to move to Visual Basic, you’re in luck! Access provides a handy tool to convert the actions in macros called from events on your forms and reports to the equivalent Visual Basic statements.

To see how this works, open the WeddingList form in Design view. On the Database Tools tab, in the Macro group, click the Convert Form’s Macros To Visual Basic button, as shown in Figure 18-41.

Figure 18-41. Access includes a command to convert a form’s macros to Visual Basic.

In the next ...