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 acCmdP
Constant
Value
Description
acCmdPageHdrFtr
182
Toggles display of the page header and footer
acCmdPageNumber
225
Displays the Page Number dialog
acCmdPageProperties
467
In Data Access Page desing view brings up the page properties
acCmdPageSetup
32
Opens the Page Setup dialog
acCmdParameterInfo
305
If not using autofill shows the list of arguments for a function
acCmdPartialReplicaWizard
524
Starts the Partial Replica Wizard in a Design Master database
acCmdPaste
191
Pastes from the clipboard. Available in both VBE and non-VBE views
acCmdPasteAppend
38
Pastes a copied record as a new record
acCmdPasteAsHyperlink
490
I think this is the same as Edi, Paste as Hyperlink into a hyperlink field
acCmdPasteSpecial
64
Displays the Paste Special dialog
acCmdPivotAutoAverage
416
Inserts an average for the selected column in a pivot table
acCmdPivotAutoCount
413
Inserts a count for the selected column in a pivot table
acCmdPivotAutoFilter
398
Apply/remove a previously applied filter from a Pivot Table
acCmdPivotAutoMax
398
Inserts a maximum field for the selected column in a pivot table
acCmdPivotAutoMin
414
Inserts a minimum field for the selected column in a pivot table
acCmdPivotAutoStdDev
417
Inserts a standard deviation calculation field for the selected column in a pivot table
acCmdPivotAutoStdDevP
419
Inserts a standard deviation population calculation field for the selected column in a pivot table
acCmdPivotAutoSum
412
Inserts a sum calculation field for the selected column in a pivot table
acCmdPivotAutoVar
418
Inserts a variance calculation field for the selected column in a pivot table
acCmdPivotAutoVarP
420
Inserts a variance population calculation field for the selected column in a pivot table
acCmdPivotChartByRowByColumn
456
acCmdPivotChartDrillInto
457
acCmdPivotChartDrillOut
532
acCmdPivotMultiplePlots
458
acCmdPivotMultiplePlotsUnifiedScale
459
acCmdPivotChartShowLegend
455
acCmdPivotChartSortAscByTotal
534
acCmdPivotChartSortDescByTotal
535
acCmdPivotCollapse
400
Hides all the sub items for the selected item
acCmdPivotDelete
454
Removes the selected field from the Pivot Table
acCmdPivotDropAreas
452
Toggles the display of the field drop areas on the Pivot Table
acCmdPivotExpand
401
Shows all sub items for the selected item
acCmdPivotRefresh
404
Refreshes the data in the Pivot Table
acCmdPivotShowAll
461
Removes any filter that has been applied
acCmdPivotShowBottom1
432
Shows bottom item for the selected field based on a calculated total
acCmdPivotShowBottom10
435
Shows bottom 10 items for the selected field based on a calculated total
acCmdPivotShowBottom10Percent
440
Shows bottom 10% of items for the selected field based on a calculated total
acCmdPivotShowBottom1Percent
437
Shows bottom 1% of items for the selected field based on a calculated total
acCmdPivotShowBottom2
433
Shows bottom 2 items for the selected field based on a calculated total
acCmdPivotShowBottom25
436
Shows bottom 25 items for the selected field based on a calculated total
acCmdPivotShowBottom25Percent
441
Shows bottom 25% of items for the selected field based on a calculated total
acCmdPivotShowBottom2Percent
438
Shows bottom 2% of items for the selected field based on a calculated total
acCmdPivotShowBottom5
434
Shows bottom 5 items for the selected field based on a calculated total
acCmdPivotShowBottom5Percent
439
Shows bottom 5% of items for the selected field based on a calculated total
acCmdPivotShowBottomOther
442
Opens the properties box for the field on the filter tab
acCmdPivotShowTop1
421
Shows top item for the selected field
acCmdPivotShowTop10
424
Shows top 10 items for the selected field
acCmdPivotShowTop10Percent
429
Shows top 10% of items for the selected field based on a calculated total
acCmdPivotShowTop1Percent
426
Shows top 1% of items for the selected field based on a calculated total
acCmdPivotShowTop2
422
Shows top 2 items for the selected field
acCmdPivotShowTop25
425
Shows top 25 items for the selected field
acCmdPivotShowTop25Percent
430
Shows top 25% of items for the selected field based on a calculated total
acCmdPivotShowTop2Percent
427
Shows top 2% of items for the selected field based on a calculated total
acCmdPivotShowTop5
423
Shows top 5 items for the selected field
acCmdPivotShowTop5Percent
428
Shows top 5% of items for the selected field based on a calculated total
acCmdPivotShowTopOther
431
Opens the properties box for the field on the filter tab
acCmdPivotTableClearCustomOrdering
527
Sorts the selected field into a standard order
acCmdPivotTableCreateCalcField
444
Inserts a new column into the Pivot Table and opens the Properties Form to allow a calulation to be entered
acCmdPivotTableCreateCalcTotal
443
Adds a new field to the data area and opens the properties box to allow entry of calculation
acCmdPivotTableDemote
411
Moves a row heading one place to the right
acCmdPivotTableExpandIndicators
451
Toggles the display of the Show/Hide indicators on the Pivot Table
acCmdPivotTableExportToExcel
405
Exports the Pivot Table to Excel
acCmdPivotTableFilterBySelection
528
Filters the displayed items to those matching present selection
acCmdPivotTableGroupItems
530
Creates a new group from the selected values in a column
acCmdPivotTableHideDetails
402
Hides details for an expanded group
acCmdPivotTableMoveToColumnArea
407
Moves the selected field to the column area of the Pivot Table
acCmdPivotTableMoveToDetailArea
409
Moves the selected field to the column area of the Pivot Table
acCmdPivotTableMoveToFilterArea
408
Moves the selected field to the filter area of the Pivot Table
acCmdPivotTableMoveToRowArea
406
Moves the selected field to the row area of the Pivot Table
acCmdPivotTablePercentColumnTotal
447
acCmdPivotTablePercentGrandTotal
450
acCmdPivotTablePercentParentColumnItem
449
acCmdPivotTablePercentParentRowItem
448
acCmdPivotTablePercentRowTotal
446
acCmdPivotTablePromote
410
Moves a row heading one place to the right
acCmdPivotTableRemove
529
Removes the selected field from the Pivot Table
acCmdPivotTableShowAsNormal
445
acCmdPivotTableShowDetails
403
Displays the details for a collaped group
acCmdPivotTableSubtotal
399
acCmdPivotTableUngroupItems
531
Removes the grouping from the selcted group
acCmdPivotTableView
396
Changes a form to Pivot Table view
acCmdPrepareDatabaseForWeb
716
acCmdPreviewEightPages
249
Display eight pages at a time in print preview
acCmdPreviewFourPages
248
Display four pages at a time in print preview
acCmdPreviewOnePage
246
Display a single page at a time in print preview
acCmdPreviewTwelvePages
250
Display twelve pages at a time in print preview
acCmdPreviewTwoPages
247
Display two pages at a time in print preview
acCmdPrimaryKey
107
Sets/removes the Primary key on the selected field(s)
acCmdPrint
340
Opens the Print dialog box. Available in both VBE and non-VBE views
acCmdPrintPreview
54
Opens the print preview window
acCmdPrintRelationships
483
Prints the relationships diagram
acCmdProcedureDefinition
122
Displays the object browser at the definition of word under cursor
acCmdPromote
386
Used on Data Access Pages to promote a Group heading
acCmdProperties
287
Toggles the Properties window
acCmdPublish
320
Starts the Web Publisher Wizard
acCmdPublishDefaults
324
Sets or calls Webpublishing Wizard defaults?
acCmdPublishFixedFormat
591
Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.