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 acCmdI
Constant
Value
Description
acCmdImport
257
Displays the File, Get External Data, Import dialog box
acCmdImportAttachAccess
544
Opens an Access import dialog box
acCmdImportAttachdBase
552
Opens a dBase import dialog box
acCmdImportAttachExcel
545
Opens an Excel import dialog box
acCmdImportAttachHTML
550
Opens an HTML import dialog box
acCmdImportAttachLotus
554
Opens a Lotus import dialog box
acCmdImportAttachODBC
549
Opens an ODBC import dialog box
acCmdImportAttachOutlook
551
Opens an Outlook import dialog box
acCmdImportAttachParadox
553
Opens a Paradox import dialog box
acCmdImportAttachSharePointList
547
Opens a Sharepoint import dialog box
acCmdImportAttachText
546
Opens a Text import dialog box
acCmdImportAttachXML
548
Opens an XML import dialog box
acCmdIndent
205
Indents line of code
acCmdIndexes
152
Toggles display of the Indexes dialog
acCmdInsertActiveXControl
258
Displays the Insert ActiveX Control dialog
acCmdInsertChart
293
Inserts a chart
acCmdInsertFile
39
This is not to insert a file into a module which is acCmdInsertFileIntoModule
acCmdInsertFileIntoModule
118
Displays the Insert File dialog
acCmdInsertHyperlink
259
Displays the Insert Hyperlink dialog
acCmdInsertLookupColumn
273
Displays the LookUp wizard
acCmdInsertLookupField
291
Starts the Lookup Wizard
acCmdInsertMovieFromFile
469
acCmdInsertNavigationButton
724
acCmdInsertObject
33
Opens the Insert Object Dialog
acCmdInsertPage
331
Inserts a new page to a tab control
acCmdInsertPicture
222
Displays the Insert Picture dialog
acCmdInsertPivotTable
470
acCmdInsertProcedure
262
Displays the Insert Procedure dialog
acCmdInsertQueryColumn
82
Insets a column into the QBE grid
acCmdInsertRows
187
Inserts rows
acCmdInsertSpreadsheet
471
acCmdInsertSubdatasheet
499
acCmdInsertTableColumn
272
Inserts column into a table
acCmdInsertUnboundSection
472
acCmdInvokeBuilder
178
Open the Builder dialog
Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.