Microsoft Access 2010 Bible

(Rick Simeone) #1

Part VII: Appendixes


1264


developers to embrace. One neat feature of the new macros is the ability to schedule macros to
run through Outlook. This is a very powerful feature for automatic imports, exports, or report
generation.

Most important, perhaps, is the new macro editor (shown in Figure B.13). The new macro editor is
much easier to use than in previous versions of Access. All the available macro actions are listed in
the Action Catalog on the right side of the macro editor, while the macro itself is displayed as a
top-down, hierarchical listing of macro actions and their properties.

FIGURE B.13
The macro editor provides a friendly user interface for building macros.

In Figure B.13, the OpenForm action is being added to the AutoExec macro. Notice that all the
properties for the OpenForm action are visible in one place, and the position of OpenForm, rela-
tive to other actions in the macro, is obvious and easily understood. What can’t be shown in this
figure are the colors applied to various objects and text in the macro editor. Comments are green,
as are the up and down arrows used for repositioning a macro action within the editor.

The same macro editor is used when creating embedded macros for form and report controls, or
data macros attached to Access tables.

50_475348-bapp02.indd 126450_475348-bapp02.indd 1264 4/1/10 2:01 PM4/1/10 2:01 PM

Free download pdf