office交流網(wǎng)--QQ交流群號(hào)

Access培訓(xùn)群：792054000         Excel免費(fèi)交流群群：686050929          Outlook交流群：221378704    

Word交流群：218156588             PPT交流群：324131555

手工整理的Access最全的docmd.RunCommand命令中英文說明大全

2019-03-08 10:22:00
tmtony8
原創(chuàng)
33811

VBA中，可以使用RunCommand 方法來運(yùn)行內(nèi)置的命令。

Access 中的每個(gè)菜單命令和工具欄命令都有一個(gè)相關(guān)的常量，可以將常量與 RunCommand 方法結(jié)合使用來執(zhí)行該常量對(duì)應(yīng)的命令。



列舉部分參數(shù)說明，完整參數(shù)說明請(qǐng)下載附件查看

部分有鏈接的參數(shù)都有示例說明使用方法和作用

參數(shù) 值 英文說明 中文說明 版本
acCmdAboutMicrosoftAccess 35 Displays the About Access Information dialog 顯示關(guān)于ACCESS的信息對(duì)話框 97
acCmdAddDataMacroAfterDelete 720

2010
acCmdAddDataMacroAfterInsert 718

2010
acCmdAddDataMacroAfterUpdate 719

2010
acCmdAddDataMacroValidateChange 722

2010
acCmdAddDataMacroValidateDelete 721

2010
acCmdAddFromOutlook 583

2007
acCmdAddInManager 526
打開COM加載項(xiàng)管理器 2002
acCmdAddNamedDataMacro 723

2010
acCmdAddToNewGroup 494

2002
acCmdAddWatch 201 Adds a variable to the Watch Window 添加一個(gè)變量到監(jiān)視窗口 97
acCmdAdvancedFilterSort 99 Displays QBE for filter 顯示高組查詢生成窗口，以生成過濾排序等 97
acCmdAlignBottom 46 Aligns the bottom edges of a selection of controls if no overlap. Else aligns top to bottom. 如果沒有重疊，就將你選擇的控件向下對(duì)齊，否則對(duì)齊上下邊（不知如何用詞，自己試試就知道了 97
acCmdAlignCenter 477
居中對(duì)齊 2002
acCmdAlignLeft 43 Aligns the left edges of a selection of controls if no overlap else abuts left edge to right edge. 如果沒有重疊，就將你選擇的控件向左對(duì)齊 否則鄰接左右邊界 97
acCmdAlignmentAndSizing 478

2002
acCmdAlignMiddle 476
垂直居中對(duì)齊 2002
acCmdAlignRight 44 Aligns the right edges of a selection of controls if no overlap else abuts left edge to right edge. 如果沒有重疊，就將你選擇的控件向右對(duì)齊 否則鄰接左右邊界 97
acCmdAlignToGrid 47 Aligns selection to grid. 將你選擇的控件對(duì)齊網(wǎng)格 97
acCmdAlignTop 45 Aligns the top edges of a selection of controls if no overlap else abuts top edge to bottom edge. 如果沒有重疊，就將你選擇的控件向上對(duì)齊 否則鄰接上下邊界 97
acCmdAlignToShortest 153 Sizes selected controls to shortest 將選擇的控件大小改變至最短 97
acCmdAlignToTallest 154 Sizes selected controls to tallest 將選擇的控件大小改變至最高 97
acCmdAnalyzePerformance 283 Displays the Analyze Performance dialog 顯示性能分析向?qū)Т翱?/span> 97
acCmdAnalyzeTable 284 Displays the Table Analyzer Wizard 顯示表分析向?qū)?/span> 97
acCmdAnchorBottomLeft 616

2007
acCmdAnchorBottomRight 618

2007
acCmdAnchorBottomStretchAcross 617

2007
acCmdAnchorStretchAcross 611

2007
acCmdAnchorStretchDown 613

2007
acCmdAnchorStretchDownAcross 614

2007
acCmdAnchorStretchDownRight 615

2007
acCmdAnchorTopLeft 610

2007
acCmdAnchorTopRight 612

2007
acCmdAnswerWizard 235 Displays the Help Find dialog 顯示查找?guī)椭翱?/span> 97
acCmdApplyAutoFormat1 648

2007
acCmdApplyAutoFormat10 657

