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

Why Aren’t We Using Macros?

Although you can certainly use macros to automate simple applications, macros have certain limitations. For example, as you might have noticed when examining the list of available events in Chapter 17, many events require or return parameters that can be passed to or read from a Visual Basic procedure but not a macro. Also, even though you can write a macro to handle general errors in forms and reports, you can’t really analyze errors effectively within a macro nor do much to recover from an error. And as you saw in Chapter 18, the debugging facilities for macros are very simplistic.

When to Use Macros

Use macros in your application in any of the following circumstances:

  • Your application consists of only a few forms and ...

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