Microsoft Access 2010 Bible

(Rick Simeone) #1

Chapter 30: Using Access Macros


1081


Summary


In this chapter, you learned how to create a variety of different macros, from simple macros with
one action to complex macros containing many different actions that run only under certain condi-
tions. Using macro names, you saw how one macro object can hold many macros. You also com-
pared macros to VBA and converted a macro to a VBA module.


The addition of temporary variables allows you to store values for use anywhere in your applica-
tion, including VBA code. The new error-handling actions let you gracefully stop a macro when an
error occurs. These new features also make troubleshooting macros easier. You also created a
trusted embedded macro, which is stored in the control and moves around with the control.

Free download pdf