2007
acCmdApplyAutoFormat11 658

2007
acCmdApplyAutoFormat12 659

2007
acCmdApplyAutoFormat13 660

2007
acCmdApplyAutoFormat14 661

2007
acCmdApplyAutoFormat15 662

2007
acCmdApplyAutoFormat16 663

2007
acCmdApplyAutoFormat17 664

2007
acCmdApplyAutoFormat18 665

2007
acCmdApplyAutoFormat19 666

2007
acCmdApplyAutoFormat2 649

2007
acCmdApplyAutoFormat20 667

2007
acCmdApplyAutoFormat21 668

2007
acCmdApplyAutoFormat22 669

2007
acCmdApplyAutoFormat23 670

2007
acCmdApplyAutoFormat24 671

2007
acCmdApplyAutoFormat25 672

2007
acCmdApplyAutoFormat3 650

2007
acCmdApplyAutoFormat4 651

2007
acCmdApplyAutoFormat5 652

2007
acCmdApplyAutoFormat6 653

2007
acCmdApplyAutoFormat7 654

2007
acCmdApplyAutoFormat8 655

2007
acCmdApplyAutoFormat9 656

2007
acCmdApplyDefault 55 Apply's default formatting to selected control. 應(yīng)用缺省的格式給選擇的控件 97
acCmdApplyFilterSort 93 Apply's the filter entered in a Filter Design window. 應(yīng)用你在過濾設(shè)計(jì)窗體輸入的過濾條件 97
acCmdAppMaximize 10 Maximizes Access Window. 最大化ACCESS窗體 97
acCmdAppMinimize 11 Minimize Access window 最小化ACCESS窗體 97
acCmdAppMove 12 Changes mouse into 4 headed arrow to enable the Access window to be moved. 將光標(biāo)設(shè)成4個(gè)箭頭形狀且同時(shí)可移動(dòng)ACCESS窗口 97
acCmdAppRestore 9 Restores Access window. 還原ACCESS窗體 97
acCmdAppSize 13 Size Access window 改變ACCESS窗體大小 97
acCmdArrangeIconsAuto 218 Auto arrange icons 自動(dòng)排列圖標(biāo) 97
acCmdArrangeIconsByCreated 216 Arrange the icons in date created order 按創(chuàng)建日期順序排列圖標(biāo) 97
acCmdArrangeIconsByModified 217 Arrange the icons in date modified order 按修改日期順序排列圖標(biāo) 97
acCmdArrangeIconsByName 214 Arrange icons in database window in alphabetical order 在數(shù)據(jù)窗體按阿拉伯字母順序排列圖標(biāo) 97
acCmdArrangeIconsByType 215 Arranges icons by the type of object 按對(duì)象類型排列圖標(biāo) 97
acCmdAutoCorrect 261 Displays the AutoCorrect dialog 顯示自動(dòng)糾正窗口 97
acCmdAutoDial 192 Automatically phones a selected number 自動(dòng)拔選擇的電話號(hào)碼 97
acCmdAutoFormat 270 Displays the AutoFormat dialog 顯示自動(dòng)格式對(duì)話框 97
acCmdBackgroundPicture 474

2002
acCmdBackgroundSound 475

2002
acCmdBackup 513

2002
acCmdBookmarksClearAll 310 Clears all bookmarks 刪除所的有書簽 97
acCmdBookmarksNext 308 Moves to the next bookmark 移至下一條書簽 97
acCmdBookmarksPrevious 309 Moves to the previous bookmark 移至上一條書簽 97
acCmdBookmarksToggle 307 Adds/removes a bookmark 增加/刪除一條書簽 97
acCmdBringToFront 52 Brings selection to the front of all other objects. 至于最前 97
acCmdBrowseSharePointList 621

2007
acCmdCalculatedColumn 698

