RunCommand Method Arguments

One of the easiest ways to perform a variety of functions in Microsoft Access is through use of the RunCommand method. You can use this anywhere within your code. The RunCommand method takes a single argument, the acCommand constant. All of the available acCommand constants are listed in the following table. For convenience, they are listed in two columns. Each of these arguments represents some command in Access that is accessible from a menu or toolbar.

Argument

Argument

acCmdAboutMicrosoftAccess acCmdAddInManager

acCmdPivotChartDrillOut acCmdPivotChartMultiplePlots

Continues

793

Argument

Argument

acCmdAddToNewGroup

acCmdPivotChartMultiplePlotsUnifiedScale

acCmdAddWatch

acCmdPivotChartShowLegend

acCmdAdvancedFilterSort

acCmdPivotChartType

acCmdAlignBottom

acCmdPivotChartUndo

acCmdAlignCenter

acCmdPivotChartView

acCmdAlignLeft

acCmdPivotCollapse

acCmdAlignmentAndSizing

acCmdPivotDelete

acCmdAlignMiddle

acCmdPivotDropAreas

acCmdAlignRight

acCmdPivotExpand

acCmdAlignToGrid

acCmdPivotRefresh

acCmdAlignTop

acCmdPivotShowAll

acCmdAlignToShortest

acCmdPivotShowBottom1

acCmdAlignToTallest

acCmdPivotShowBottom10

acCmdAnalyzePerformance

acCmdPivotShowBottom10Percent

acCmdAnalyzeTable

acCmdPivotShowBottom1Percent

acCmdAnswerWizard

acCmdPivotShowBottom2

acCmdApplyDefault

acCmdPivotShowBottom2 5

acCmdApplyFilterSort

acCmdPivotShowBottom2 5Percent

acCmdAppMaximize

acCmdPivotShowBottom2Percent

acCmdAppMinimize

acCmdPivotShowBottom5

acCmdAppMove

acCmdPivotShowBottom5Percent

acCmdAppRestore

acCmdPivotShowBottomOther

acCmdAppSize

acCmdPivotShowTop1

acCmdArrangeIconsAuto

acCmdPivotShowTop10

acCmdArrangeIconsByCreated

acCmdPivotShowTop10Percent

acCmdArrangeIconsByModified

acCmdPivotShowTop1Percent

acCmdArrangeIconsByName

acCmdPivotShowTop2

acCmdArrangeIconsByType

acCmdPivotShowTop2 5

acCmdAutoCorrect

acCmdPivotShowTop2 5Percent

Argument

Argument

acCmdAutoDial

acCmdPivotShowTop2Percent

acCmdAutoFormat

acCmdPivotShowTop5

acCmdBackgroundPicture

acCmdPivotShowTop5Percent

acCmdBackgroundSound

acCmdPivotShowTopOther

acCmdBackup

acCmdPivotTableClearCustomOrdering

acCmdBookmarksClearAll

acCmdPivotTableCreateCalcField

acCmdBookmarksNext

acCmdPivotTableCreateCalcTotal

acCmdBookmarksPrevious

acCmdPivotTableDemote

acCmdBookmarksToggle

acCmdPivotTableExpandIndicators

acCmdBringToFront

acCmdPivotTableExportToExcel

acCmdCallStack

acCmdPivotTableFilterBySelection

acCmdChangeToCheckBox

acCmdPivotTableGroupItems

acCmdChangeToComboBox

acCmdPivotTableHideDetails

acCmdChangeToCommandButton

acCmdPivotTableMoveToColumnArea

acCmdChangeToImage

acCmdPivotTableMoveToDetailArea

acCmdChangeToLabel

acCmdPivotTableMoveToFilterArea

acCmdChangeToListBox

acCmdPivotTableMoveToRowArea

acCmdChangeToOptionButton

acCmdPivotTablePercentColumnTotal

acCmdChangeToTextBox

acCmdPivotTablePercentGrandTotal

acCmdChangeToToggleButton

acCmdPivotTablePercentParentColumnItem

acCmdChartSortAscByTotal

acCmdPivotTablePercentParentRowItem

acCmdChartSortDescByTotal

acCmdPivotTablePercentRowTotal

acCmdClearAll

acCmdPivotTablePromote

acCmdClearAllBreakpoints

acCmdPivotTableRemove

acCmdClearGrid

