RunCommand Macro Action
You can use the RunCommand action to run a built-in Microsoft Office Access 2007 command.
Setting
The RunCommand action has the following action argument.
| Action argument | Description |
|---|---|
| Command | The name of the command you want to run. The Command box shows the available built-in commands in Access, in alphabetical order. This is a required argument. |
Remarks
You can use the RunCommand action to run an Access command from a custom menu bar, global menu bar, custom shortcut menu, or global shortcut menu.
You can use the RunCommand action in a macro with conditional expressions to run a command depending on certain conditions.
Note Clicking the Microsoft Office Button.gif "Button image")
shows the most recently used databases. You can click one of these databases instead of clicking Open. These database items don't appear in the drop-down list box for the Command argument, and aren't available by using the RunCommand action in a macro.
When you convert an Access database from a previous version of Access, some commands may no longer be available. A command may have been renamed, moved to a different menu, or may no longer be available in Access. The DoMenuItem actions for such commands can't be converted to RunCommand actions. When you open the macro, Access will display a RunCommand action with a blank Command argument for such commands. You must edit the macro and enter a valid command argument, or delete the RunCommand action.
To run the RunCommand action in a Visual Basic for Applications (VBA) module, use the RunCommand method of the Application object. (This is equivalent to the RunCommand method of the DoCmd object.)