O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

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 EXISTING MACROS TO VBA CODE

One feature of Access 2000 is the capability to convert your current macros into VBA code. This is great for two reasons:

  • You can learn how to code VBA.

  • You can use error handling around the commands.

Tip

Before converting your macros, be sure to fill in the Description property for as many macros as possible. Access will carry these descriptions over into comments.

To show you how to convert macros, I'll use the MacrosToConvert macro group. This group (see Figure 1.2) can be found in \Examples\Chap01\Chap01. mdb on the CD-ROM that accompanies this book.

Figure 1.2. The MacrosToConvert macro group will be converted into VBA.

Either from the open macro group or from the highlighted macro group in the database ...

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