Access 2016 Advanced
Access 2016
Lesson 10 - Creating Macros
The following table provides a brief description of each action and argument:
Action
Argument
Description
AddMenu
Menu Name (req.), Menu Macro Name (req.), Status Bar Text Filter Name, Where Condition (one or both req.)
Adds a drop-down menu item to a custom menu bar.
Applies a filter or query to restrict or sort records.
ApplyFilter
Beep
None
Sounds a tone through the computer's speaker. Cancels the action that initiated the macro.
CancelEvent
None
Object Type, Object Name, Save (req.)
Close
Closes a specified window.
CloseDatabase
None
Closes the current database.
Locates the next record that meets criteria specified by a find. Locates the first record following the current record that meets criteria specified in the arguments.
FindNext
None
Find What (req.), Match (req.), Match Case (req.), Search (req.), Search As Formatted (req.), Only Current Field (req.), Find First (req.)
FindRecord
Activates the specified field or control. Activates the first control on a specified page.
GoToControl
Control name (req)
GoToPage
Page Number (req.), Right, Down (if a Right is specified, a Down must be specified and vice versa)
GoToRecord
Object Type, Object Name, Record (req.), Offset
Makes the specified record the current record.
Changes the mouse pointer to an hourglass while the macro is running. Prevents users from deleting database objects displayed in the Navigation Pane.
Hourglass
Hourglass On (req)
LockNavigationPan e
Lock
OFFICEPRO, Inc.
Page 107
Made with FlippingBook - Online magazine maker