Table 10-3. 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. |
