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
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 acCmdA
Constant
Value
Description
acCmdAboutMicrosoftAccess
35
Displays the About Access Information dialog
acCmdAddDataMacroAfterDelete
720
acCmdAddDataMacroAfterInsert
718
acCmdAddDataMacroAfterUpdate
718
acCmdAddDataMacroValidateChange
722
acCmdAddDataMacroValidateDelete
721
acCmdAddFromOutlook
583
Launches the Outlook Global Address Book
acCmdAddInManager
526
I assume that it opens the Add In Manager window
acCmdAddNamedDataMacro
723
acCmdAddToNewGroup
494
Adds an item to a newly created group
acCmdAddWatch
201
Adds a variable to the Watch Window
acCmdAdvancedFilterSort
99
Displays Query By Example form for filter
acCmdAlignBottom
46
Aligns the bottom edges of a selection of controls if no overlap else aligns top to bottom
acCmdAlignCenter
477
In Data Access Page design view aligns the centers of selected objects
acCmdAlignLeft
43
Aligns the left edges of a selection of controls if no overlap else abuts left edge to right edge
acCmdAlignmentAndSizing
478
I assume that it displays the Alignment toolbar
acCmdAlignMiddle
476
In Data Access Page design view aligns the middles of selected objects
acCmdAlignRight
44
Aligns the right edges of a selection of controls if no overlap else abuts left edge to right edge
acCmdAlignToGrid
47
Aligns selection to grid
acCmdAlignTop
45
Aligns the top edges of a selection of controls if no overlap else abuts top edge to bottom edge
acCmdAlignToShortest
153
Sizes selected controls to shortest
acCmdAlignToTallest
154
Sizes selected controls to tallest
acCmdAnalyzePerformance
283
Displays the Analyze Performance dialog
acCmdAnalyzeTable
284
Displays the Table Analyzer Wizard
acCmdAnchorBottomLeft
616
acCmdAnchorBottomRight
618
acCmdAnchorBottomStretchAcross
617
acCmdAnchorStretchAcross
611
acCmdAnchorStretchDown
613
acCmdAnchorStretchDownAcross
614
acCmdAnchorStretchDownRight
615
acCmdAnswerWizard
235
Displays the Help Find dialog
acCmdApplyAutoFormat1
648
acCmdApplyAutoFormat2
649
acCmdApplyAutoFormat3
650
acCmdApplyAutoFormat4
651
acCmdApplyAutoFormat5
652
acCmdApplyAutoFormat6
653
acCmdApplyAutoFormat7
654
acCmdApplyAutoFormat8
655
acCmdApplyAutoFormat9
656
acCmdApplyAutoFormat10
657
acCmdApplyAutoFormat11
658
acCmdApplyAutoFormat12
659
acCmdApplyAutoFormat13
660
acCmdApplyAutoFormat14
661
acCmdApplyAutoFormat15
662
acCmdApplyAutoFormat16
663
acCmdApplyAutoFormat17
664
acCmdApplyAutoFormat18
665
acCmdApplyAutoFormat19
66
acCmdApplyAutoFormat20
667
acCmdApplyAutoFormat21
668
acCmdApplyAutoFormat22
669
acCmdApplyAutoFormat23
670
acCmdApplyAutoFormat24
671
acCmdApplyAutoFormat25
672
acCmdApplyDefault
55
Apply's default formatting to selected control
acCmdApplyFilterSort
93
Apply's the filter entered in a Filter Design window
acCmdAppMaximize
10
Maximizes Access Window
acCmdAppMinimize
11
Minimize Access window
acCmdAppMove
12
Changes mouse into 4 headed arrow to enable the Access window to be moved
acCmdAppRestore
9
Restores Access window
acCmdAppSize
13
Size Access window
acCmdArrangeIconsAuto
218
Auto arrange icons
acCmdArrangeIconsByCreated
216
Arrange the icons in date created order
acCmdArrangeIconsByModified
217
Arrange the icons in date modified order
acCmdArrangeIconsByName
214
Arrange icons in database window in alphabetical order
acCmdArrangeIconsByType
215
Arranges icons by the type of object
acCmdAutoCorrect
261
Displays the AutoCorrect dialog
acCmdAutoDial
192
Automatically phones a selected number
acCmdAutoFormat
270
Displays the AutoFormat dialog
Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.