2010
acCmdCallStack 172 Displays a list of active procedure calls. 列出調(diào) 用的活動(dòng)程序列表 97
acCmdChangeToCheckBox 231 Changes selected control to a check box 更改為復(fù)選框 97
acCmdChangeToComboBox 230 Changes selected control to a combo box 更改為組合框 97
acCmdChangeToCommandButton 501
更改為命令按鈕 2002
acCmdChangeToImage 234 Changes selected control to an image 更改為圖像 97
acCmdChangeToLabel 228 Changes selected control to a label 更改為標(biāo)簽 97
acCmdChangeToListBox 229 Changes selected control to a list box 更改為列表框 97
acCmdChangeToOptionButton 233 Changes selected control to an option button 更改為選項(xiàng) 按鈕 97
acCmdChangeToTextBox 227 Changes selected control to a textbox 更改為文本框 97
acCmdChangeToToggleButton 232 Changes selected control to a toggle button 更改切換按鈕 97
acCmdClearAll 146 Clears all tables from the Relationships window 在關(guān)系窗口中刪除所有的表 97
acCmdClearAllBreakpoints 132 Clears all break points in the database 刪除在數(shù)據(jù)庫中的斷點(diǎn) 97
acCmdClearGrid 71 Clears all information from the QBE grid.
97
acCmdClearHyperlink 343 Clears a hyperlink from a field. 刪除字段的超鏈接 2000
acCmdClearItemDefaults 237 No idea at all. Possibly something to do with defaults in the design of Forms and reports.
97
acCmdClose 58 Closes object which has the focus. 關(guān)閉當(dāng)前對(duì)象 97
acCmdCloseAll 646

2007
acCmdCloseDatabase 538

2007
acCmdCloseWindow 186 Closes the current window 關(guān)閉當(dāng)前窗口 97
acCmdCollectDataViaEmail 608

2007
acCmdColumnWidth 117 Displays the Column Width dialog 顯示列寬 97
acCmdCompactDatabase 4 Compacts a database. 壓縮數(shù)據(jù)庫 97
acCmdCompatCheckCurrentObject 696

2010
acCmdCompatCheckDatabase 695

2010
acCmdCompileAllModules 125 Compiles all modules 編譯所有模塊 97
acCmdCompileAndSaveAllModules 126 Compiles and saves all modules in the database. 編譯并保存數(shù)據(jù)庫的所有模塊 97
acCmdCompileLoadedModules 290 Compiles loaded modules 編譯已加載的模塊 97
acCmdCompleteWord 306 Displays list of objects/methods 顯示對(duì)外/模塊列表 97
acCmdConditionalFormatting 500
條件格式 2002
acCmdConnection 383 Used to create a connection to a server 聯(lián)接到服務(wù)器 2000
acCmdControlMarginsMedium 630

2007
acCmdControlMarginsNarrow 629

2007
acCmdControlMarginsNone 628

2007
acCmdControlMarginsWide 631

2007
acCmdControlPaddingMedium 634

2007
acCmdControlPaddingNarrow 633

2007
acCmdControlPaddingNone 632

2007
acCmdControlPaddingWide 635

2007
acCmdControlWizardsToggle 197 Turns the control wizard on and off 開啟/關(guān)閉控年向?qū)?/span> 97
acCmdConvertDatabase 171 Opens the Convert Database dialog 打開數(shù)據(jù)庫轉(zhuǎn)換對(duì)換框 97
acCmdConvertLinkedTableToLocal 700

2010
acCmdConvertMacrosToVisualBasic 279 Converts macros to code 將宏轉(zhuǎn)換為代碼 97
acCmdCopy 190 Copies the selection to the clipboard. 復(fù)制所選擇的內(nèi)容到剪貼板 97
acCmdCopyDatabaseFile 516
復(fù)制數(shù)據(jù)庫文件 2002
acCmdCopyHyperlink 328 Copies the hyperlink 復(fù)制超鏈接 97
acCmdCreateMenuFromMacro 334 Creates a menu toolbar from a macro 將宏轉(zhuǎn)換為菜單 97
acCmdCreateRelationship 150 Displays the Create Relationship dialog 顯示創(chuàng)建關(guān)系對(duì)話框 97
acCmdCreateReplica 263 Displays the Create Replica dialog???
97
acCmdCreateShortcut 219 Opens the Create Shortcut dialog 打開創(chuàng)建快捷方式對(duì)話框 97
acCmdCreateShortcutMenuFromMacro 336 Creates a shortcut menu from a macro 將宏轉(zhuǎn)化為快捷菜單 97
acCmdCreateToolbarFromMacro 335 Creates a toolbar from a macro 將宏轉(zhuǎn)化為工具條 97
acCmdCut 189 Cuts the selection to the clipboard. 剪切 97
acCmdDatabaseProperties 256 Display the database properties dialog
97
acCmdDatabaseSplitter 520

