Access RunCommands

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 it's 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


© Copyright SS64.com 1999-2017
Some rights reserved