A list of RunCommand constants with a brief description.
acCmdAboutMicrosoftAccess ~ 35 ~ Display the About Access Information dialog acCmdAddDataMacroAfterDelete ~ 720 acCmdAddDataMacroAfterInsert ~ 718 acCmdAddDataMacroAfterUpdate ~ 718 acCmdAddDataMacroValidateChange ~ 722 acCmdAddDataMacroValidateDelete ~ 721 acCmdAddFromOutlook ~ 583 ~ Launch the Outlook Global Address Book acCmdAddInManager ~ 526 ~ Open the Add In Manager window acCmdAddNamedDataMacro ~ 723 acCmdAddToNewGroup ~ 494 ~ Add an item to a newly created group acCmdAddWatch ~ 201 ~ Add a variable to the Watch Window acCmdAdvancedFilterSort ~ 99 ~ Display Query By Example form for filter acCmdAlignBottom ~ 46 ~ Align the bottom edges of a selection of controls if no overlap else aligns top to bottom acCmdAlignLeft ~ 43 ~ Align the left edges of a selection of controls if no overlap else abuts left edge to right edge acCmdAlignmentAndSizing ~ 478 ~ Display the Alignment toolbar acCmdAlignRight ~ 44 ~ Align the right edges of a selection of controls if no overlap else abuts left edge to right edge acCmdAlignToGrid ~ 47 ~ Align selection to grid acCmdAlignTop ~ 45 ~ Align the top edges of a selection of controls if no overlap else abuts top edge to bottom edge acCmdAlignToShortest ~ 153 ~ Size selected controls to shortest acCmdAlignToTallest ~ 154 ~ Size selected controls to tallest acCmdAnalyzePerformance ~ 283 ~ Display the Analyze Performance dialog acCmdAnalyzeTable ~ 284 ~ Display the Table Analyzer Wizard acCmdAnchorBottomLeft ~ 616 acCmdAnchorBottomRight ~ 618 acCmdAnchorBottomStretchAcross ~ 617 acCmdAnchorStretchAcross ~ 611 acCmdAnchorStretchDown ~ 613 acCmdAnchorStretchDownAcross ~ 614 acCmdAnchorStretchDownRight ~ 615 acCmdAnchorTopLeft ~ 610 acCmdAnchorTopRight ~ 612 acCmdAnswerWizard ~ 235 ~ Display the Help Find dialog acCmdApplyAutoFormat1 ~ 648 acCmdApplyAutoFormat2 ~ 649 acCmdApplyAutoFormat3 ~ 650 acCmdApplyAutoFormat4 ~ 651 acCmdApplyAutoFormat5 ~ 652 acCmdApplyAutoFormat6 ~ 653 acCmdApplyAutoFormat7 ~ 654 acCmdApplyAutoFormat8 ~ 655 acCmdApplyAutoFormat9 ~ 656 acCmdApplyAutoFormat10 ~ 657 acCmdApplyAutoFormat11 ~ 658 acCmdApplyAutoFormat12 ~ 659 acCmdApplyAutoFormat13 ~ 660 acCmdApplyAutoFormat14 ~ 661 acCmdApplyAutoFormat15 ~ 662 acCmdApplyAutoFormat16 ~ 663 acCmdApplyAutoFormat17 ~ 664 acCmdApplyAutoFormat18 ~ 665 acCmdApplyAutoFormat19 ~ 66 acCmdApplyAutoFormat20 ~ 667 acCmdApplyAutoFormat21 ~ 668 acCmdApplyAutoFormat22 ~ 669 acCmdApplyAutoFormat23 ~ 670 acCmdApplyAutoFormat24 ~ 671 acCmdApplyAutoFormat25 ~ 672 acCmdApplyDefault ~ 55 ~ Applies default formatting to selected control acCmdApplyFilterSort ~ 93 ~ Applies the filter entered in a Filter Design window acCmdAppMaximize ~ 10 ~ Maximize Access Window acCmdAppMinimize ~ 11 ~ Minimize Access window acCmdAppMove ~ 12 ~ Change mouse into 4 headed arrow to enable the Access window to be moved acCmdAppRestore ~ 9 ~ Restore Access window acCmdAppSize ~ 13 ~ Size Access window acCmdArrangeIconsAuto ~ 218 ~ Auto arrange icons acCmdArrangeIconsByCreated ~ 216 ~ Arrange the icons in date created order acCmdArrangeIconsByModified ~ 217 ~ Arrange the icons in date modified order acCmdArrangeIconsByName ~ 214 ~ Arrange icons in database window in alphabetical order acCmdArrangeIconsByType ~ 215 ~ Arranges icons by the type of object acCmdAutoCorrect ~ 261 ~ Display the AutoCorrect dialog acCmdAutoDial ~ 192 ~ Automatically phone a selected number acCmdAutoFormat ~ 270 ~ Display the AutoFormat dialog acCmdBookmarksClearAll ~ 310 ~ Clears all bookmarks acCmdBookmarksNext ~ 308 ~ Move to the next bookmark acCmdBookmarksPrevious ~ 309 ~ Move to the previous bookmark acCmdBookmarksToggle ~ 307 ~ Add/removes a bookmark acCmdBringToFront ~ 52 ~ Brings selection to the front of all other objects acCmdBrowseSharePointList ~ 621 ~ Open the SharePoint list on the server acCmdCalculatedColumn ~ 698 acCmdCallStack ~ 172 ~ Display a list of active procedure calls acCmdChangeToCheckBox ~ 231 ~ Change selected control to a check box acCmdChangeToComboBox ~ 230 ~ Change selected control to a combo box acCmdChangeToCommandButton ~ 501 ~ Change selection to a command button acCmdChangeToImage ~ 234 ~ Change selected control to an image acCmdChangeToLabel ~ 228 ~ Change selected control to a label acCmdChangeToListBox ~ 229 ~ Change selected control to a list box acCmdChangeToOptionButton ~ 233 ~ Change selected control to an option button acCmdChangeToTextBox ~ 227 ~ Change selected control to a textbox acCmdChangeToToggleButton ~ 232 ~ Change selected control to a toggle button acCmdClearAll ~ 146 ~ Clears all tables from the Relationships window acCmdClearAllBreakpoints ~ 132 ~ Clears all break points in the database acCmdClearGrid ~ 71 ~ Clears all information from the QBE grid acCmdClearHyperlink ~ 343 ~ Clears a hyperlink field acCmdClose ~ 58 ~ Closes object which has the focus acCmdCloseAll ~ 646 ~ Closes all open windows acCmdCloseDatabase ~ 538 ~ Closes the database acCmdCloseWindow ~ 186 ~ Closes the current window acCmdColumnWidth ~ 117 ~ Display the Column Width dialog acCmdCompactDatabase ~ 4 ~ Compacts a database - but will not compact the open database acCmdCompatCheckCurrentObject ~ 696 acCmdCompatCheckDatabase ~ 695 acCmdCompileAllModules ~ 125 ~ Compiles all modules acCmdCompileAndSaveAllModules ~ 126 ~ Compiles and saves all modules in the database acCmdCompileLoadedModules ~ 290 ~ Compiles loaded modules acCmdCompleteWord ~ 306 ~ Display list of objects/methods acCmdConditionalFormating ~ 500 ~ Open conditional formatting dialog acCmdConnection ~ 383 ~ Connects the database to a server acCmdControlMarginsMedium ~ 630 acCmdControlMarginsNarrow ~ 629 acCmdControlMarginsNone ~ 628 acCmdControlMarginsWide ~ 631 acCmdControlPaddingMedium ~ 634 acCmdControlPaddingNarrow ~ 633 acCmdControlPaddingNone ~ 632 acCmdControlPaddingWide ~ 635 acCmdControlWizardsToggle ~ 197 ~ Turn the control wizard on and off acCmdConvertDatabase ~ 171 ~ Open the Convert Database dialog acCmdConvertLinkedTableToLocal ~ 700 acCmdConvertMacrosToVisualBasic ~ 279 ~ Converts macros to code acCmdCopy ~ 190 ~ Copies the selection to the clipboard. Available in both VBE and non-VBE views acCmdCopyHyperlink ~ 328 ~ Copies the hyperlink acCmdCreateMenuFromMacro ~ 334 ~ Create a menu toolbar from a macro acCmdCreateRelationship ~ 150 ~ Display the Create Relationship dialog acCmdCreateShortcut ~ 219 ~ Open the Create Shortcut dialog acCmdCreateShortcutMenuFromMacro ~ 336 ~ Create a shortcut menu from a macro acCmdCreateToolbarFromMacro ~ 335 ~ Create a toolbar from a macro acCmdCut ~ 189 ~ Cuts the selection to the clipboard. Available in both VBE and non-VBE views acCmdDatabaseProperties ~ 256 ~ Display the database properties dialog acCmdDatabaseSplitter ~ 520 ~ Automatically split the current database into a front-end and a data only back-end. acCmdDataEntry ~ 78 ~ Change view to data entry mode acCmdDatasheetView ~ 282 ~ Switch to datasheet view acCmdDateAndTime ~ 226 ~ Display the Date and Time dialog acCmdDebugWindow ~ 123 ~ Display the immediate window but you have to open a module first acCmdDelete ~ 337 ~ Delete selected item. Available in both VBE and non-VBE views acCmdDeletePage ~ 332 ~ Delete a page from a tab control acCmdDeleteQueryColumn ~ 81 ~ Remove a column from the QBE grid acCmdDeleteRecord ~ 223 ~ Delete the selected record acCmdDeleteRows ~ 188 ~ Delete rows but where I am not sure acCmdDeleteSharePointList ~ 627 ~ Delete the currently open SharePoint list acCmdDeleteTab ~ 255 ~ Not used to delete a tab from a tab control that is acCmdDeletePage acCmdDeleteTableColumn ~ 271 ~ Delete the selected column from a table acCmdDeleteWatch ~ 267 ~ Delete the selected watch variable acCmdDesignObject ~ 697 acCmdDesignView ~ 183 ~ Switch to Design View acCmdDiagramAddRelatedTables ~ 373 acCmdDiagramAutosizeSelectedTables ~ 378 acCmdDiagramDeleteRelationship ~ 382 acCmdDiagramLayoutDiagram ~ 380 acCmdDiagramLayoutSelection ~ 379 acCmdDiagramModifyUserDefinedView ~ 375 acCmdDiagramNewLabel ~ 372 acCmdDiagramNewTable ~ 381 acCmdDiagramRecalculatePageBreaks ~ 377 ~ Equivalent to right clicking on a diagram and selecting Recalculate Page Breaks acCmdDiagramShowRelationshipLabels ~ 374 acCmdDiagramViewPageBreaks ~ 376 ~ Equivalent to selecting View Page Breaks from the Diagram menu acCmdDiscardChanges ~ 639 acCmdDiscardChangesAndRefresh ~ 640 acCmdDocMaximize ~ 15 ~ Maximizes Access child window. Available in both VBE and non-VBE views acCmdDocMinimize ~ 60 ~ Minimize internal Access window. Available in both VBE and non-VBE views acCmdDocMove ~ 16 ~ Move Access child window. Available in both VBE and non-VBE views acCmdDocRestore ~ 14 ~ Restore Access child window. Available in both VBE and non-VBE views acCmdDocSize ~ 17 ~ Size Access child window. Available in both VBE and non-VBE views acCmdDocumenter ~ 285 ~ Display the Documentor dialog acCmdDropSQLDatabase ~ 517 acCmdDuplicate ~ 34 ~ Create a duplicate of the selected object acCmdEditHyperlink ~ 325 ~ Allows the editting of a Hyperlink acCmdEditListItems ~ 607 acCmdEditRelationship ~ 151 ~ Display the Edit Relationship dialog acCmdEditWatch ~ 202 ~ Open the Edit Watch dialog acCmdEncryptDecryptDatabase ~ 5 ~ Open the Encrypt/Decrypt Database dialog acCmdEnd ~ 198 ~ Stops the running of a procedure acCmdExit ~ 3 ~ Close Access completely acCmdExport ~ 487 ~ Export database objects to an existing Microsoft Access database acCmdExportAccess ~ 559 acCmdExportdBase ~ 565 acCmdExportExcel ~ 556 acCmdExportFixedFormat ~ 592 acCmdExportHTML ~ 564 acCmdExportLotus ~ 567 acCmdExportODBC ~ 562 acCmdExportParadox ~ 566 acCmdExportRTF ~ 558 acCmdExportSharePointList ~ 557 acCmdExportSnapShot ~ 563 acCmdExportText ~ 560 acCmdExportXML ~ 561 acCmdFavoritesAddTo ~ 299 ~ Display the Add To Favorites dialog acCmdFavoritesOpen ~ 298 ~ Display the Open Favorites dialog acCmdFieldList ~ 42 ~ Display/hide the Field List dialog acCmdFieldTemplates ~ 647 acCmdFilterByForm ~ 207 ~ Display the filter by form dialog acCmdFilterBySelection ~ 208 ~ Filters the displayed records by the selected item acCmdFilterExcludingSelection ~ 277 ~ Filters out records that match selection acCmdFilterMenu ~ 619 acCmdFind ~ 30 ~ Open the Find dialog box. Available in both VBE and non-VBE views acCmdFindNext ~ 341 ~ Find next occurrence of previously searched for phrase. Available in both VBE and non-VBE views acCmdFindNextWordUnderCursor ~ 313 ~ Finds the next occurrence of the word which is under the cursor. Not really Edit Find but an improvement on it acCmdFindPrevious ~ 120 ~ Find previous occurrence of the last string searched for. Not really Edit Find but an enhancement acCmdFindPrevWordUnderCursor ~ 312 ~ Finds the previous occurrence of the word which is under the cursor. Equivalent to Ctrl Shift and F3 acCmdFitToWindow ~ 245 ~ Fit print preview in window acCmdFont ~ 19 ~ Display the font selection dialog acCmdFormatCells ~ 77 ~ Display the Format Cells dialog acCmdFormHdrFtr ~ 36 ~ Add or removes form headers and footers acCmdFormView ~ 281 ~ Switches to form view acCmdFreezeColumn ~ 105 ~ Keeps the selected column in view acCmdGoContinue ~ 127 ~ Resumes/starts code acCmdGroupByTable ~ 387 acCmdGroupControls ~ 484 ~ In design view of a form group a number of controls acCmdHideColumns ~ 79 ~ Hides the selected column(s) acCmdHideMessageBar ~ 677 ~ Hides the Message Bar acCmdHidePane ~ 365 acCmdHideTable ~ 147 ~ Hides a table in the Relationships window acCmdHorizontalSpacingDecrease ~ 158 ~ Decreases the horizontal space between selected objects acCmdHorizontalSpacingIncrease ~ 159 ~ Increases the horizontal space between selected objects acCmdHorizontalSpacingMakeEqual ~ 157 ~ Makes the horizontal space between selected objects equal acCmdHyperlinkDisplayText ~ 329 ~ Show the text that is displayed for a hyperlink acCmdImport ~ 257 ~ Display the File, Get External Data, Import dialog box acCmdImportAttachAccess ~ 544 ~ Open an Access import dialog box acCmdImportAttachdBase ~ 552 ~ Open a dBase import dialog box acCmdImportAttachExcel ~ 545 ~ Open an Excel import dialog box acCmdImportAttachHTML ~ 550 ~ Open an HTML import dialog box acCmdImportAttachLotus ~ 554 ~ Open a Lotus import dialog box acCmdImportAttachODBC ~ 549 ~ Open an ODBC import dialog box acCmdImportAttachOutlook ~ 551 ~ Open an Outlook import dialog box acCmdImportAttachParadox ~ 553 ~ Open a Paradox import dialog box acCmdImportAttachSharePointList ~ 547 ~ Open a Sharepoint import dialog box acCmdImportAttachText ~ 546 ~ Open a Text import dialog box acCmdImportAttachXML ~ 548 ~ Open an XML import dialog box acCmdIndent ~ 205 ~ Indents line of code acCmdIndexes ~ 152 ~ Toggle display of the Indexes dialog acCmdInsertActiveXControl ~ 258 ~ Display the Insert ActiveX Control dialog acCmdInsertChart ~ 293 ~ Insert a chart acCmdInsertFile ~ 39 ~ Insert a file acCmdInsertFileIntoModule ~ 118 ~ Display the Insert File dialog acCmdInsertHyperlink ~ 259 ~ Display the Insert Hyperlink dialog acCmdInsertLogo ~ 585 acCmdInsertLookupColumn ~ 273 ~ Display the LookUp wizard acCmdInsertLookupField ~ 291 ~ Start the Lookup Wizard acCmdInsertMovieFromFile ~ 469 acCmdInsertNavigationButton ~ 724 acCmdInsertObject ~ 33 ~ Open the Insert Object Dialog acCmdInsertPage ~ 331 ~ Insert a new page to a tab control acCmdInsertPicture ~ 222 ~ Display the Insert Picture dialog acCmdInsertPivotTable ~ 470 acCmdInsertProcedure ~ 262 ~ Display the Insert Procedure dialog acCmdInsertQueryColumn ~ 82 ~ Insets a column into the QBE grid acCmdInsertRows ~ 187 ~ Insert rows acCmdInsertSpreadsheet ~ 471 acCmdInsertSubdatasheet ~ 499 acCmdInsertTableColumn ~ 272 ~ Insert column into a table acCmdInsertTitle ~ 586 acCmdInsertUnboundSection ~ 472 acCmdInvokeBuilder ~ 178 ~ Open the Builder dialog acCmdJoinProperties ~ 72 ~ Display the Join Properties dialog acCmdLastPosition ~ 339 ~ Return cursor to last position in the module window acCmdLayoutGridlinesBoth ~ 574 acCmdLayoutGridlinesBottom ~ 580 acCmdLayoutGridlinesCrossHatch ~ 578 acCmdLayoutGridlinesHorizontal ~ 576 acCmdLayoutGridlinesNone ~ 577 acCmdLayoutGridlinesOutline ~ 581 acCmdLayoutGridlinesTop ~ 579 acCmdLayoutGridlinesVertical ~ 575 acCmdLayoutInsertColumnLeft ~ 680 acCmdLayoutInsertColumnRight ~ 681 acCmdLayoutInsertRowAbove ~ 678 acCmdLayoutInsertRowBelow ~ 679 acCmdLayoutMergeCells ~ 682 acCmdLayoutPreview ~ 141 ~ Print Preview with sample data acCmdLayoutSplitColumnCell ~ 683 acCmdLayoutSplitRowCell ~ 684 acCmdLayoutView ~ 593 acCmdLineUpIcons ~ 213 ~ Line up icons in columns acCmdLinkedTableManager ~ 519 ~ Open the Linked Table Manager dialog acCmdLinkTables ~ 102 ~ Display the Link tables dialog acCmdListConstants ~ 303 ~ Display drop down in code window of available constants acCmdLoadFromQuery ~ 95 ~ Open the Applicable Query dialog acCmdMacroAllActions ~ 589 acCmdMacroArguments ~ 588 acCmdMacroConditions ~ 87 ~ Toggle the display of the Macro Conditions column acCmdMacroNames ~ 86 ~ Toggle the display of the Macro Names column acCmdMakeMDEFile ~ 7 ~ Create a MDE File but can not be used for the active Database acCmdManageAttachments ~ 673 acCmdManageReplies ~ 609 acCmdManageTableEvents ~ 717 acCmdMaximumRecords ~ 508 acCmdMoreWindows ~ 8 ~ Display the Window List dialog box acCmdMoveColumnCellDown ~ 573 acCmdMoveColumnCellUp ~ 572 acCmdNewDatabase ~ 26 ~ Open the new database dialog acCmdNewObjectAutoForm ~ 193 ~ Create a new form if a table/query has been selected in the database window acCmdNewObjectAutoReport ~ 194 ~ Create a new report if a table/query has been selected in the database window acCmdNewObjectBlankForm ~ 600 acCmdNewObjectBlankReport ~ 602 acCmdNewObjectClassModule ~ 140 ~ Create a new Class Module acCmdNewObjectContinuousForm ~ 594 acCmdNewObjectDatasheetForm ~ 598 acCmdNewObjectDesignForm ~ 604 acCmdNewObjectDesignQuery ~ 603 acCmdNewObjectDesignReport ~ 605 acCmdNewObjectDesignTable ~ 606 acCmdNewObjectDiagram ~ 352 ~ Open a new Diagram in design mode acCmdNewObjectForm ~ 136 ~ Display the New Form dialog acCmdNewObjectFunction ~ 394 acCmdNewObjectLabelsReport ~ 601 acCmdNewObjectMacro ~ 138 ~ Open a New Macro Window acCmdNewObjectModalForm ~ 599 acCmdNewObjectModule ~ 139 ~ Create a new Module acCmdNewObjectNavigationLeft ~ 690 acCmdNewObjectNavigationRight ~ 691 acCmdNewObjectNavigationTop ~ 689 acCmdNewObjectNavigationTopLeft ~ 693 acCmdNewObjectNavigationTopRight ~ 694 acCmdNewObjectNavigationTopTop ~ 692 acCmdNewObjectPivotChart ~ 596 acCmdNewObjectPivotTable ~ 597 acCmdNewObjectQuery ~ 135 ~ Display the New Query dialog acCmdNewObjectReport ~ 137 ~ Display the New Report dialog acCmdNewObjectSplitForm ~ 595 acCmdNewObjectStoredProcedure ~ 351 ~ Open a new Stored Procedure in design mode acCmdNewObjectTable ~ 134 ~ Display the New Table dialog acCmdNewObjectView ~ 350 ~ Open a new View in design mode acCmdObjBrwFindWholeWordOnly ~ 314 ~ Toggle the Find Whole Word Only option. Only available when the Object Browser is active acCmdObjBrwGroupMembers ~ 318 ~ Toggle the Group Members option. Only available when the Object Browser is active acCmdObjBrwHelp ~ 318 ~ Open Help on selected item. Only available when the Object Browser is active acCmdObjBrwShowHiddenMembers ~ 315 ~ Toggle the Show Hidden Members option. Only available when the Object Browser is active acCmdObjBrwViewDefinition ~ 317 ~ Display the selected module. Only available when the Object Browser is active acCmdObjectBrowser ~ 200 ~ Display the Object Browser acCmdOfficeClipboard ~ 488 ~ Display the Office Clipboard or makes it active if already open acCmdOLEDDELinks ~ 27 ~ Open the OLE/DDE Links dialog acCmdOLEObjectConvert ~ 167 ~ Display the Convert dialog acCmdOLEObjectDefaultVerb ~ 57 ~ Display OLE object in its native application acCmdOpenDatabase ~ 25 ~ Display the open database dialog acCmdOpenHyperlink ~ 326 ~ Open the item associated with the hyperlink acCmdOpenNewHyperlink ~ 327 ~ Open the item associated with the hyperlink in a new window acCmdOpenTable ~ 221 ~ Open a table acCmdOpenURL ~ 251 ~ Equivalent to selecting the Follow Hyperlink option on the Go dropdown on the Web Toolbar acCmdOptions ~ 49 ~ Open the Tools Options dialog box. Available in both VBE and non-VBE views acCmdOutdent ~ 206 ~ Outdent a line of code acCmdOutputToExcel ~ 175 ~ Export the selected object to Excel acCmdOutputToRTF ~ 176 ~ Output selected object in RTF format acCmdOutputToText ~ 177 ~ Saves selected module as a text file with no prompt for file name or location. Saves in current directory acCmdPageHdrFtr ~ 182 ~ Toggle display of the page header and footer acCmdPageNumber ~ 225 ~ Display the Page Number dialog acCmdPageSetup ~ 32 ~ Open the Page Setup dialog acCmdParameterInfo ~ 305 ~ If not using autofill show the list of arguments for a function acCmdPartialReplicaWizard ~ 524 ~ Start the Partial Replica Wizard in a Design Master database acCmdPaste ~ 191 ~ Paste from the clipboard. Available in both VBE and non-VBE views acCmdPasteAppend ~ 38 ~ Paste a copied record as a new record acCmdPasteFormatting ~ 587 acCmdPasteSpecial ~ 64 ~ Display the Paste Special dialog acCmdPivotAutoAverage ~ 416 ~ Insert an average for the selected column in a pivot table acCmdPivotAutoCount ~ 413 ~ Insert a count for the selected column in a pivot table acCmdPivotAutoFilter ~ 398 ~ Apply/remove a previously applied filter from a Pivot Table acCmdPivotAutoMax ~ 398 ~ Insert a maximum field for the selected column in a pivot table acCmdPivotAutoMin ~ 414 ~ Insert a minimum field for the selected column in a pivot table acCmdPivotAutoStdDev ~ 417 ~ Insert a standard deviation calculation field for the selected column in a pivot table acCmdPivotAutoStdDevP ~ 419 ~ Insert a standard deviation population calculation field for the selected column in a pivot table acCmdPivotAutoSum ~ 412 ~ Insert a sum calculation field for the selected column in a pivot table acCmdPivotAutoVar ~ 418 ~ Insert a variance calculation field for the selected column in a pivot table acCmdPivotAutoVarP ~ 420 ~ Insert 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 acCmdPivotChartType ~ 453 acCmdPivotChartUndo ~ 460 acCmdPivotChartView ~ 397 acCmdPivotCollapse ~ 400 ~ Hide all the sub items for the selected item acCmdPivotDelete ~ 454 ~ Remove the selected field from the Pivot Table acCmdPivotDropAreas ~ 452 ~ Toggle the display of the field drop areas on the Pivot Table acCmdPivotExpand ~ 401 ~ Show all sub items for the selected item acCmdPivotRefresh ~ 404 ~ Refreshes the data in the Pivot Table acCmdPivotShowAll ~ 461 ~ Remove any filter that has been applied acCmdPivotShowBottom1 ~ 432 ~ Show bottom item for the selected field based on a calculated total acCmdPivotShowBottom10 ~ 435 ~ Show bottom 10 items for the selected field based on a calculated total acCmdPivotShowBottom10Percent ~ 440 ~ Show bottom 10% of items for the selected field based on a calculated total acCmdPivotShowBottom1Percent ~ 437 ~ Show bottom 1% of items for the selected field based on a calculated total acCmdPivotShowBottom2 ~ 433 ~ Show bottom 2 items for the selected field based on a calculated total acCmdPivotShowBottom25 ~ 436 ~ Show bottom 25 items for the selected field based on a calculated total acCmdPivotShowBottom25Percent ~ 441 ~ Show bottom 25% of items for the selected field based on a calculated total acCmdPivotShowBottom2Percent ~ 438 ~ Show bottom 2% of items for the selected field based on a calculated total acCmdPivotShowBottom5 ~ 434 ~ Show bottom 5 items for the selected field based on a calculated total acCmdPivotShowBottom5Percent ~ 439 ~ Show bottom 5% of items for the selected field based on a calculated total acCmdPivotShowBottomOther ~ 442 ~ Open the properties box for the field on the filter tab acCmdPivotShowTop1 ~ 421 ~ Show top item for the selected field acCmdPivotShowTop10 ~ 424 ~ Show top 10 items for the selected field acCmdPivotShowTop10Percent ~ 429 ~ Show top 10% of items for the selected field based on a calculated total acCmdPivotShowTop1Percent ~ 426 ~ Show top 1% of items for the selected field based on a calculated total acCmdPivotShowTop2 ~ 422 ~ Show top 2 items for the selected field acCmdPivotShowTop25 ~ 425 ~ Show top 25 items for the selected field acCmdPivotShowTop25Percent ~ 430 ~ Show top 25% of items for the selected field based on a calculated total acCmdPivotShowTop2Percent ~ 427 ~ Show top 2% of items for the selected field based on a calculated total acCmdPivotShowTop5 ~ 423 ~ Show top 5 items for the selected field acCmdPivotShowTop5Percent ~ 428 ~ Show top 5% of items for the selected field based on a calculated total acCmdPivotShowTopOther ~ 431 ~ Open the properties box for the field on the filter tab acCmdPivotTableClearCustomOrdering ~ 527 ~ Sort the selected field into a standard order acCmdPivotTableCreateCalcField ~ 444 ~ Insert a new column into the Pivot Table and opens the Properties Form to allow a calulation to be entered. acCmdPivotTableCreateCalcTotal ~ 443 ~ Add a new field to the data area and opens the properties box to allow entry of calculation. acCmdPivotTableDemote ~ 411 ~ Move a row heading one place to the right acCmdPivotTableExpandIndicators ~ 451 ~ Toggle the display of the Show/Hide indicators on the Pivot Table acCmdPivotTableExportToExcel ~ 405 ~ Export the Pivot Table to Excel acCmdPivotTableFilterBySelection ~ 528 ~ Filters the displayed items to those matching present selection acCmdPivotTableGroupItems ~ 530 ~ Create a new group from the selected values in a column acCmdPivotTableHideDetails ~ 402 ~ Hides details for an expanded group acCmdPivotTableMoveToColumnArea ~ 407 ~ Move the selected field to the column area of the Pivot Table acCmdPivotTableMoveToDetailArea ~ 409 ~ Move the selected field to the column area of the Pivot Table acCmdPivotTableMoveToFilterArea ~ 408 ~ Move the selected field to the filter area of the Pivot Table acCmdPivotTableMoveToRowArea ~ 406 ~ Move the selected field to the row area of the Pivot Table acCmdPivotTablePercentColumnTotal ~ 447 acCmdPivotTablePercentGrandTotal ~ 450 acCmdPivotTablePercentParentColumnItem ~ 449 acCmdPivotTablePercentParentRowItem ~ 448 acCmdPivotTablePercentRowTotal ~ 446 acCmdPivotTablePromote ~ 410 ~ Move a row heading one place to the right acCmdPivotTableRemove ~ 529 ~ Remove the selected field from the Pivot Table acCmdPivotTableShowAsNormal ~ 445 acCmdPivotTableShowDetails ~ 403 ~ Display the details for a collaped group acCmdPivotTableSubtotal ~ 399 acCmdPivotTableUngroupItems ~ 531 ~ Remove the grouping from the selcted group acCmdPivotTableView ~ 396 ~ Change a form to Pivot Table view 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 ~ Open the Print dialog box. Available in both VBE and non-VBE views acCmdPrintPreview ~ 54 ~ Open the print preview window acCmdPrintRelationships ~ 483 ~ Print the relationships diagram acCmdPrintSelection ~ 590 acCmdProcedureDefinition ~ 122 ~ Display the object browser at the definition of word under cursor acCmdProperties ~ 287 ~ Toggle the Properties window acCmdPublish ~ 320 ~ Start the Web Publisher Wizard acCmdPublishDatabase ~ 537 acCmdPublishFixedFormat ~ 591 acCmdQueryAddToOutput ~ 362 ~ Add a field to the output of a View acCmdQueryGroupBy ~ 361 ~ Add and hides the Group By column in the design of a View acCmdQueryParameters ~ 76 ~ Display the Parameters dialog acCmdQueryTotals ~ 73 ~ Toggle the Totals Line in a QBE grid acCmdQueryTypeAppend ~ 91 ~ Change a Query to an Append Query acCmdQueryTypeCrosstab ~ 74 ~ Change a Query to a Crosstab acCmdQueryTypeDelete ~ 92 ~ Change a Query to a Delete Query acCmdQueryTypeMakeTable ~ 94 ~ Change a Query to a Make Table Query acCmdQueryTypeSelect ~ 89 ~ Change a Query to a Select Query acCmdQueryTypeSQLDataDefinition ~ 168 ~ Change the Query to a Data Definition Query acCmdQueryTypeSQLPassThrough ~ 169 ~ Change the Query to a Pass Through Query acCmdQueryTypeSQLUnion ~ 180 ~ Change the Query to a Union Query acCmdQueryTypeUpdate ~ 90 ~ Change a Query to an Update Query acCmdQuickInfo ~ 304 ~ Display syntax help acCmdQuickPrint ~ 278 ~ Print without displaying the print dialog box acCmdQuickWatch ~ 203 ~ Display the Quick Watch dialog acCmdRecordsGoToFirst ~ 67 ~ Move to the first record acCmdRecordsGoToLast ~ 68 ~ Move to the last record acCmdRecordsGoToNew ~ 28 ~ Move to a new record acCmdRecordsGoToNext ~ 65 ~ Move to the next record acCmdRecordsGoToPrevious ~ 66 ~ Move to the previous record acCmdRecoverDesignMaster ~ 265 ~ Display the Recover Design Master dialog acCmdRedo ~ 199 ~ Redo last thing that was undone acCmdReferences ~ 260 ~ Display the References dialog acCmdRefresh ~ 18 ~ Refresh the data in the active window acCmdRefreshData ~ 541 acCmdRefreshPage ~ 297 ~ Refresh a sub form and all its fields behind an OnChange event acCmdRefreshSharePointList ~ 626 ~ Used to refresh all linked SharePoint tables. acCmdRegisterActiveXControls ~ 254 ~ Open the ActiveX Controls dialog acCmdRelationships ~ 133 ~ Open the Relationships window acCmdRemove ~ 366 acCmdRemoveAllFilters ~ 644 acCmdRemoveAllSorts ~ 645 acCmdRemoveFilterFromCurrentColumn ~ 643 acCmdRemoveFilterSort ~ 144 ~ Remove all filters and sorts acCmdRemoveFromLayout ~ 582 acCmdRemoveTable ~ 84 ~ Remove the selected table from the QBE grid acCmdRename ~ 143 ~ Allow editing the name of the object selected in the database window acCmdRenameColumn ~ 274 ~ Highlights column heading to enable renaming acCmdRenameGroup ~ 492 acCmdRepairDatabase ~ 6 ~ Open the Repair Database file selection dialog box. Note this cannot be used to repair the current database acCmdReplace ~ 29 ~ Open the Replace dialog. Available in both VBE and non-VBE views acCmdReportHdrFtr ~ 37 ~ Add or removes report headers and footers acCmdReportView ~ 539 acCmdReset ~ 124 ~ Reset running code acCmdResolveConflicts ~ 266 ~ Display the Resolve Replication Conflicts dialog acCmdRestore ~ 514 acCmdRowHeight ~ 116 ~ Display the Row Height dialog acCmdRun ~ 181 ~ Run a query acCmdRunMacro ~ 31 ~ Open the Run Macro dialog acCmdRunOpenMacro ~ 338 ~ Run a macro acCmdSave ~ 20 ~ Save the current object. Available in both VBE and non-VBE views acCmdSaveAllModules ~ 280 ~ Saves all Code Modules acCmdSaveAs ~ 21 ~ Display the Save As/Export selection dialog. Available in both VBE and non-VBE views acCmdSaveAsASP ~ 323 ~ File, Save As, ASP acCmdSaveAsDataAccessPage ~ 389 acCmdSaveAsHTML ~ 321 ~ Same as selecting HTML in the File Save As dialog box. (Not 'Save As HTML' Web Wizard acCmdPublish) acCmdSaveAsIDC ~ 322 ~ File, Save As, IDC acCmdSaveAsOutlookContact ~ 584 ~ Save a record as an Outlook Contact acCmdSaveAsQuery ~ 96 ~ Save a filter as a query acCmdSaveAsReport ~ 142 ~ Display the Save a Form as a Report dialog acCmdSaveAsTemplate ~ 686 acCmdSaveDatabaseAsNewTemplatePart ~ 687 acCmdSavedExports ~ 555 acCmdSavedImports ~ 543 acCmdSaveLayout ~ 145 ~ Save the layout of the Relationships window acCmdSaveModuleAsText ~ 119 ~ Open the File Save As box when in a module acCmdSaveRecord ~ 97 ~ Save the current record acCmdSaveSelectionAsNewDataType ~ 688 acCmdSelectAll ~ 333 ~ Select all the contents of the window acCmdSelectAllRecords ~ 109 ~ Select all the records acCmdSelectEntireColumn ~ 571 acCmdSelectEntireLayout ~ 715 acCmdSelectEntireRow ~ 570 acCmdSelectForm ~ 40 ~ Select the whole form acCmdSelectRecord ~ 50 ~ Select the whole of the current record acCmdSelectReport ~ 319 ~ Select the Report Object acCmdSend ~ 173 ~ Open the default mail system to send selected object acCmdSendToBack ~ 53 ~ Takes selection behind all other objects acCmdServerFilterByForm ~ 507 ~ Set the Server Filter by Form property acCmdServerProperties ~ 496 acCmdSetCaption ~ 637 acCmdSetControlDefaults ~ 56 ~ Change the defaults for the selected control acCmdSetDatabasePassword ~ 275 ~ Display the Set Database Password dialog acCmdSetNextStatement ~ 129 ~ Sets the next line of code to be run acCmdShareOnSharePoint ~ 542 acCmdSharePointSiteRecycleBin ~ 641 acCmdShowAllRelationships ~ 149 ~ Display all Relationships in the Relationships window acCmdShowColumnHistory ~ 620 acCmdShowDatePicker ~ 636 acCmdShowDirectRelationships ~ 148 ~ Display all connected Relationships from selected table acCmdShowEnvelope ~ 533 acCmdShowLogicCatalog ~ 685 acCmdShowMembers ~ 302 ~ Display the methods/properties drop down acCmdShowMessageBar ~ 676 acCmdShowNextStatement ~ 130 ~ Returns the screen back to the next line of code to run acCmdViewShowPaneDiagram acCmdViewShowPaneGrid acCmdViewShowPaneSQL acCmdShowTable ~ 185 ~ Display the Add Table dialog acCmdSingleStep ~ 88 ~ Single steps through a macro acCmdSizeToFit ~ 59 ~ Change size of control to best fit acCmdSizeToFitForm ~ 69 ~ Change the size of the Form Window to its design size acCmdSizeToGrid ~ 48 ~ Resize the selected object so that theier edges are aligned to the grid acCmdSizeToNarrowest ~ 155 ~ Change the width of all the selected controls to the width of the narrowest one acCmdSizeToWidest ~ 156 ~ Change the width of the selected controls to the width of the widest one acCmdSnapToGrid ~ 62 ~ Toggle the Snap To Grid option acCmdSortAscending ~ 163 ~ Sort by the selected field in ascending order acCmdSortDescending ~ 164 ~ Sort by the selected field in descending order acCmdSortingAndGrouping ~ 51 ~ Display/hides the sorting and grouping dialog acCmdSpeech ~ 511 acCmdSpelling ~ 269 ~ Run the Spell Checker acCmdSQLView ~ 184 ~ Change to SQL View acCmdStackedLayout ~ 568 acCmdStartNewWorkflow ~ 675 acCmdStartupProperties ~ 224 ~ Open the Startup Properties dialog acCmdStepInto ~ 342 ~ Step into the next line of code acCmdStepOut ~ 311 ~ Run code to next statement in calling procedure acCmdStepOver ~ 128 ~ Step over a line of code acCmdStepToCursor ~ 204 ~ Run through the code to the line containing the cursor acCmdStopLoadingPage ~ 296 ~ Halt the loading of a Web page acCmdSubformDatasheet ~ 108 ~ Toggle display of a subform to/from datasheet view acCmdSubdatasheetCollapseAll ~ 515 acCmdSubdatasheetExpandAll ~ 514 acCmdSubdatasheetRemove ~ 506 acCmdSubformDatasheetView ~ 463 ~ Display a subform as a datasheet acCmdSubformFormView ~ 462 ~ Display a subform as a form acCmdSubformInNewWindow ~ 495 acCmdSubformPivotChartView ~ 465 acCmdSubformPivotTableView ~ 464 acCmdSwitchboardManager ~ 521 acCmdSynchronize ~ 638 acCmdSynchronizeNow ~ 264 ~ Display the Synchronize Now dialog acCmdSyncWebApplication ~ 699 acCmdTabControlPageOrder ~ 330 ~ Display the Page Order dialog acCmdTableCustomView ~ 497 acCmdTableNames ~ 75 ~ Toggle display of the Table Names Line in a QBE grid acCmdTabOrder ~ 41 ~ Display the Tab Order dialog acCmdTabularLayout ~ 569 acCmdTestValidationRules ~ 196 ~ Test a table’s validation rules acCmdTileHorizontally ~ 286 ~ Tile the Access child windows horizontally acCmdTileVertically ~ 23 ~ Tile the Access child windows vertically acCmdToggleBreakpoint ~ 131 ~ Turn a break point on/off acCmdToggleCacheListData ~ 642 acCmdToggleFilter ~ 220 ~ Toggle a filter on/off acCmdToggleOffline ~ 540 acCmdToolbarsCustomize ~ 165 ~ Display the Customize Toolbars dialog. Available in both VBE and non-VBE views acCmdTransferSQLDatabase ~ 515 acCmdTransparentBackground ~ 288 ~ Set the background of a control to transparent acCmdTransparentBorder ~ 289 ~ Set the border color of a control to transparent acCmdUndo ~ 292 ~ Undo the last operation. Available in both VBE and non-VBE views acCmdUnfreezeAllColumns ~ 106 ~ Unfreeze all frozen columns acCmdUngroupControls ~ 485 ~ In design view of a form ungroup a number of controls acCmdUnhideColumns ~ 80 ~ Display the Unhide Columns Dialog acCmdUpsizingWizard ~ 522 acCmdUserAndGroupAccounts ~ 104 ~ Display the Security User and Group Accounts dialog box acCmdUserAndGroupPermissions ~ 103 ~ Display the User and Groups Permissions dialog acCmdUserLevelSecurityWizard ~ 276 ~ Display the User Level Security Wizard dialog acCmdVerticalSpacingDecrease ~ 161 ~ Decreases the vertical space between selected objects acCmdVerticalSpacingIncrease ~ 162 ~ Increases the vertical space between selected objects acCmdVerticalSpacingMakeEqual ~ 160 ~ Makes the vertical space between selected objects equal acCmdViewCode ~ 170 ~ Open the Code window for the selected object acCmdViewDataAccessPages ~ 349 ~ Display the Pages tab in Database Window acCmdViewDetails ~ 210 ~ Display details in database window acCmdViewFieldList ~ 353 ~ Display and hides the Field List in a View acCmdViewForms ~ 112 ~ Display the Form tab in Database Window acCmdViewFunctions ~ 395 acCmdViewGrid ~ 63 ~ Toggle display of the Grid in form and report design view acCmdViewLargeIcons ~ 209 ~ Display large icons in database window acCmdViewList ~ 212 ~ Display items in a list in the database window acCmdViewMacros ~ 114 ~ Display the Macro tab in Database Window acCmdViewModules ~ 115 ~ Display the Module tab in Database Window acCmdViewObjectDependencies ~ 536 acCmdViewQueries ~ 111 ~ Display the Query tab in Database Window acCmdViewReports ~ 113 ~ Display the Report tab in Database Window acCmdViewRuler ~ 61 ~ Toggle the display of the ruler in form and report design acCmdViewShowPaneDiagram ~ 358 ~ Toggle the display of the Diagram Pane when in the design of a View acCmdViewShowPaneGrid ~ 359 ~ Toggle the display of the Grid Pane when in the design of a View acCmdViewShowPaneSQL ~ 357 ~ Toggle the display of the SQL Pane when in the design of a View acCmdViewSmallIcons ~ 211 ~ Display small icons in database window acCmdViewTableColumnNames ~ 363 acCmdViewTableColumnProperties ~ 368 acCmdViewTableKeys ~ 369 acCmdViewTableNameOnly ~ 364 acCmdViewTables ~ 110 ~ Display the Table tab in Database Window acCmdViewTableUserView ~ 370 acCmdViewToolbox ~ 85 ~ Toggle the display of the Toolbox in form and report design acCmdViewVerifySQL ~ 360 ~ Verify the SQL in the design of a View ~ acCmdVisualBasicEditor ~ 525 ~ Open the Visual Basic Editor acCmdWebPagePreview ~ 466 acCmdWebPageProperties ~ 486 acCmdWebTheme ~ 473 acCmdWindowArrangeIcons ~ 24 ~ Arrange any minimized Access child windows along the bottom of the Access window acCmdWindowCascade ~ 22 ~ Cascade the Access child windows acCmdWindowHide ~ 2 ~ Hide the window that has the focus acCmdWindowSplit ~ 121 ~ Toggle the window split in a module acCmdWindowUnhide ~ 1 ~ Display the Window Unhide dialog box if any Windows have been hidden. Otherwise produces an error acCmdWordMailMerge ~ 195 ~ Open the Mail Merge dialog box acCmdWorkflowTasks ~ 674 acCmdZoom10 ~ 244 ~ Zoom print preview to 10% acCmdZoom100 ~ 240 ~ Zoom print preview to 100% acCmdZoom1000 ~ 482 ~ Zoom print preview to 1000% acCmdZoom150 ~ 239 ~ Zoom print preview to 150% acCmdZoom200 ~ 238 ~ Zoom print preview to 200% acCmdZoom25 ~ 243 ~ Zoom print preview to 25% acCmdZoom50 ~ 242 ~ Zoom print preview to 50% acCmdZoom500 ~ 481 ~ Zoom print preview to 500% acCmdZoom75 ~ 241 ~ Zoom print preview to 75% acCmdZoomBox ~ 179 ~ Open the zoom box acCmdZoomSelection ~ 371
This page is based on Access 2003, some constants may not be available in later versions.
“Happy is harder than money. Anyone who thinks money will make them happy, doesn’t have money” ~ David Geffen
Related
RunCommand - Run an Access menu or toolbar command