Access RunCommand Constants

MS Access Application.RunCommand() constants

These apply to menu commands, not all of 2003 is included and some are undocumented

NOTE: RunCommand() differs from DoCmd()

NOTE: some constants may exceed the maximum length of a WB constant

acCmdAboutMicrosoftAccess = 35 ;Displays the About Access Information dialog 
acCmdAddInManager = 526 ;I assume that it opens the Add In Manager window 
acCmdAddWatch = 201 ;Adds a variable to the Watch Window 
acCmdAddToNewGroup = 494 ;  
acCmdAdvancedFilterSort = 99 ;Displays QBE for filter 
acCmdAlignBottom = 46 ;Aligns the bottom edges of a selection of controls if no overlap. Else aligns top to bottom 
acCmdAlignCenter = 477 ;  
acCmdAlignLeft = 43 ;Aligns the left edges of a selection of controls if no overlap else abuts left edge to right edge 
acCmdAlignmentAndSizing = 478 ;I assume that it displays the Alignment toolbar 
acCmdAlignMiddle = 476 ;
acCmdAlignRight = 44 ;Aligns the right edges of a selection of controls if no overlap else abuts left edge to right edge 
acCmdAlignToGrid = 47 ;Aligns selection to grid. 
acCmdAlignTop = 45 ;Aligns the top edges of a selection of controls if no overlap else abuts top edge to bottom edge 
acCmdAlignToShortest = 153 ;Sizes selected controls to shortest 
acCmdAlignToTallest = 154 ;Sizes selected controls to tallest 
acCmdAnalyzePerformance = 283 ;Displays the Analyze Performance dialog 
acCmdAnalyzeTable = 284 ;Displays the Table Analyzer Wizard 
acCmdAnswerWizard = 235 ;Displays the Help Find dialog 
acCmdApplyDefault = 55 ;Apply's default formatting to selected control 
acCmdApplyFilterSort = 93 ;Apply's the filter entered in a Filter Design window. 
acCmdAppMaximize = 10 ;Maximizes Access Window. 
acCmdAppMinimize = 11 ;Minimize Access window 
acCmdAppMove = 12 ;Changes mouse into 4 headed arrow to enable the Access window to be moved. 
acCmdAppRestore = 9 ;Restores 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 ;Displays the AutoCorrect dialog 
acCmdAutoDial = 192 ;Automatically phones a selected number 
acCmdAutoFormat = 270 ;Displays the AutoFormat dialog 
acCmdBackgroundPicture = 474 ;  
acCmdBackgroundSound = 475 ;  
acCmdBackup = 513 ;  
acCmdBookmarksClearAll = 310 ;Clears all bookmarks 
acCmdBookmarksNext = 308 ;Moves to the next bookmark 
acCmdBookmarksPrevious = 309 ;Moves to the previous bookmark 
acCmdBookmarksToggle = 307 Adds/removes a bookmark  ;
acCmdBringToFront = 52 ;Brings selection to the front of all other objects. 
acCmdCallStack = 172 ;Displays a list of active procedure calls 
acCmdChangeToCheckBox = 231 ;Changes selected control to a check box 
acCmdChangeToComboBox = 230 ;Changes selected control to a combo box 
acCmdChangeToCommandButton = 501 ;Changes selection to a command button 
acCmdChangeToImage = 234 ;Changes selected control to an image 
acCmdChangeToLabel = 228 ;Changes selected control to a label 
acCmdChangeToListBox = 229 ;Changes selected control to a list box 
acCmdChangeToOptionButton = 233 ;Changes selected control to an option button 
acCmdChangeToTextBox = 227 ;Changes selected control to a textbox 
acCmdChangeToToggleButton = 232 ;Changes selected control to a toggle button 
acCmdChartSortAscByTotal =  ;Although this constant is listed in the Access XP help
acCmdChartSortDescByTotal =  ;Although this constant is listed in the Access XP help
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 
acCmdClearItemDefaults = 237 ;No idea at all. Possibly something to do with defaults in the design of Forms and reports. 
acCmdClose = 58 ;Closes object which has the focus 
acCmdCloseWindow = 186 ;Closes the current window 
acCmdColumnWidth = 117 ;Displays the Column Width dialog 
acCmdCompactDatabase = 4 ;Compacts a database. 
acCmdCompileAllModules = 125 ;Compiles all modules 
acCmdCompileAndSaveAllModules = 126 ;Compiles and saves all modules in the database. 
acCmdCompileLoadedModules = 290 ;Compiles loaded modules 
acCmdCompleteWord = 306 ;Displays list of objects/methods 
acCmdConditionalFormating = 500 ;Opens conditional formatting dialog 
acCmdConnection = 383 ;Connects the database to a server 
acCmdControlWizardsToggle = 197 ;Turns the control wizard on and off 
acCmdConvertDatabase = 171 ;Opens the Convert Database dialog 
acCmdConvertMacrosToVisualBasic = 279 ;Converts macros to code 
acCmdCopy = 190 ;Copies the selection to the clipboard. Available in both VBE and non-VBE views.  
acCmdCopyDatabaseFile = 516 ; 
acCmdCopyHyperlink = 328 ;Copies the hyperlink 
acCmdCreateMenuFromMacro = 334 ;Creates a menu toolbar from a macro 
acCmdCreateRelationship = 150 ;Displays the Create Relationship dialog 
acCmdCreateReplica = 263 ;Displays the Create Replica dialog??? 
acCmdCreateShortcut = 219 ;Opens the Create Shortcut dialog 
acCmdCreateShortcutMenuFromMacro = 336 ;Creates a shortcut menu from a macro 
acCmdCreateToolbarFromMacro = 335 ;Creates a toolbar from a macro 
acCmdCut = 189 ;Cuts the selection to the clipboard. Available in both VBE and non-VBE views. 
acCmdDataAccessPageAddToPage = 480 ;  
acCmdDataAccessPageBrowse = 344 ;  
acCmdDataAccessPageDesignView = 385 ;  
acCmdDataAccessPageFieldListRefresh = 479 ; 
acCmdDatabaseProperties = 256 ;Display the database properties dialog 
acCmdDatabaseSplitter = 520 ;  
acCmdDataEntry = 78 ;Changes view to data entry mode 
acCmdDataOutline = 468 ;  
acCmdDatasheetView = 282 ;Switches to datasheet view 
acCmdDateAndTime = 226 ;Displays the Date and Time dialog 
acCmdDebugWindow = 123 ;Displays the debug window but you have to open a module first 
acCmdDelete = 337 ;Deletes selected item. Available in both VBE and non-VBE views. 
acCmdDeleteGroup = 493 ;  
acCmdDeletePage = 332 ;Deletes a page from a tab control 
acCmdDeleteQueryColumn = 81 ;Removes a column from the QBE grid 
acCmdDeleteRecord = 223 ;Deletes the selected record 
acCmdDeleteRows = 188 ;Deletes rows 
acCmdDeleteTab = 255 ;Not used to delete a tab from a tab control that is acCmdDeletePage 
acCmdDeleteTable = 489 ;  
acCmdDeleteTableColumn = 271 ;Deletes the selected column from a table 
acCmdDeleteWatch = 267 ;Deletes the selected watch variable 
acCmdDemote = 388 ;Used on Data Access Pages to demote a Group heading 
acCmdDesignView = 183 ;Switches to Design View 
acCmdDiagramAddRelatedTables = 373 ;  
acCmdDiagramAutosizeSelectedTables = 378 ;  
acCmdDiagramDeleteRelationship = 382 ; 
acCmdDiagramLayoutDiagram = 380 ; 
acCmdDiagramLayoutSelection = 379 ; 
acCmdDiagramModifyUserDefinedView = 375 ; 
acCmdDiagramNewLabel = 372 ; 
acCmdDiagramNewTable = 381 ; 
acCmdDiagramRecalculatePageBreaks = 377 ; 
acCmdDiagramShowRelationshipLabels = 374 ; 
acCmdDiagramViewPageBreaks = 376 ; 
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 ;Restores 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 ;Displays the Documentor dialog 
acCmdDropSQLDatabase = 517 ;  
acCmdDuplicate = 34 ;Create a duplicate of the selected object. 
acCmdEditHyperlink = 325 ;Allows the editting of a Hyperlink 
acCmdEditingAllowed = 70 ;I think that this is something to do with the Editing Mode of a form. 
acCmdEditRelationship = 151 ;Displays the Edit Relationship dialog 
acCmdEditTriggers = 384 ; 
acCmdEditWatch = 202 ;Opens the Edit Watch dialog 
acCmdEncryptDecryptDatabase = 5 ;Opens the Encrypt/Decrypt Database dialog. 
acCmdEnd = 198 ;Stops the running of a procedure 
acCmdExit = 3 ;Closes Access completely. 
acCmdExport = 487 ;  
acCmdFavoritesAddTo = 299 ;Displays the Add To Favorites dialog 
acCmdFavoritesOpen = 298 ;Displays the Open Favorites dialog 
acCmdFieldList = 42 ;Display/hide the Field List dialog. 
acCmdFilterByForm = 207 ;Displays the filter by form dialog 
acCmdFilterBySelection = 208 ;Filters the displayed records by the selected item 
acCmdFilterExcludingSelection = 277 ;Filters out records that match selection 
acCmdFind = 30 ;Opens the Find dialog box. Available in both VBE and non-VBE views. 
acCmdFindNext = 341 ;Finds 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 ;Displays the Format Cells dialog 
acCmdFormHdrFtr = 36 ;Adds or removes form headers and footers 
acCmdFormView = 281 ;Switches to form view 
acCmdFreezeColumn = 105 ;Keeps the selected column in view 
acCmdGoBack = 294 ;Returns to the previous Web page 
acCmdGoContinue = 127 ;Resumes/starts code 
acCmdGoForward = 295 ;Moves to the next Web page 
acCmdGroupByTable = 387 ; 
acCmdGroupControls = 484 ; 
acCmdHideColumns = 79 ;Hides the selected column(s) 
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 ;Shows the text that is displayed for a hyperlink 
acCmdImport 257 Displays the File =  Get External Data ; Import dialog box. 
acCmdIndent = 205 ;Indents line of code 
acCmdIndexes = 152 ;Toggles display of the Indexes dialog 
acCmdInsertActiveXControl = 258 ;Displays the Insert ActiveX Control dialog 
acCmdInsertChart = 293 ;Inserts a chart 
acCmdInsertFile = 39 ;This is not to insert a file into a module which is acCmdInsertFileIntoModule. 
acCmdInsertFileIntoModule = 118 ;Displays the Insert File dialog 
acCmdInsertHyperlink = 259 ;Displays the Insert Hyperlink dialog 
acCmdInsertLookupColumn = 273 ;Displays the LookUp wizard 
acCmdInsertLookupField = 291 ;Starts the Lookup Wizard 
acCmdInsertMovieFromFile = 469 ;  
acCmdInsertObject = 33 ;Opens the Insert Object Dialog 
acCmdInsertPage = 331 ;Inserts a new page to a tab control 
acCmdInsertPicture = 222 ;Displays the Insert Picture dialog 
acCmdInsertPivotTable = 470 ; 
acCmdInsertProcedure = 262 ;Displays the Insert Procedure dialog 
acCmdInsertQueryColumn = 82 ;Insets a column into the QBE grid. 
acCmdInsertRows = 187 ;Inserts rows 
acCmdInsertSpreadsheet = 471 ; 
acCmdInsertSubdatasheet = 499   ;
acCmdInsertTableColumn = 272 ;Inserts column into a table 
acCmdInsertUnboundSection = 472 ;  
acCmdInvokeBuilder = 178 ;Open the Builder dialog 
acCmdJoinProperties = 72 ;Displays the Join Properties dialog 
acCmdLastPosition = 339 ;Returns cursor to last position in the module window 
acCmdLayoutPreview = 141 ;Print Preview with sample data 
acCmdLineUpIcons = 213 ;Line up icons in columns 
acCmdLinkTableManager = 519 Opens the Linked Table Manager dialog  ;
acCmdLinkTables = 102 ;Displays the Link tables dialog 
acCmdListConstants = 303 ;Display drop down in code window of available constants 
acCmdLoadFromQuery = 95 ;Opens the Applicable Query dialog 
acCmdMacroConditions = 87 ;Toggles the display of the Macro Conditions column 
acCmdMacroNames = 86 ;Toggles the display of the Macro Names column 
acCmdMakeMDEFile = 7 ;Creates a MDE File but can not be used for the active Database. 
acCmdMaximumRecords = 508 ;  
acCmdMicrosoftAccessHelpTopics = 100 ;Displays the Help contents 
acCmdMicrosoftOnTheWeb = 236 ;Displays the Microsoft On the Web Menu??? 
acCmdMicrosoftScriptEditor = 390 ; 
acCmdMoreWindows = 8 ;Displays the Window List dialog box. 
acCmdNewDatabase = 26 ;Opens the new database dialog 
acCmdNewGroup = 491 ;  
acCmdNewObjectAutoForm = 193 ;Creates a new form if a table/query has been selected in database window 
acCmdNewObjectAutoReport = 194 ;Creates a new report if a table/query has been selected in database window 
acCmdNewObjectClassModule = 140 ;Creates a new Class Module 
acCmdNewObjectDataAccessPage = 346 ; 
acCmdNewObjectDiagram = 352 ; 
acCmdNewObjectForm = 136 ;Displays the New Form dialog 
acCmdNewObjectFunction = 394 ;  
acCmdNewObjectMacro = 138 ;Opens a New Macro Window 
acCmdNewObjectModule = 139 ;Creates a new Module. 
acCmdNewObjectQuery = 135 ;Displays the New Query dialog 
acCmdNewObjectReport = 137 ;Displays the New Report dialog 
acCmdNewObjectStoredProcedure = 351 ; 
acCmdNewObjectTable = 134 ;Displays the New Table dialog 
acCmdNewObjectView = 350 ; 
acCmdObjBrwFindWholeWordOnly = 314 ;Toggles the Find Whole Word Only option. Only available when the Object Browser is active. 
acCmdObjBrwGroupMembers = 318 ;Toggles the Group Members option. Only available when the Object Browser is active. 
acCmdObjBrwHelp = 316 ;Opens Help on selected item. Only available when the Object Browser is active. 
acCmdObjBrwShowHiddenMembers = 315 ;Toggles the Show Hidden Members option. Only available when the Object Browser is active. 
acCmdObjBrwViewDefinition = 317 ;Displays the selected module. Only available when the Object Browser is active. 
acCmdObjectBrowser = 200 ;Displays the Object Browser. Only available when the Object Browser is active.  
acCmdOfficeClipboard = 488 ;  
acCmdOLEDDELinks = 27 ;Opens the OLE/DDE Links dialog. 
acCmdOLEObjectConvert = 167 ;Display the Convert dialog 
acCmdOLEObjectDefaultVerb = 57 ;Displays OLE object in its native application 
acCmdOpenDatabase = 25 ;Displays the open database dialog 
acCmdOpenHyperlink = 326 ;Opens the item associated with the hyperlink 
acCmdOpenNewHyperlink = 327 ;Opens the item associated with the hyperlink in a new window 
acCmdOpenSearchPage = 253 ;Starts up default Web Browser and locates the default search engine??? 
acCmdOpenStartPage = 252 ;Starts up default Web Browser at the users start page??? 
acCmdOpenTable = 221 ;Opens a table 
acCmdOpenURL = 251 ;Starts up default Web Browser and locates selected URL??? 
acCmdOptions = 49 ;Opens the Tools Options dialog box. Available in both VBE and non-VBE views. 
acCmdOutdent = 206 ;Outdents a line of code 
acCmdOutputToExcel = 175 ;Exports the selected object to Excel 
acCmdOutputToRTF = 176 ;Outputs 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 ;Toggles display of the page header and footer 
acCmdPageNumber = 225 ;Displays the Page Number dialog 
acCmdPageProperties = 467 ; 
acCmdPageSetup = 32 ;Opens the Page Setup dialog 
acCmdParameterInfo = 305 ;If not using autofill shows the list of arguments for a function 
acCmdPartialReplicaWizard = 524 ; 
acCmdPaste = 191 ;Pastes from the clipboard. Available in both VBE and non-VBE views. 
acCmdPasteAppend = 38 ;Pastes a copied record as a new record 
acCmdPasteAsHyperlink = 490 ; 
acCmdPasteSpecial = 64 ;Displays the Paste Special dialog 
acCmdPivotAutoAverage = 416 ; 
acCmdPivotAutoCount = 413 ; 
acCmdPivotAutoFilter = 398 ; 
acCmdPivotAutoMax = 415 ; 
acCmdPivotAutoMin = 414 ; 
acCmdPivotAutoStdDev = 417 ; 
acCmdPivotAutoStdDevP = 419 ; 
acCmdPivotAutoSum = 412 ; 
acCmdPivotAutoVar = 418 ; 
acCmdPivotAutoVarP = 420 ; 
acCmdPivotChartByRowByColumn = 456 ; 
acCmdPivotChartDrillInto = 457 ; 
acCmdPivotChartDrillOut = 532 ; 
acCmdPivotMultiplePlots = 458 ; 
acCmdPivotMultiplePlotsUnifiedScale = 459 ; 
acCmdPivotChartShowLegend = 455 ; 
acCmdPivotChartSortAscByTotal = 534 ; 
acCmdPivotChartSortDescByTotal = 535 ; 
acCmdPivotChartType = 453 ; 
acCmdPivotChartUndo = 460 ; 
acCmdPivotChartView = 397 ; 
acCmdPivotCollapse = 400 ; 
acCmdPivotDelete = 454 ; 
acCmdPivotDropAreas = 452 ; 
acCmdPivotExpand = 401 ; 
acCmdPivotRefresh = 404 ; 
acCmdPivotShowAll = 461 ; 
acCmdPivotShowBottom1 = 432 ; 
acCmdPivotShowBottom10 = 435 ; 
acCmdPivotShowBottom10Percent = 440 ; 
acCmdPivotShowBottom1Percent = 437 ; 
acCmdPivotShowBottom2 = 433 ; 
acCmdPivotShowBottom25 = 436 ; 
acCmdPivotShowBottom25Percent = 441 ; 
acCmdPivotShowBottom2Percent = 438 ; 
acCmdPivotShowBottom5 = 434 ; 
acCmdPivotShowBottom5Percent = 439 ; 
acCmdPivotShowBottomOther = 442 ; 
acCmdPivotShowTop1 = 421 ; 
acCmdPivotShowTop10 = 424 ; 
acCmdPivotShowTop10Percent = 429 ; 
acCmdPivotShowTop1Percent = 426 ; 
acCmdPivotShowTop2 = 422 ; 
acCmdPivotShowTop25 = 425 ; 
acCmdPivotShowTop25Percent = 430 ; 
acCmdPivotShowTop2Percent = 427 ; 
acCmdPivotShowTop5 = 423 ; 
acCmdPivotShowTop5Percent = 428 ; 
acCmdPivotShowTopOther = 431 ; 
acCmdPivotTableCustomOrdering = 527 ; 
acCmdPivotTableCreateCalcField = 444 ; 
acCmdPivotTableCreateCalcTotal = 443 ; 
acCmdPivotTableDemote = 411 ; 
acCmdPivotTableExpandIndicators = 451 ; 
acCmdPivotTableExportToExcel = 405 ; 
acCmdPivotTableFilterBySelection = 528 ; 
acCmdPivotTableGroupItems = 530 ; 
acCmdPivotTableHideDetails = 402 ; 
acCmdPivotTableMoveToColumnArea = 407 ; 
acCmdPivotTableMoveToColumnDetailArea = 409 ; 
acCmdPivotTableMoveToFilterArea = 408 ; 
acCmdPivotTableMoveToRowArea = 406 ; 
acCmdPivotTablePercentColumnTotal = 447 ; 
acCmdPivotTablePercentGrandTotal = 450 ; 
acCmdPivotTablePercentParentColumnItem = 449 ; 
acCmdPivotTablePercentParentRowItem = 448 ; 
acCmdPivotTablePercentRowTotal = 446 ; 
acCmdPivotTablePromote = 410 ; 
acCmdPivotTableRemove = 529 ; 
acCmdPivotTableShowAsNormal = 445 ; 
acCmdPivotTableShowDetails = 403 ; 
acCmdPivotTableSubtotal = 399 ; 
acCmdPivotTableUngroupItems = 531 ; 
acCmdPivotTableView = 396 ; 
acCmdPreviewEightPages = 249 ;Display eight pages in print preview 
acCmdPreviewFourPages = 248 ;Display four pages in print preview 
acCmdPreviewOnePage = 246 ;Display one page in print preview 
acCmdPreviewTwelvePages = 250 ;Display twelve pages in print preview 
acCmdPreviewTwoPages = 247 ;Display two pages in print preview 
acCmdPrimaryKey = 107 ;Sets/removes the Primary key on the selected field(s) 
acCmdPrint = 340 ;Opens the Print dialog box. Available in both VBE and non-VBE views. 
acCmdPrintPreview = 54 ;Opens the print preview window. 
acCmdPrintRelationships = 483 ; 
acCmdProcedureDefinition = 122 ;Displays the object browser at the definition of word under cursor 
acCmdPromote = 386 ;Used on Data Access Pages to promote a Group heading 
acCmdProperties = 287 ;Toggles the Properties window 
acCmdPublish = 320 ;Starts the Web Publisher Wizard 
acCmdPublishDefaults = 324 ;Sets or calls Webpublishing Wizard defaults? 
acCmdQueryAddToOutput = 362 ; 
acCmdQueryGroupBy = 361 ; 
acCmdQueryParameters = 76 ;Displays the Parameters dialog 
acCmdQueryTotals = 73 ;Toggles the Totals Line in a QBE grid 
acCmdQueryTypeAppend = 91 ;Changes a Query to an Append Query 
acCmdQueryTypeCrosstab = 74 ;Changes a Query to a Crosstab 
acCmdQueryTypeDelete = 92 ;Changes a Query to a Delete Query 
acCmdQueryTypeMakeTable = 94 ;Changes a Query to a Make Table Query 
acCmdQueryTypeSelect = 89 ;Changes a Query to a Select Query 
acCmdQueryTypeSQLDataDefinition = 168 ;Changes the Query to a Data Definition Query 
acCmdQueryTypeSQLPassThrough = 169 ;Changes the Query to a Pass Through Query 
acCmdQueryTypeSQLUnion = 180 ;Changes the Query to a Union Query 
acCmdQueryTypeUpdate = 90 ;Changes a Query to an Update Query 
acCmdQuickInfo = 304 ;Displays syntax help 
acCmdQuickPrint = 278 ;Prints without displaying the print dialog box 
acCmdQuickWatch = 203 ;Displays the Quick Watch dialog 
acCmdRecordsGoToFirst = 67 ;Moves to the first record 
acCmdRecordsGoToLast = 68 ;Moves to the last record 
acCmdRecordsGoToNew = 28 ;Moves to a new record 
acCmdRecordsGoToNext = 65 ;Moves to the next record 
acCmdRecordsGoToPrevious = 66 ;Moves to the previous record 
acCmdRecoverDesignMaster = 265 ;Displays the Recover Design Master dialog 
acCmdRedo = 199 ;Redoes last thing that was undone 
acCmdReferences = 260 ;Displays the References dialog 
acCmdRefresh = 18 ;Refreshes the data in the active window. 
acCmdRefreshPage = 297 ;Refreshes the current Web Page??? 
acCmdRegisterActiveXControls = 254 ;Opens the ActiveX Controls dialog 
acCmdRelationships = 133 ;Opens the Relationships window. 
acCmdRemove = 366 ; 
acCmdRemoveFilterSort = 144 ;Removes all filters and sorts 
acCmdRemoveTable = 84 ;Removes the selected table from the QBE grid 
acCmdRename = 143 ;Allows the editing of the name of the object selected in the database window 
acCmdRenameColumn = 274 ;Highlights column heading to enable renaming 
acCmdRenameGroup = 492 ; 
acCmdRepairDatabase = 6 ;Opens the Repair Database file selection dialog box. Note this cannot be used to repair the current database. 
acCmdReplace = 29 ;Opens the Replace dialog. Available in both VBE and non-VBE views. 
acCmdReportHdrFtr = 37 ;Adds or removes report headers and footers 
acCmdReset = 124 ;Resets running code 
acCmdResolveConflicts = 266 ;Displays the Resolve Conflicts dialog 
acCmdRestore = 514 ; 
acCmdRowHeight = 116 ;Displays the Row Height dialog 
acCmdRun = 181 ;Runs a query 
acCmdRunMacro = 31 ;Opens the Run Macro dialog 
acCmdRunOpenMacro = 338 ;Run a macro 
acCmdSave = 20 ;Saves the current object. Available in both VBE and non-VBE views. 
acCmdSaveAllModules = 280 ;Saves all Code Modules? 
acCmdSaveAllRecords =  ;Although this is listed in the Access XP help
acCmdSaveAs = 21 ;Displays the Save As/Export selection dialog. Available in both VBE and non-VBE views. 
acCmdSaveAsASP = 323 ;Same as selecting ASP in the File Save As dialog box 
acCmdSaveAsDataAccessPage = 389 ; 
acCmdSaveAsHTML = 321 ;Same as selecting HTML in the File Save As dialog box. Not Save As HTML on File menu which starts Web Wizard. That is acCmdPublish 
acCmdSaveAsIDC = 322 ;Same as selecting IDC in the File Save As dialog box 
acCmdSaveAsQuery = 96 ;Saves a filter as a query 
acCmdSaveAsReport = 142 ;Displays the Save a Form as a Report dialog 
acCmdSaveLayout = 145 ;Saves the layout of the Relationships window 
acCmdSaveModuleAsText = 119 ;Opens the File Save As box when in a module 
acCmdSaveRecord = 97 ;Saves the current record 
acCmdSelectAll = 333 ;Selects all the contents of the window 
acCmdSelectAllRecords = 109 ;Selects all the records 
acCmdSelectDataAccessPage = 347 ; 
acCmdSelectForm = 40 ;Selects the whole form. 
acCmdSelectRecord = 50 ;Selects the whole of the current record. 
acCmdSelectReport = 319 ;Selects the Report Object 
acCmdSend = 173 ;Opens the default mail system to send selected object 
acCmdSendToBack = 53 ;Takes selection behind all other objects. 
acCmdServerFilterByForm = 507 ;Sets the Server Filter by Form property. 
acCmdServerProperties = 496 ; 
acCmdSetControlDefaults = 56 ;Change the defaults for the selected control 
acCmdSetDatabasePassword = 275 ;Displays the Set Database Password dialog 
acCmdSetNextStatement = 129 ;Sets the next line of code to be run 
acCmdShowAllRelationships = 149 ;Displays all Relationships in the Relationships window 
acCmdShowDirectRelationships = 148 ;Displays all connected Relationships from selected table 
acCmdShowEnvelope = 533 ; 
acCmdShowMembers = 302 ;Displays the methods/properties drop down 
acCmdShowNextStatement = 130 ;Returns the screen back to the next line of code to run 
acCmdShowOnlyWebToolbar = 300 ;Closes all toolbars but the Web toolbar 
acCmdShowPaneDiagram =  ;This is listed on the Microsoft site but it is not in Help or listed in the Object Browser. I think that it should probably be acCmdViewShowPaneDiagram. 
acCmdShowPaneGrid =  ;This is listed on the Microsoft site but it is not in Help or listed in the Object Browser. I think that it should probably be acCmdViewShowPaneGrid. 
acCmdShowPaneSQL =  ;This is listed on the Microsoft site but it is not in Help or listed in the Object Browser. I think that it should probably be acCmdViewShowPaneSQLs. 
acCmdShowTable = 185 ;Displays the Add Table dialog 
acCmdSingleStep = 88 ;Single steps through a macro 
acCmdSizeToFit = 59 ;Changes size of control to best fit. 
acCmdSizeToFitForm = 69 ;Changes the size of the Form Window to it's design size 
acCmdSizeToGrid = 48 ;Snaps edges of selection to grid size. 
acCmdSizeToNarrowest = 155 ;Sizes selected controls to narrowest 
acCmdSizeToWidest = 156 ;Sizes selected controls to widest 
acCmdSnapToGrid = 62 ;Toggles the Snap To Grid option 
acCmdSortAscending = 163 ;Sorts by the selected field in ascending order 
acCmdSortDescending = 164 ;Sorts by the selected field in descending order 
acCmdSortingAndGrouping = 51 ;Displays/hides the sorting and grouping dialog 
acCmdSpeech = 511 ; 
acCmdSpelling = 269 ;Runs the Spell Checker. 
acCmdSQLView = 184 ;Changes to SQL View 
acCmdStartupProperties = 224 ;Opens the Startup Properties dialog 
acCmdStepInto = 342 ;Steps into the next line of code 
acCmdStepOut = 311 ;Runs code to next statement in calling procedure 
acCmdStepOver = 128 ;Steps over a line of code 
acCmdStepToCursor = 204 ;Runs through the code to the line containing the cursor 
acCmdStopLoadingPage = 296 ;Halts the loading of a Web page 
acCmdSubformDatasheet = 108 ;Toggles display of a subform to/from datasheet view 
acCmdSubdatasheetCollapseAll = 515 ; 
acCmdSubdatasheetExpandAll = 514 ; 
acCmdSubdatasheetRemove = 506 ; 
acCmdSubformDatasheetView = 463 ; 
acCmdSubformFormView = 462 ; 
acCmdSubformInNewWindow = 495 ; 
acCmdSubformPivotChartView = 465 ; 
acCmdSubformPivotTableView = 464 ; 
acCmdSwitchboardManager = 521 ; 
acCmdSynchronizeNow = 264 ;Displays the Synchronize Now dialog 
acCmdTabControlPageOrder = 330 ;Displays the Page Order dialog 
acCmdTableAddTable = 498 ; 
acCmdTableCustomView = 497 ; 
acCmdTableNames = 75 ;Toggles display of the Table Names Line in a QBE grid 
acCmdTabOrder = 41 ;Displays the Tab Order dialog. 
acCmdTestValidationRules = 196 ;Tests a table's validation rules 
acCmdTileHorizontally = 286 ;Tiles the Access child windows horizontally 
acCmdTileVertically = 23 ;Tiles the Access child windows vertically 
acCmdToggleBreakpoint = 131 ;Turns a break point on/off 
acCmdToggleFilter = 220 ;Toggles a filter on/off 
acCmdToolbarControlProperties = 301 ;Display properties for controls on Toolbars from the customize box? 
acCmdToolbarsCustomize = 165 ;Displays the Customize Toolbars dialog. Available in both VBE and non-VBE views. 
acCmdTransferSQLDatabase = 515 ; 
acCmdTransparentBackground = 288 ;Sets the background of a control to transparent 
acCmdTransparentBorder = 289 ;Sets the border color to transparent 
acCmdUndo = 292 ;Undoes the last operation. Available in both VBE and non-VBE views. 
acCmdUndoAllRecords =  ;Although listed in Help
acCmdUnfreezeAllColumns = 106 ;Unfreezes all frozen columns 
acCmdUngroupControls = 485 ; 
acCmdUnhideColumns = 80 ;Displays the Unhide Columns Dialog 
acCmdUpsizingWizard = 522 ; 
acCmdUserAndGroupAccounts = 104 ;Displays the Security User and Group Accounts dialog box. 
acCmdUserAndGroupPermissions = 103 ;Displays the User and Groups Permissions dialog 
acCmdUserLevelSecurityWizard = 276 ;Displays 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 ;Opens the Code window for the selected object. 
acCmdViewDataAccessPages = 349 ; 
acCmdViewDetails = 210 ;Displays details in database window 
acCmdViewDiagrams = 354 ; 
acCmdViewFieldList = 353 ; 
acCmdViewForms = 112 ;Displays the Form tab in Database Window 
acCmdViewFunctions = 395 ; 
acCmdViewGrid = 63 ;Toggles display of the Grid 
acCmdViewLargeIcons = 209 ;Displays large icons in database window 
acCmdViewList = 212 ;Displays items in a list in the database window 
acCmdViewMacros = 114 ;Displays the Macro tab in Database Window 
acCmdViewModules = 115 ;Displays the Module tab in Database Window 
acCmdViewObjectDependencies = 536 ; 
acCmdViewQueries = 111 ;Displays the Query tab in Database Window 
acCmdViewReports = 113 ;Displays the Report tab in Database Window 
acCmdViewRuler = 61 ;Toggles the display of the ruler. 
acCmdViewShowPaneDiagram = 358 ; 
acCmdViewShowPaneGrid = 359 ; 
acCmdViewShowPaneSQL = 357 ; 
acCmdViewSmallIcons = 211 ;Displays small icons in database window 
acCmdViewStoredProcedures = 355 ; 
acCmdViewTableColumnNames = 363 ; 
acCmdViewTableColumnProperties = 368 ; 
acCmdViewTableKeys = 369 ; 
acCmdViewTableNameOnly = 364 ; 
acCmdViewTables = 110 ;Displays the Table tab in Database Window 
acCmdViewTableUserView = 370 ; 
acCmdViewToolbox = 85 ;Toggles the display of the Toolbox 
acCmdViewVerifySQL = 360 ; 
acCmdViewViews = 356 ; 
acCmdVisualBasicEditor = 525 ;Opens the Visual Basic Editor 
acCmdWebPagePreview = 466 ; 
acCmdWebPageProperties = 486 ; 
acCmdWebTheme = 473 ; 
acCmdWindowArrangeIcons = 24 ;Arranges any minimized Access child windows along the bottom of the Access window. 
acCmdWindowCascade = 22 ;Cascades the Access child windows 
acCmdWindowHide = 2 ;Hides the window that has the focus. 
acCmdWindowSplit = 121 ;Toggles the window split in a module 
acCmdWindowUnhide = 1 ;Displays the Window Unhide dialog box if any Windows have been hidden. Otherwise produces an error. 
acCmdWordMailMerge = 195 ;Opens the Mail Merge dialog box 
acCmdWorkGroupAdministrator = 391 ; 
acCmdZoom10 = 244 ;Zoom print preview to 10% 
acCmdZoom100 = 240 ;Zoom print preview to 100% 
acCmdZoom1000 = 482 ; 
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 ; 
acCmdZoom75 = 241 ;Zoom print preview to 75% 
acCmdZoomBox = 179 ;Opens the zoom box 
acCmdZoomSelection = 371 ;

Article ID:   W16593

File Created: 2005:02:18:12:21:34

Last Updated: 2005:02:18:12:21:34

Database Search

TechHome

Access RunCommand Constants