acCmdPivotTableShowAsNormal

acCmdClearHyperlink

acCmdPivotTableShowDetails

acCmdClearItemDefaults

acCmdPivotTableSubtotal

acCmdClose

acCmdPivotTableUngroupItems

acCmdCloseWindow

acCmdPivotTableView

Continues

Argument

Argument

acCmdColumnWidth

acCmdPreviewEightPages

acCmdCompactDatabase

acCmdPreviewFourPages

acCmdCompileAllModules

acCmdPreviewOnePage

acCmdCompileAndSaveAllModules

acCmdPreviewTwelvePages

acCmdCompileLoadedModules

acCmdPreviewTwoPages

acCmdCompleteWord

acCmdPrimaryKey

acCmdConditionalFormatting

acCmdPrint

acCmdConnection

acCmdPrintPreview

acCmdControlWizardsToggle

acCmdPrintRelationships

acCmdConvertDatabase

acCmdProcedureDefinition

acCmdConvertMacrosToVisualBasic

acCmdPromote

acCmdCopy

acCmdProperties

acCmdCopyDatabaseFile

acCmdPublish

acCmdCopyHyperlink

acCmdPublishDefaults

acCmdCreateMenuFromMacro

acCmdQueryAddToOutput

acCmdCreateRelationship

acCmdQueryGroupBy

acCmdCreateReplica

acCmdQueryParameters

acCmdCreateShortcut

acCmdQueryTotals

acCmdCreateShortcutMenuFromMacro

acCmdQueryTypeAppend

acCmdCreateToolbarFromMacro

acCmdQueryTypeCrosstab

acCmdCut

acCmdQueryTypeDelete

acCmdDataAccessPageAddToPage

acCmdQueryTypeMakeTable

acCmdDataAccessPageBrowse

acCmdQueryTypeSelect

acCmdDataAccessPageDesignView

acCmdQueryTypeSQLDataDefinition

acCmdDataAccessPageFieldListRefresh

acCmdQueryTypeSQLPassThrough

acCmdDatabaseProperties

acCmdQueryTypeSQLUnion

acCmdDatabaseSplitter

acCmdQueryTypeUpdate

acCmdDataEntry

acCmdQuickInfo

acCmdDataOutline

acCmdQuickPrint

Argument

Argument

acCmdDatasheetView

acCmdQuickWatch

acCmdDateAndTime

acCmdRecordsGoToFirst

acCmdDebugWindow

acCmdRecordsGoToLast

acCmdDelete

acCmdRecordsGoToNew

acCmdDeleteGroup

acCmdRecordsGoToNext

acCmdDeletePage

acCmdRecordsGoToPrevious

acCmdDeleteQueryColumn

acCmdRecoverDesignMaster

acCmdDeleteRecord

acCmdRedo

acCmdDeleteRows

acCmdReferences

acCmdDeleteTab

acCmdRefresh

acCmdDeleteTable

acCmdRefreshPage

acCmdDeleteTableColumn

acCmdRegisterActiveXControls

acCmdDeleteWatch

acCmdRelationships

acCmdDemote

acCmdRemove

acCmdDesignView

acCmdRemoveFilterSort

acCmdDiagramAddRelatedTables

acCmdRemoveTable

acCmdDiagramAutosizeSelectedTables

acCmdRename

acCmdDiagramDeleteRelationship

acCmdRenameColumn

acCmdDiagramLayoutDiagram

acCmdRenameGroup

acCmdDiagramLayoutSelection

acCmdRepairDatabase

acCmdDiagramModifyUserDefinedView

acCmdReplace

acCmdDiagramNewLabel

acCmdReportHdrFtr

acCmdDiagramNewTable

acCmdReset

acCmdDiagramRecalculatePageBreaks

acCmdResolveConflicts

acCmdDiagramShowRelationshipLabels

acCmdRestore

acCmdDiagramViewPageBreaks

acCmdRowHeight

acCmdDocMaximize

acCmdRun

acCmdDocMinimize

acCmdRunMacro

acCmdDocMove

acCmdRunOpenMacro

Continues

Argument

Argument

acCmdDocRestore

acCmdSave

acCmdDocSize

acCmdSaveAllModules

acCmdDocumenter

acCmdSaveAllRecords

acCmdDropSQLDatabase

acCmdSaveAs

acCmdDuplicate

acCmdSaveAsASP