2002
acCmdDataEntry 78 Changes view to data entry mode 改變視圖為數(shù)據(jù)項(xiàng)模式 97
acCmdDataOutline 468

2002
acCmdDatasheetView 282 Switches to datasheet view 切換數(shù)據(jù)表視圖 97
acCmdDateAndTime 226 Displays the Date and Time dialog 顯示日期和時(shí)間對(duì)話框 97
acCmdDebugWindow 123 Displays the debug window but you have to open a mopdule first 顯示調(diào)式窗口 97
acCmdDelete 337 Deletes selected item 刪除 97
acCmdDeleteGroup 493

2002
acCmdDeletePage 332 Deletes a page from a tab control
97
acCmdDeleteQueryColumn 81 Removes a column fom the QBE grid 刪除查詢列 97
acCmdDeleteRecord 223 Deletes the selected record 刪除選擇的記錄 97
acCmdDeleteRows 188 Deletes rows 刪除行 97
acCmdDeleteSharePointList 627

2007
acCmdDeleteTab 255 Not used to delete a tab from a tab control that is acCmdDeletePage
97
acCmdDeleteTable 489
刪除表 2002
acCmdDeleteTableColumn 271 Deletes the selected column from a table 刪除表中選定列 97
acCmdDeleteWatch 267 Deletes the selected watch variable 刪除監(jiān)視 97
acCmdDesignObject 697

2010
acCmdDesignView 183 Switches to Design View 切換到設(shè)計(jì)窗口 97
acCmdDiagramAddRelatedTables 373

2000
acCmdDiagramAutosizeSelectedTables 378

2000
acCmdDiagramDeleteRelationship 382

2000
acCmdDiagramLayoutDiagram 380

2000
acCmdDiagramLayoutSelection 379

2000
acCmdDiagramModifyUserDefinedView 375

2000
acCmdDiagramNewLabel 372

2000
acCmdDiagramNewTable 381

2000
acCmdDiagramRecalculatePageBreaks 377

2000
acCmdDiagramShowRelationshipLabels 374

2000
acCmdDiagramViewPageBreaks 376

2000
acCmdDiscardChanges 639

2007
acCmdDiscardChangesAndRefresh 640

2007
acCmdDocMaximize 15 Maximizes Access child window 最大化ACCESS子窗體 97
acCmdDocMinimize 60 Minimize internal Access window 最小化ACCESS子窗體 97
acCmdDocMove 16 Move Access child window 移動(dòng)ACCESS子窗體 97
acCmdDocRestore 14 Restores Access child window 恢復(fù)ACCESS子窗體 97
acCmdDocSize 17 Size Access child window 變更ACCESS子窗體大小 97
acCmdDocumenter 285 Displays the Documentor dialog
97
acCmdDropSQLDatabase 517

2002
acCmdDuplicate 34 Create a duplicate of the selected object. 創(chuàng)建所選擇的對(duì)象副本 97
acCmdEditHyperlink 325 Allows the editing of a Hyperlink 允許編輯超鏈接 97
acCmdEditingAllowed 70 I think that this is something to do with the Editing Mode of a form.
97
acCmdEditListItems 607

2007
acCmdEditRelationship 151 Displays the Edit Relationship dialog 顯示關(guān)系編輯窗口 97
acCmdEditTriggers 384

2000
acCmdEditWatch 202 Opens the Edit Watch dialog 打開編輯監(jiān)視窗口 97
acCmdEncryptDecryptDatabase 5 Opens the Encrypt/Decrypt Database dialog. 加密/解密數(shù)據(jù)庫 97
acCmdEnd 198 Stops the running of a procedure 中止程序運(yùn)行 97
acCmdExit 3 Closes Access completely.
97
acCmdExportAccess 559

2007
acCmdExportdBase


2007
acCmdExportExcel 556

2007
acCmdExportFixedFormat 592

2007
acCmdExportHTML 564

2007
acCmdExportODBC 562

2007
acCmdExportRTF 558

2007
acCmdExportSharePointList 557

2007
acCmdExportSnapShot 563

2007
acCmdExportText 560

