Here is a complete list of RunCommand constants with a description of their function where I know what they do.
The list in Access Help and the one obtainable on the Microsoft Web Site are incomplete and contradict one another.
I have colour coded the list dependent on the version in which they first appeared -
Access 97, Access 2000, Access XP,
Access 2003, Access 2007 or Access 2010. Prior to Access 2007, all later
versions of Access recognise the earlier commands. See Known Problems for more details.
Some of these were retained for backwards compatibility only. If you spot any errors or can fill the gaps please
let me know.
links to code examples for that constant. Select the start letter,
ignoring the acCmd, of the constant.
Select the sixth letter of the acCmdConstant
Constants starting acCmdR
Moves to the first record
Moves to the last record
Moves to a new record
Moves to the next record
Moves to the previous record
Displays the Recover Design Master dialog
Redoes last thing that was undone
Displays the References dialog
Refreshes the data in the active window
Brandon Skeen tells me that he uses this command to refresh a sub form and all its fields behind an OnChange event
Used to refresh all linked SharePoint tables.
Opens the ActiveX Controls dialog
Opens the Relationships window
Removes all filters and sorts
Removes the selected table from the QBE grid
Allows the editing of the name of the object selected in the database window
Highlights column heading to enable renaming
Opens the Repair Database file selection dialog box. Note this cannot be used to repair the current database
Opens the Replace dialog. Available in both VBE and non-VBE views
Adds or removes report headers and footers
Resets running code
Displays the Resolve Replication Conflicts dialog
Displays the Row Height dialog
Runs a query
Opens the Run Macro dialog
Run a macro