acCmdEditHyperlink

acCmdSaveAsDataAccessPage

acCmdEditingAllowed

acCmdSaveAsHTML

acCmdEditRelationship

acCmdSaveAsIDC

acCmdEditTriggers

acCmdSaveAsQuery

acCmdEditWatch

acCmdSaveAsReport

acCmdEncryptDecryptDatabase

acCmdSaveLayout

acCmdEnd

acCmdSaveModuleAsText

acCmdExit

acCmdSaveRecord

acCmdExport

acCmdSelectAll

acCmdFavoritesAddTo

acCmdSelectAllRecords

acCmdFavoritesOpen

acCmdSelectDataAccessPage

acCmdFieldList

acCmdSelectForm

acCmdFilterByForm

acCmdSelectRecord

acCmdFilterBySelection

acCmdSelectReport

acCmdFilterExcludingSelection

acCmdSend

acCmdFind

acCmdSendToBack

acCmdFindNext

acCmdServerFilterByForm

acCmdFindNextWordUnderCursor

acCmdServerProperties

acCmdFindPrevious

acCmdSetControlDefaults

acCmdFindPrevWordUnderCursor

acCmdSetDatabasePassword

acCmdFitToWindow

acCmdSetNextStatement

acCmdFont

acCmdShowAllRelationships

acCmdFormatCells

acCmdShowDirectRelationships

acCmdFormHdrFtr

acCmdShowEnvelope

Argument

Argument

acCmdFormView

acCmdShowMembers

acCmdFreezeColumn

acCmdShowNextStatement

acCmdGoBack

acCmdShowOnlyWebToolbar

acCmdGoContinue

acCmdShowTable

acCmdGoForward

acCmdSingleStep

acCmdGroupByTable

acCmdSizeToFit

acCmdGroupControls

acCmdSizeToFitForm

acCmdHideColumns

acCmdSizeToGrid

acCmdHidePane

acCmdSizeToNarrowest

acCmdHideTable

acCmdSizeToWidest

acCmdHorizontalSpacingDecrease

acCmdSnapToGrid

acCmdHorizontalSpacingIncrease

acCmdSortAscending

acCmdHorizontalSpacingMakeEqual

acCmdSortDescending

acCmdHyperlinkDisplayText

acCmdSortingAndGrouping

acCmdImport

acCmdSpeech

acCmdIndent

acCmdSpelling

acCmdIndexes

acCmdSQLView

acCmdInsertActiveXControl

acCmdStartupProperties

acCmdInsertChart

acCmdStepInto

acCmdInsertFile

acCmdStepOut

acCmdInsertFileIntoModule

acCmdStepOver

acCmdInsertHyperlink

acCmdStepToCursor

acCmdInsertLookupColumn

acCmdStopLoadingPage

acCmdInsertLookupField

acCmdSubdatasheetCollapseAll

acCmdInsertMovieFromFile

acCmdSubdatasheetExpandAll

acCmdInsertObject

acCmdSubdatasheetRemove

acCmdInsertPage

acCmdSubformDatasheet

acCmdInsertPicture

acCmdSubformDatasheetView

acCmdInsertPivotTable

acCmdSubformFormView

Continues

Argument

Argument

acCmdInsertProcedure

acCmdSubformInNewWindow

acCmdInsertQueryColumn

acCmdSubformPivotChartView

acCmdInsertRows

acCmdSubformPivotTableView

acCmdInsertSpreadsheet

acCmdSwitchboardManager

acCmdInsertSubdatasheet

acCmdSynchronizeNow

acCmdInsertTableColumn

acCmdTabControlPageOrder

acCmdInsertUnboundSection

acCmdTableAddTable

acCmdInvokeBuilder

acCmdTableCustomView

acCmdJoinProperties

acCmdTableNames

acCmdLastPosition

acCmdTabOrder

acCmdLayoutPreview

acCmdTestValidationRules

acCmdLineUpIcons

acCmdTileHorizontally

acCmdLinkedTableManager

acCmdTileVertically

acCmdLinkTables

acCmdToggleBreakpoint

acCmdListConstants

acCmdToggleFilter

acCmdLoadFromQuery

acCmdToolbarControlProperties

acCmdMacroConditions

acCmdToolbarsCustomize

acCmdMacroNames

acCmdTransferSQLDatabase

acCmdMakeMDEFile