2007
acCmdExportXML 561

2007
acCmdFavoritesAddTo 299 Displays the Add To Favorites dialog
97
acCmdFavoritesOpen 298 Displays the Open Favorites dialog
97
acCmdFieldList 42 Display/hide the Field List dialog. 顯示/隱藏字段列表窗口 97
acCmdFilterByForm 207 Displays the filter by form dialog 按窗體篩選 97
acCmdFilterBySelection 208 Filters the displayed records by the selected item 按選擇內(nèi)容篩選 97
acCmdFilterExcludingSelection 277 Filters out records that match selection 排除篩選 97
acCmdFilterMenu 619

2007
acCmdFind 30 Opens the Find dialog box. 查找 97
acCmdFindNext 341 Finds next occurrence of previously searched for phrase 查找下一個(gè) 97
acCmdFindNextWordUnderCursor 313 Finds the next occurrence of the word which is under the cursor. Not really Edit Find but an improvement on it.
97
acCmdFindPrevious 120 Find previous occurrence of the last string searched for. Not really Edit Find but an enhancement 查找上一個(gè) 97
acCmdFindPrevWordUnderCursor 312 Finds the previous occurrence of the word which is under the cursor. Equivalent to Ctrl Shift and F3
97
acCmdFitToWindow 245 Fit print preview in window.
97
acCmdFont 19 Display the font selection dialog. 字體 97
acCmdFormatCells 77 Displays the Format Cells dialog. 單元格格式 97
acCmdFormHdrFtr 36 Adds or removes form headers and footers 增加/刪除頁眉頁腳 97
acCmdFormView 281 Switches to form view 切換到窗體視圖 97
acCmdFreezeColumn 105 Keeps the selected column in view 凍結(jié)列 97
acCmdGoBack 294 Returns to the previous Web page
97
acCmdGoContinue 127 Resumes/starts code
97
acCmdGoForward 295 Moves to the next Web page
97
acCmdGroupByTable 387

2000
acCmdGroupControls 484

2002
acCmdHideColumns 79 Hides the selected column(s) 隱藏列 97
acCmdHideMessageBar 677

2010
acCmdHidePane 365

2000
acCmdHideTable 147 Hides a table in the Relationships window 在關(guān)系窗口中隱藏表 97
acCmdHorizontalSpacingDecrease 158 Decreases the horizontal space between selected objects 減少水平間距 97
acCmdHorizontalSpacingIncrease 159 Increases the horizontal space between selected objects 增加水平間距 97
acCmdHorizontalSpacingMakeEqual 157 Makes the horizontal space between selected objects equal 水平間距相同 97
acCmdHyperlinkDisplayText 329 Shows the text that is displayed for a hyperlink
97
acCmdImportAttachAccess 544

2007
acCmdImportAttachdBase 552

2007
acCmdImportAttachExcel 545

2007
acCmdImportAttachHTML 550

2007
acCmdImportAttachODBC 549

2007
acCmdImportAttachOutlook 551

2007
acCmdImportAttachSharePointList 547

2007
acCmdImportAttachText 546

2007
acCmdImportAttachXML 548

2007
acCmdIndent 205 Indents line of code 縮進(jìn)代碼 97
acCmdIndexes 152 Toggles display of the Indexes dialog
97
acCmdInsertActiveXControl 258 Displays the Insert ActiveX Control dialog 顯示插入ACTIVEX控件對(duì)話框 97
acCmdInsertChart 293 Inserts a chart 插入一個(gè)圖表 97
acCmdInsertFile 39 This is not insert file into module which is acCmdInsertFileIntoModule

acCmdInsertFileIntoModule 118 Displays the Insert File dialog 顯示插入文件對(duì)話框 97
acCmdInsertHyperlink 259 Displays the Insert Hyperlink dialog 顯示插入超級(jí)鏈接對(duì)話框 97
acCmdInsertLogo 585

2007
acCmdInsertLookupColumn 273 Displays the LookUp wizard 顯示查找向?qū)?/span> 97
acCmdInsertLookupField 291 Starts the Lookup Wizard 啟動(dòng)查找向?qū)?/span> 97
acCmdInsertMovieFromFile 469

2002
acCmdInsertNavigationButton 724

