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 |
acCmdPivotChartShowLegend | |
acCmdAdvancedFilterSort | |
acCmdAlignBottom | |
acCmdAlignCenter |
acCmdPivotChartView |
acCmdAlignLeft |
acCmdPivotCollapse |
acCmdAlignmentAndSizing |
acCmdPivotDelete |
acCmdAlignMiddle |
acCmdPivotDropAreas |
acCmdAlignRight |
acCmdPivotExpand |
acCmdAlignToGrid | |
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 |
acCmdPivotShowTop1 | |
acCmdArrangeIconsAuto | |
acCmdArrangeIconsByCreated |
acCmdPivotShowTop10Percent |
acCmdArrangeIconsByModified |
acCmdPivotShowTop1Percent |
acCmdArrangeIconsByName |
acCmdPivotShowTop2 |
acCmdArrangeIconsByType |
acCmdPivotShowTop2 5 |
acCmdPivotShowTop2 5Percent |
Argument |
Argument |
acCmdAutoDial |
acCmdPivotShowTop2Percent |
acCmdAutoFormat |
acCmdPivotShowTop5 |
acCmdPivotShowTop5Percent | |
acCmdPivotShowTopOther | |
acCmdBackup |
acCmdPivotTableClearCustomOrdering |
acCmdBookmarksClearAll |
acCmdPivotTableCreateCalcField |
acCmdBookmarksNext |
acCmdPivotTableCreateCalcTotal |
acCmdBookmarksPrevious |
acCmdPivotTableDemote |
acCmdBookmarksToggle |
acCmdPivotTableExpandIndicators |
acCmdBringToFront |
acCmdPivotTableExportToExcel |
acCmdCallStack |
acCmdPivotTableFilterBySelection |
acCmdChangeToCheckBox |
acCmdPivotTableGroupItems |
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 |
acCmdPrint | |
acCmdConnection |
acCmdPrintPreview |
acCmdControlWizardsToggle |
acCmdPrintRelationships |
acCmdConvertDatabase |
acCmdProcedureDefinition |
acCmdConvertMacrosToVisualBasic |
acCmdPromote |
acCmdCopy | |
acCmdPublish | |
acCmdCopyHyperlink |
acCmdPublishDefaults |
acCmdQueryAddToOutput | |
acCmdCreateRelationship | |
acCmdCreateReplica |
acCmdQueryParameters |
acCmdCreateShortcut |
acCmdQueryTotals |
acCmdCreateShortcutMenuFromMacro |
acCmdQueryTypeAppend |
acCmdCreateToolbarFromMacro |
acCmdQueryTypeCrosstab |
acCmdCut |
acCmdQueryTypeDelete |
acCmdDataAccessPageAddToPage |
acCmdQueryTypeMakeTable |
acCmdDataAccessPageBrowse | |
acCmdDataAccessPageDesignView |
acCmdQueryTypeSQLDataDefinition |
acCmdDataAccessPageFieldListRefresh |
acCmdQueryTypeSQLPassThrough |
acCmdDatabaseProperties |
acCmdQueryTypeSQLUnion |
acCmdDatabaseSplitter |
acCmdQueryTypeUpdate |
acCmdDataEntry |
acCmdQuickInfo |
acCmdDataOutline |
acCmdQuickPrint |
Argument |
Argument |
acCmdDatasheetView |
acCmdQuickWatch |
acCmdDateAndTime |
acCmdRecordsGoToFirst |
acCmdRecordsGoToLast | |
acCmdDelete |
acCmdRecordsGoToNew |
acCmdDeleteGroup |
acCmdRecordsGoToNext |
acCmdDeletePage |
acCmdRecordsGoToPrevious |
acCmdDeleteQueryColumn |
acCmdRecoverDesignMaster |
acCmdDeleteRecord |
acCmdRedo |
acCmdDeleteRows |
acCmdReferences |
acCmdDeleteTab |
acCmdRefresh |
acCmdRefreshPage | |
acCmdDeleteTableColumn | |
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 |
acCmdRunOpenMacro |
Continues
Argument |
Argument |
acCmdDocRestore |
acCmdSave |
acCmdDocSize |
acCmdSaveAllModules |
acCmdSaveAllRecords | |
acCmdSaveAs | |
acCmdDuplicate |
acCmdSaveAsASP |
acCmdEditHyperlink |
acCmdSaveAsDataAccessPage |
acCmdSaveAsHTML | |
acCmdEditRelationship |
acCmdSaveAsIDC |
acCmdEditTriggers | |
acCmdEditWatch |
acCmdSaveAsReport |
acCmdSaveLayout | |
acCmdEnd |
acCmdSaveModuleAsText |
acCmdExit |
acCmdSaveRecord |
acCmdExport |
acCmdSelectAll |
acCmdFavoritesAddTo |
acCmdSelectAllRecords |
acCmdFavoritesOpen |
acCmdSelectDataAccessPage |
acCmdFieldList |
acCmdSelectForm |
acCmdFilterByForm |
acCmdSelectRecord |
acCmdFilterBySelection |
acCmdSelectReport |
acCmdFilterExcludingSelection |
acCmdSend |
acCmdFind | |
acCmdFindNext |
acCmdServerFilterByForm |
acCmdFindNextWordUnderCursor |
acCmdServerProperties |
acCmdFindPrevious |
acCmdSetControlDefaults |
acCmdFindPrevWordUnderCursor | |
acCmdFitToWindow |
acCmdSetNextStatement |
acCmdFont |
acCmdShowAllRelationships |
acCmdFormatCells |
acCmdShowDirectRelationships |
acCmdFormHdrFtr |
acCmdShowEnvelope |
Argument |
Argument |
acCmdFormView |
acCmdShowMembers |
acCmdFreezeColumn |
acCmdShowNextStatement |
acCmdGoBack |
acCmdShowOnlyWebToolbar |
acCmdShowTable | |
acCmdGoForward |
acCmdSingleStep |
acCmdGroupByTable |
acCmdSizeToFit |
acCmdGroupControls |
acCmdSizeToFitForm |
acCmdSizeToGrid | |
acCmdHidePane |
acCmdSizeToNarrowest |
acCmdSizeToWidest | |
acCmdHorizontalSpacingDecrease |
acCmdSnapToGrid |
acCmdHorizontalSpacingIncrease |
acCmdSortAscending |
acCmdHorizontalSpacingMakeEqual |
acCmdSortDescending |
acCmdSortingAndGrouping | |
acCmdImport |
acCmdSpeech |
acCmdIndent |
acCmdSpelling |
acCmdIndexes |
acCmdSQLView |
acCmdInsertActiveXControl | |
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 | |
acCmdInsertQueryColumn |
acCmdSubformPivotChartView |
acCmdInsertRows |
acCmdSubformPivotTableView |
acCmdInsertSpreadsheet |
acCmdSwitchboardManager |
acCmdInsertSubdatasheet |
acCmdSynchronizeNow |
acCmdInsertTableColumn |
acCmdTabControlPageOrder |
acCmdInsertUnboundSection |
acCmdTableAddTable |
acCmdInvokeBuilder |
acCmdTableCustomView |
acCmdJoinProperties | |
acCmdLastPosition |
acCmdTabOrder |
acCmdLayoutPreview |
acCmdTestValidationRules |
acCmdLineUpIcons |
acCmdTileHorizontally |
acCmdLinkedTableManager |
acCmdTileVertically |
acCmdLinkTables |
acCmdToggleBreakpoint |
acCmdListConstants |
acCmdToggleFilter |
acCmdLoadFromQuery |
acCmdToolbarControlProperties |
acCmdMacroConditions |
acCmdToolbarsCustomize |
acCmdMacroNames |
acCmdTransferSQLDatabase |
acCmdTransparentBackground | |
acCmdMaximiumRecords |
acCmdTransparentBorder |
acCmdMicrosoftAccessHelpTopics |
acCmdUndo |
acCmdMicrosoftOnTheWeb |
acCmdUndoAllRecords |
acCmdMicrosoftScriptEditor |
acCmdUnfreezeAllColumns |
acCmdMoreWindows |
acCmdUngroupControls |
acCmdNewDatabase |
acCmdUnhideColumns |
acCmdNewGroup | |
acCmdNewObjectAutoForm |
acCmdUserAndGroupAccounts |
acCmdNewObjectAutoReport |
acCmdUserAndGroupPermissions |
acCmdNewObjectClassModule |
acCmdUserLevelSecurityWizard |
Argument |
Argument |
acCmdNewObjectDataAccessPage |
acCmdVerticalSpacingDecrease |
acCmdNewObjectDiagram |
acCmdVerticalSpacingIncrease |
acCmdNewObjectForm |
acCmdVerticalSpacingMakeEqual |
acCmdViewCode | |
acCmdNewObjectMacro |
acCmdViewDataAccessPages |
acCmdNewObjectModule |
acCmdViewDetails |
acCmdNewObjectQuery |
acCmdViewDiagrams |
acCmdNewObjectReport | |
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 |
acCmdViewTableColumnNames | |
acCmdOpenSearchPage |
acCmdViewTableColumnProperties |
acCmdOpenStartPage |
acCmdViewTableKeys |
acCmdOpenTable |
acCmdViewTableNameOnly |
acCmdOpenURL |
acCmdViewTables |
acCmdOptions |
acCmdViewTableUserView |
Continues
Argument |
Argument |
acCmdOutdent |
acCmdViewToolbox |
acCmdOutputToExcel | |
acCmdOutputToRTF |
acCmdViewViews |
acCmdOutputToText |
acCmdVisualBasicEditor |
acCmdPageHdrFtr |
acCmdWebPagePreview |
acCmdPageNumber |
acCmdWebPageProperties |
acCmdWebTheme | |
acCmdPageSetup |
acCmdWindowArrangeIcons |
acCmdParameterInfo |
acCmdWindowCascade |
acCmdPartialReplicaWizard |
acCmdWindowHide |
acCmdPaste |
acCmdWindowSplit |
acCmdPasteAppend |
acCmdWindowUnhide |
acCmdPasteAsHyperlink | |
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 |
Was this article helpful?