Here is a complete list of RunCommand constants with a description of their function where I know what they do.
Both the list in Access Help and the list 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 or Access 2007. 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
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Constants starting acCmdR
Constant
Description
Value
acCmdRecordsGoToFirst
Moves to the first record
67
acCmdRecordsGoToLast
Moves to the last record
68
acCmdRecordsGoToNew
Moves to a new record
28
acCmdRecordsGoToNext
Moves to the next record
65
acCmdRecordsGoToPrevious
Moves to the previous record
66
acCmdRecoverDesignMaster
Displays the Recover Design Master dialog
265
acCmdRedo
Redoes last thing that was undone
199
acCmdReferences
Displays the References dialog
260
acCmdRefresh
Refreshes the data in the active window
18
acCmdRefreshPage
Brandon Skeen tells me that he uses this command to refresh a sub form and all its fields behind an OnChange event
297
acCmdRefreshSharePointList
626
acCmdRegisterActiveXControls
Opens the ActiveX Controls dialog
254
acCmdRelationships
Opens the Relationships window
133
acCmdRemoveAllFilters
644
acCmdRemoveFilterFromCurrentColumn
643
acCmdRemoveFilterSort
Removes all filters and sorts
144
acCmdRemoveFromLayout
582
acCmdRemoveTable
Removes the selected table from the QBE grid
84
acCmdRename
Allows the editing of the name of the object selected in the database window
143
acCmdRenameColumn
Highlights column heading to enable renaming
274
acCmdRepairDatabase
Opens the Repair Database file selection dialog box. Note this cannot
be used to repair the current database
6
acCmdReplace
Opens the Replace dialog. Available in both VBE and non-VBE views
29
acCmdReportHdrFtr
Adds or removes report headers and footers
37
acCmdReset
Resets running code
124
acCmdResolveConflicts
Displays the Resolve Replication Conflicts dialog
266
acCmdRowHeight
Displays the Row Height dialog
116
acCmdRun
Runs a query
181
acCmdRunMacro
Opens the Run Macro dialog
31
acCmdRunOpenMacro
Run a macro
338