MS Access - Macro Actions

Category

Task

Action

Data in forms and reports

Restrict data

ApplyFilter

Move through data

FindNext, FindRecord, GoToControl, GoToPage, GoToRecord

Execution

Carry out a command

RunCommand

Exit Microsoft Access

Quit

Run a macro, procedure, or query

OpenQuery, RunCode, RunMacro, RunSQL

Run another application

RunApp

Stop execution

CancelEvent, Quit, StopAllMacros, StopMacro

Import/export

Send Microsoft Access objects to other applications

OutputTo, SendObject

Transfer data between Microsoft Access and other data formats

TransferDatabase, TransferSpreadsheet, TransferText

Object manipulation

Copy, rename, or save an object

CopyObject, Rename, Save

Delete an object

DeleteObject

Move or resize a window

Maximize, Minimize, MoveSize, Restore

Open or close an object

Close, OpenForm, OpenModule, OpenQuery, OpenReport, OpenTable

Print an object

OpenForm, OpenQuery, OpenReport, PrintOut

Select an object

SelectObject

Set the value of a field, control, or property

SetValue

Update data or the screen

RepaintObject, Requery, ShowAllRecords

Miscellaneous

Create a custom menu bar, a custom shortcut menu, global menu bar, or global shortcut menu

AddMenu

Set the state of menu items on a custom menu bar or global menu bar

SetMenuItem

Display information on the screen

Echo, Hourglass, MsgBox, SetWarnings

Generate keystrokes

SendKeys

Display or hide the built-in or custom command bar

ShowToolbar

Sound a beep

Beep