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.
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.
Either from the open macro group or from the highlighted macro group in the database ...