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 acCmdE

Constant
Value
Description
Code ExampleacCmdEditHyperlink
325
Allows the editting of a Hyperlink
acCmdEditingAllowed
70
I think that this is something to do with the Editing Mode of a form
acCmdEditListItems
607
 
acCmdEditRelationship
151
Displays the Edit Relationship dialog
acCmdEditTriggers
384
I think that this is probalby to do with setting triggers in an Access Data Project
acCmdEditWatch
202
Opens the Edit Watch dialog
Code ExampleacCmdEncryptDecryptDatabase
5
Opens the Encrypt/Decrypt Database dialog
acCmdEnd
198
Stops the running of a procedure
Code ExampleacCmdExit
3
Closes Access completely
acCmdExport
487
Export database objects to an existing Microsoft Access database or Microsoft Access project
acCmdExportAccess
559
 
acCmdExportdBase
565
 
acCmdExportExcel
556
 
acCmdExportFixedFormat
592
 
acCmdExportHTML
564
 
acCmdExportLotus
567
 
acCmdExportODBC
562
 
acCmdExportParadox
566
 
acCmdExportRTF
558
 
acCmdExportSharePointList
557
 
acCmdExportSnapShot
563
 
acCmdExportText
560
 
acCmdExportXML
561
 

© 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.