Microsoft Office Tutorials and References
In Depth Information
The Action Catalog lists a lot of actions. We can never find the one we want.
The solution? Type part of the action name in the Search box at the top of
the Action Catalog to display only actions that contain what you type. To
return to seeing all actions, click the Stop Filtering icon to the right of the
Specifying arguments to actions
After you select an action, Access displays its arguments — additional
information that Access needs to perform the action (refer to Figure 1-2, earlier in
this chapter). Click an argument’s box to set it.
Some arguments start out blank, whereas others start with a default value.
The OpenForm action, for example, has a View argument that specifies
which view you want the form to appear in. The default value for the View
argument is Form view. (You usually want forms to open in Form view.)
These arguments appear in many macro actions:
✦ View: View that Access opens the object in. The OpenForm action, for
example, includes the View argument, and you can choose the Form,
Design, Print Preview, Datasheet, or Layout argument from a
drop-down menu. These arguments are all the possible views for a form.
✦ Object Name: Name of the object (table, query, form, report, macro,
modules, or data access page) that the action affects. Access provides a
drop-down menu of the objects of that type in your database.
✦ Filter Name: Name of a query (or filter saved as a query) that
specifies which records to include in the action.
✦ Where Condition: Expression that specifies which records to include,
written in SQL (Structured Query Language). Click the Build button to
the right of the argument to display the Expression Builder. Book VIII,
Chapter 5 explains how to use SQL.
When you’ve specified the arguments for an action, you may not want the
action to occupy so much screen space. You can collapse the action by
clicking the minus (–) button to the left of the action so that the arguments
are listed on the same line as the action. You can expand the action again at
any time by clicking the plus (+) button.
Moving your actions around
You can change the order of the actions in a macro by clicking an action to
select it and then clicking the up or down arrow near the right end of the
action (refer to Figure 1-2, earlier in this chapter), or by dragging the action
up or down. You can delete the selected action by clicking the X at the right
end of the action.