Full List of All RunCommand Constants

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.

Code Link 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
Code ExampleacCmdAboutMicrosoftAccess
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
Code ExampleacCmdAddToNewGroup
494
Adds an item to a newly created group
acCmdAddWatch
201
Adds a variable to the Watch Window
Code ExampleacCmdAdvancedFilterSort
99
Displays Query By Example form for filter
Code ExampleacCmdAlignBottom
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
Code ExampleacCmdAlignLeft
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
Code ExampleacCmdAlignRight
44
Aligns the right edges of a selection of controls if no overlap else abuts left edge to right edge
Code ExampleacCmdAlignToGrid
47
Aligns selection to grid
Code ExampleacCmdAlignTop
45
Aligns the top edges of a selection of controls if no overlap else abuts top edge to bottom edge
Code ExampleacCmdAlignToShortest
153
Sizes selected controls to shortest
Code ExampleacCmdAlignToTallest
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
 
acCmdAnchorTopLeft
610
 
acCmdAnchorTopRight
612
 
Code ExampleacCmdAnswerWizard
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
 
Code ExampleacCmdApplyDefault
55
Apply's default formatting to selected control
Code ExampleacCmdApplyFilterSort
93
Apply's the filter entered in a Filter Design window
Code ExampleacCmdAppMaximize
10
Maximizes Access Window
Code ExampleacCmdAppMinimize
11
Minimize Access window
Code ExampleacCmdAppMove
12
Changes mouse into 4 headed arrow to enable the Access window to be moved
Code ExampleacCmdAppRestore
9
Restores Access window
Code ExampleacCmdAppSize
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
Code ExampleacCmdAutoCorrect
261
Displays the AutoCorrect dialog
acCmdAutoDial
192
Automatically phones a selected number
acCmdAutoFormat
270
Displays the AutoFormat dialog

© 1998 - 2011 Terry Wickenden TKW Design Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.