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 acCmdI
Constant
Description
Value
acCmdImport
Displays the File, Get External Data, Import dialog box
257
acCmdImportAttachAccess
544
acCmdImportAttachdBase
552
acCmdImportAttachExcel
545
acCmdImportAttachHTML
550
acCmdImportAttachLotus
554
acCmdImportAttachODBC
549
acCmdImportAttachOutlook
551
acCmdImportAttachParadox
553
acCmdImportAttachSharePointList
547
acCmdImportAttachText
546
acCmdIndent
Indents line of code
205
acCmdIndexes
Toggles display of the Indexes dialog
152
acCmdInsertActiveXControl
Displays the Insert ActiveX Control dialog
258
acCmdInsertChart
Inserts a chart
293
acCmdInsertFile
This is not to insert a file into a module which is acCmdInsertFileIntoModule
39
acCmdInsertFileIntoModule
Displays the Insert File dialog
118
acCmdInsertHyperlink
Displays the Insert Hyperlink dialog
259
acCmdInsertLookupColumn
Displays the LookUp wizard
273
acCmdInsertLookupField
Starts the Lookup Wizard
291
acCmdInsertMovieFromFile
469
acCmdInsertObject
Opens the Insert Object Dialog
33
acCmdInsertPage
Inserts a new page to a tab control
331
acCmdInsertPicture
Displays the Insert Picture dialog
222
acCmdInsertPivotTable
470
acCmdInsertProcedure
Displays the Insert Procedure dialog
262
acCmdInsertQueryColumn
Insets a column into the QBE grid
82
acCmdInsertRows
Inserts rows
187
acCmdInsertSpreadsheet
471
acCmdInsertSubdatasheet
499
acCmdInsertTableColumn
Inserts column into a table
272
acCmdInsertUnboundSection
472
acCmdInvokeBuilder
Open the Builder dialog
178