Run Command 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 |
|
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 |
|
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 |
acCmdProperties |
|
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 |
|
acCmdDebugWindow |
acCmdRecordsGoToLast |
|
acCmdDelete |
acCmdRecordsGoToNew |
|
acCmdDeleteGroup |
acCmdRecordsGoToNext |
|
acCmdDeletePage |
acCmdRecordsGoToPrevious |
|
acCmdDeleteQueryColumn |
acCmdRecoverDesignMaster |
|
acCmdDeleteRecord |
acCmdRedo |
|
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 | |
|
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 |
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 | |
|
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 |
|
acCmdZoom50 0 | |
|
acCmdPivotAutoVar |
acCmdZoom7 5 |
|
acCmdPivotAutoVarP |
acCmdZoomBox |
|
acCmdPivotChartByRowByColumn | |
Related Posts
Responses
-
TOBIAS6 years ago
- Reply
-
rowan5 months ago
- Reply
