Access 2016 Advanced
Access 2016
Lesson 10 - Creating Macros
Action
Argument
Description
Updates the data in a specified control of an active object or updates itself if no control is specified. Restores a maximized or minimized window to its previous size. Runs a Microsoft Access Basic Function procedure.
Requery
Control Name
Restore
None
RunCode
Function Name (req)
RunCommand
Command (req)
Performs a menu command.
RunMacro
Macro Name (req.), Repeat Count, Repeat Expression Object Type, Object Name, Record, Where Condition Object Type (req.), Object Name (req.), In Database Window (req.)
Runs a macro.
SearchForRecord
Searches for a specific record in a table, query, form or report.
SelectObject
Selects an object.
SetDisplayedCatego ries
Specifies which categories are displayed under Navigate to Category in the title bar of the Navigation Pane. Sets the appearance of a command that appears in a custom menu. Sets a property for a control on a form or report. Creates a temporary variable and sets it to a specific value. Removes any applied filter from the applicable active object and displays all records. Pauses macro execution and opens the Macro Single Step dialog box. Stops all currently running macros.
Show, Category
SetMenuItem
Menu Index (req.), Command Index (req.), Subcommand Index, Flag (req.) Control Name, Property, Value
SetProperty
SetTempVar
Name, Expression
ShowAllRecords
None
SingleStep
None
StopAllMacros
None
OFFICEPRO, Inc.
Page 109
Made with FlippingBook - Online magazine maker