Macro Actions and Their Descriptions
| Action | Description |
|---|---|
| AddMenu | Adds a menu to a custom menu bar for a form or report. Each menu on the menu bar requires a separate AddMenu action. |
| ApplyFilter | Applies a filter or query to a table, form, or report. |
| Beep | Causes the computer to beep. |
| CancelEvent | Cancels the event that caused the macro to run. |
| Close | Closes the specified window or the active window if none is specified. |
| CopyObject | Copies the specified database object to a different Microsoft Access database or to the same database with a new name. |
| DeleteObject | Deletes the specified object or the object selected in the Database window if no object is specified. |
| Echo | Hides or shows the results of a macro while it runs. |
| FindNext | Finds the next record that meets the criteria specified with the most recent FindRecord action or Find dialog box. Use to move successively through records that meet the same criteria. |
| FindRecord | Finds the first or next record that meets the specified criteria. Records can be found in the active form or datasheet. |
| GoToControl | Selects the specified field on the active datasheet or form. |
| GoToPage | Selects the first control on the specified page of the active form. |
| GoToRecord | Makes the specified record the current record in a table, form, or query. Use to move to the first, last, next, or previous record. |
| Hourglass | Changes the mouse pointer to an hourglass while the macro runs. |
| Maximize | Maximizes the active window. |
| Minimize | Minimizes the active window. |
| MoveSize | Moves and/or changes the size of the active window. |
| MsgBox | Displays a message box containing a warning or informational message. |
| OpenForm | Opens a form in Form view, Design view, Print Preview, or Datasheet view. |
| OpenModule | Opens the specified Visual Basic module in Design view. |
| OpenQuery | Opens a query in Datasheet view, Design view, or Print Preview. |
| OpenReport | Opens a report in Design view or Print Preview or prints the report immediately. |
| OpenTable | Opens a table in Datasheet view, Design view, or Print Preview. |
| OutputTo | Exports the specified database object to a Microsoft Excel file (.xls), rich-text file (.rtf), text file (.txt), or HTML file (.htm). |
| PrintOut | Prints the active database object. You can print datasheets, reports, forms, and modules. |
| Quit | Quits Microsoft Access. |
| Rename | Renames the specified object. |
| RepaintObject | Completes any pending screen updates or pending recalculations of controls on the specified object or on the active object if none is specified. |
| Requery | Forces a requery of a specific control on the active database object. |
| Restore | Restores a maximized or minimized window to its previous size. |
| RunApp | Starts another program, such as Microsoft Excel or Word. |
| RunCode | Runs a Visual Basic Function procedure. |
| RunCommand | Runs a command from Microsoft Access's menusfor example, File » Save. |
| RunMacro | Runs a macro. |
| RunSQL | Runs the specified SQL statement for an action query. |
| Save | Saves the specified object or the active object if none is specified. |
| SelectObject | Selects a specified database object. You can then run an action that applies to that object. |
| SendKeys | Sends keystrokes to Microsoft Access or another active application. These keystrokes are processed as if you had typed them yourself on the keyboard. |
| SendObject | Sends the specified database objects as an attachment in an e-mail. |
| SetMenuItem | Sets the state of menu items (enabled or disabled, checked or unchecked) on custom menus. Works only on custom menus created using menu bar macros. |
| SetValue | Sets the value for a control, field, or property on a form or report. |
| SetWarnings | Turns all system messages on or off. This has the same effect as clicking OK or Yes in each message box. |
| ShowAllRecords | Removes any applied filter from the active table, query, or form. |
| ShowToolbar | Shows or hides a built-in toolbar or a custom toolbar. |
| StopAllMacros | Stops all currently running macros. |
| StopMacro | Stops the currently running macro. Use to stop a macro when a certain condition is met. |
| TransferDatabase | Imports or exports data to or from the current database from or to another database. |
| TransferSpreadsheet | Imports data from a spreadsheet file into the current database or exports data from the current database into a spreadsheet file. |
| TransferText | Imports data from a text file into the current database or exports data from the current database into a text file. |
by updated