acCmdTransparentBackground

acCmdMaximiumRecords

acCmdTransparentBorder

acCmdMicrosoftAccessHelpTopics

acCmdUndo

acCmdMicrosoftOnTheWeb

acCmdUndoAllRecords

acCmdMicrosoftScriptEditor

acCmdUnfreezeAllColumns

acCmdMoreWindows

acCmdUngroupControls

acCmdNewDatabase

acCmdUnhideColumns

acCmdNewGroup

acCmdUpsizingWizard

acCmdNewObjectAutoForm

acCmdUserAndGroupAccounts

acCmdNewObjectAutoReport

acCmdUserAndGroupPermissions

acCmdNewObjectClassModule

acCmdUserLevelSecurityWizard

Argument

Argument

acCmdNewObjectDataAccessPage

acCmdVerticalSpacingDecrease

acCmdNewObjectDiagram

acCmdVerticalSpacingIncrease

acCmdNewObjectForm

acCmdVerticalSpacingMakeEqual

acCmdNewObjectFunction

acCmdViewCode

acCmdNewObjectMacro

acCmdViewDataAccessPages

acCmdNewObjectModule

acCmdViewDetails

acCmdNewObjectQuery

acCmdViewDiagrams

acCmdNewObjectReport

acCmdViewFieldList

acCmdNewObjectStoredProcedure

acCmdViewForms

acCmdNewObjectTable

acCmdViewFunctions

acCmdNewObjectView

acCmdViewGrid

acCmdObjBrwFindWholeWordOnly

acCmdViewLargeIcons

acCmdObjBrwGroupMembers

acCmdViewList

acCmdObjBrwHelp

acCmdViewMacros

acCmdObjBrwShowHiddenMembers

acCmdViewModules

acCmdObjBrwViewDefinition

acCmdViewQueries

acCmdObjectBrowser

acCmdViewReports

acCmdOfficeClipboard

acCmdViewRuler

acCmdOLEDDELinks

acCmdViewShowPaneDiagram

acCmdOLEObjectConvert

acCmdViewShowPaneGrid

acCmdOLEObjectDefaultVerb

acCmdViewShowPaneSQL

acCmdOpenDatabase

acCmdViewSmallIcons

acCmdOpenHyperlink

acCmdViewStoredProcedures

acCmdOpenNewHyperlink

acCmdViewTableColumnNames

acCmdOpenSearchPage

acCmdViewTableColumnProperties

acCmdOpenStartPage

acCmdViewTableKeys

acCmdOpenTable

acCmdViewTableNameOnly

acCmdOpenURL

acCmdViewTables

acCmdOptions

acCmdViewTableUserView

Continues

Argument

Argument

acCmdOutdent

acCmdViewToolbox

acCmdOutputToExcel

acCmdViewVerifySQL

acCmdOutputToRTF

acCmdViewViews

acCmdOutputToText

acCmdVisualBasicEditor

acCmdPageHdrFtr

acCmdWebPagePreview

acCmdPageNumber

acCmdWebPageProperties

acCmdPageProperties

acCmdWebTheme

acCmdPageSetup

acCmdWindowArrangeIcons

acCmdParameterInfo

acCmdWindowCascade

acCmdPartialReplicaWizard

acCmdWindowHide

acCmdPaste

acCmdWindowSplit

acCmdPasteAppend

acCmdWindowUnhide

acCmdPasteAsHyperlink

acCmdWordMailMerge

acCmdPasteSpecial

acCmdWorkgroupAdministrator

acCmdPivotAutoAverage

acCmdZoom10

acCmdPivotAutoCount

acCmdZoom10 0

acCmdPivotAutoFilter

acCmdZoom1000

acCmdPivotAutoMax

acCmdZoom15 0

acCmdPivotAutoMin

acCmdZoom2 0 0

acCmdPivotAutoStdDev

acCmdZoom2 5

acCmdPivotAutoStdDevP

acCmdZoom50

acCmdPivotAutoSum

acCmdZoom50 0

acCmdPivotAutoVar

acCmdZoom7 5

acCmdPivotAutoVarP

acCmdZoomBox

acCmdPivotChartByRowByColumn

acCmdZoomSelection

acCmdPivotChartDrillInto

0 0

Responses

  • TOBIAS
    How to View Relationships With the Relationship with vba?
    3 years ago

Post a comment