Table 10-3. Macro Actions and Their Descriptions
Adds a menu to a custom menu bar for a form or report. Each menu on the menu bar requires a separate AddMenu action.
Applies a filter or query to a table, form, or report.
Causes the computer to beep.
Cancels the event that caused the macro to run.
Closes the specified window or the active window if none is specified.
Copies the specified database object to a different Microsoft Access database or to the same database with a new name.
Deletes the specified object or the object selected in the Database window if no object is specified.
Hides or shows the results of a macro while it runs.
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.
Finds the first or next record that meets the specified criteria. Records can be found in the active form or datasheet.
Selects the specified field on the active datasheet or form.
Selects the first control on the specified page of the active form.
Makes the specified record the current record in a table, form, or query. Use to move to the first, last, next, or previous record.
Changes the mouse pointer to an hourglass while the macro runs.
Maximizes the active window.
Minimizes the active window.
Moves and/or changes the size of the active window.
Displays a message box containing a warning or informational message.
Opens a form in Form view, Design view, Print Preview, or Datasheet view.
Opens the specified Visual Basic module in Design view.
Opens a query in Datasheet view, Design view, or Print Preview.
Opens a report in Design view or Print Preview or prints the report immediately.
Opens a table in Datasheet view, Design view, or Print Preview.
Exports the specified database object to a Microsoft Excel file (.xls), rich-text file (.rtf), text file (.txt), or HTML file (.htm).
Prints the active database object. You can print datasheets, reports, forms, and modules.
Quits Microsoft Access.
Renames the specified object.
Completes any pending screen updates or pending recalculations of controls on the specified object or on the active object if none is specified.
Forces a requery of a specific control on the active database object.
Restores a maximized or minimized window to its previous size.
Starts another program, such as Microsoft Excel or Word.
Runs a Visual Basic Function procedure.
Runs a command from Microsoft Access's menusfor example, File Save.
Runs a macro.
Runs the specified SQL statement for an action query.
Saves the specified object or the active object if none is specified.
Selects a specified database object. You can then run an action that applies to that object.
Sends keystrokes to Microsoft Access or another active application. These keystrokes are processed as if you had typed them yourself on the keyboard.
Sends the specified database objects as an attachment in an e-mail.
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.
Sets the value for a control, field, or property on a form or report.
Turns all system messages on or off. This has the same effect as clicking OK or Yes in each message box.
Removes any applied filter from the active table, query, or form.
Shows or hides a built-in toolbar or a custom toolbar.
Stops all currently running macros.
Stops the currently running macro. Use to stop a macro when a certain condition is met.
Imports or exports data to or from the current database from or to another database.
Imports data from a spreadsheet file into the current database or exports data from the current database into a spreadsheet file.
Imports data from a text file into the current database or exports data from the current database into a text file.