The following table groups actions into functional categories.
Table 7 - Actions
Category | Description | Action |
---|---|---|
Data in forms and reports | Restrict data | ApplyFilter |
Move through data | FindNext, FindRecord, GoToControl, GoToPage, GoToRecord | |
Requery the source of a control | Requery | |
Remove an applied filter and display all records | ShowAllRecords | |
Execution | Carry out a command | DoMenuItem |
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 | |
Category | Event | Occurs When |
Object Manipulation | Copy or rename an object | CopyObject, Rename |
Delete an object | DeleteObject | |
Move or resize a window | Maximize, Minimize, MoveSize, Restore | |
Open or close a database object | Close, OPenForm, OpenModule, OpenQuery, OpenReport, OpenTable | |
Print a database object | PrintOut | |
Save a database object | Save | |
Select a database object | SelectObject | |
Set the value of a field, control, or property | SetValue | |
Complete any pending screen updates for a specified database object | RepaintObject | |
Miscellaneous | Create and modify a custom menu bar or shortcut menu for a form | AddMenu, SetMenuItem |
Display information on the screen | Echo, Hourglass, MsgBox, SetWarnings | |
Generate keystrokes | SendKeys | |
Display or hide the toolbar | ShowToolbar | |
Generate sound from the computer's speaker | Beep |