O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

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 user interface macros to automate applications, macros have certain limitations. For example, as you might have noticed when examining the list of available events in Chapter 19, many events require or return parameters that can be passed to or read from a Visual Basic procedure but not a macro. And as you saw in Chapter 20, and Chapter 21, the debugging facilities for macros are not as robust as for Visual Basic.

When to Use Macros

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

  • You are working with a web database.

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

  • You need to build a simple application that is automated using only trusted macro actions so that ...

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