2010
acCmdInsertObject 33 Opens the Insert Object Dialog 打開插入對(duì)象對(duì)話框 97
acCmdInsertPage 331 Inserts a new page to a tab control
97
acCmdInsertPicture 222 Displays the Insert Picture dialog 顯示插入圖片對(duì)話框 97
acCmdInsertPivotTable 470

2002
acCmdInsertProcedure 262 Displays the Insert Procedure dialog 顯示插入程序?qū)υ捒?/span> 97
acCmdInsertQueryColumn 82 Insets a column into the QBE grid. 在查詢?cè)O(shè)計(jì)視圖中插入列 97
acCmdInsertRows 187 Inserts rows 插入行 97
acCmdInsertSpreadsheet 471

2002
acCmdInsertSubdatasheet 499

2002
acCmdInsertTableColumn 272 Inserts column into a table
97
acCmdInsertTitle 586

2007
acCmdInsertUnboundSection 472

2002
acCmdInvokeBuilder 178 Open the Buiilder dialog
97
acCmdJoinProperties 72 Displays the Join Properties dialog. 顯示連接屬性對(duì)話框 97
acCmdLastPosition 339 Returns cursor to last position in the module window
97
acCmdLayoutGridlinesBoth 574

2007
acCmdLayoutGridlinesBottom 580

2007
acCmdLayoutGridlinesCrossHatch 578

2007
acCmdLayoutGridlinesHorizontal 576

2007
acCmdLayoutGridlinesNone 577

2007
acCmdLayoutGridlinesOutline 581

2007
acCmdLayoutGridlinesTop 579

2007
acCmdLayoutGridlinesVertical 575

2007
acCmdLayoutInsertColumnLeft 680

2010
acCmdLayoutInsertColumnRight 681

2010
acCmdLayoutInsertRowAbove 678

2010
acCmdLayoutInsertRowBelow 679

2010
acCmdLayoutMergeCells 682

2010
acCmdLayoutPreview 141 Print Preview with sample data
97
acCmdLayoutSplitColumnCell 683

2010
acCmdLayoutSplitRowCell 684

2010
acCmdLayoutView 593

2007
acCmdLineUpIcons 213 Line up icons in columns 在列中排列圖標(biāo) 97
acCmdLinkedTableManager 519
打開鏈接表管理器 2002
acCmdLinkTables 102 Displays the Link tables dialog 顯示鏈接表窗口 97
acCmdListConstants 303 Display drop down in code window of available constants 常數(shù)列表 97
acCmdLoadFromQuery 95 Opens the Applicable Query dialog
97
acCmdMacroAllActions 589

2007
acCmdMakeMDEFile 7 Creates a MDE File but does not appear to be able to be used for the active Database.
97
acCmdManageAttachments 673

2007
acCmdManageReplies 609

2007
acCmdManageTableEvents 717

2010
acCmdMaximiumRecords 508

2002
acCmdMicrosoftAccessHelpTopics 100 Displays the Help contents 顯示ACCESS幫助目錄 97
acCmdMicrosoftOnTheWeb 236 Displays the Microsoft On the Web Menu???
97
acCmdModifySharePointList 622

2007
acCmdModifySharePointListAlerts 623

2007
acCmdModifySharePointListPermissions 625

2007
acCmdModifySharePointListWorkflow 624

2007
acCmdMoreWindows 8 Displays the Window List dialog box. 在對(duì)話框中顯示窗體列表 97
acCmdMoveColumnCellDown 573

2007
acCmdMoveColumnCellUp 572

2007
acCmdNewDatabase 26 Opens the new database dialog 新建數(shù)據(jù)庫
acCmdNewGroup 491
新建工作組 2002
acCmdNewObjectAutoForm 193 Creates a new form if a table/query has been selected in database window 快速表單 97
acCmdNewObjectAutoFormWeb 705

2010
acCmdNewObjectAutoReport 194 Creates a new report if a table/query has been selected in database window 快速報(bào)表 97
acCmdNewObjectAutoReportWeb 706

2010
acCmdNewObjectBlankForm 600

2007
acCmdNewObjectBlankFormWeb 703

2010

分享
文章分類
聯(lián)系我們
聯(lián)系人： 王先生
Email： 18449932@qq.com
QQ： 18449932
微博： officecn01
移動(dòng)訪問