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

UNDERSTANDING WHERE MACROS END AND CODE BEGINS

Many developers who get into Access skip over the step of using macros to automate applications. But there are some tasks that must be performed using macros rather than code.

When Are Macros Necessary?

The Access team at Microsoft have worked hard to whittle down the need to use macros. The tasks that macros are still needed for are as follows:

• You use Autokeys macros create key combinations. A common example is using ^P to print (where ^ is used for the Ctrl key). Third-party vendors and developers who are creating “Office-compatible” applications use Autokeys to include necessary key combinations.

• You can use Access as a DDE server for other Windows applications. When another application wants ...