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

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