O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required