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