[ Team LiB ] Previous Section Next Section

Q&A

Q1:

What types of applications most benefit from the use of macros?

A1:

Single-user or small departmental applications most benefit from the use of macros.

Q2:

What are some of the main limitations of macros?

A2:

You cannot include error handling, user-defined functions, variables, parameters, OLE automation, DDE, transaction processing, or Windows API functions within macros. Macros do not allow you to process table records a row at a time or create database objects at runtime. It is also much more difficult to debug macros than it is to debug VBA code.

Q3:

What is the purpose of the Macro Names column of a macro?

A3:

The Macro Names column allows you to place multiple routines in one macro.

    [ Team LiB ] Previous Section Next Section