office交流网--QQ交流群号

Access培训群:792054000         Excel免费交流群群:686050929          Outlook交流群:221378704    

Word交流群:218156588             PPT交流群:324131555

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

2019-03-08 10:22:00
tmtony8
原创
29815

VBA中,可以使用RunCommand 方法来运行内置的命令。

Access 中的每个菜单命令和工具栏命令都有一个相关的常量,可以将常量与 RunCommand 方法结合使用来执行该常量对应的命令。



列举部分参数说明,完整参数说明请下载附件查看

部分有链接的参数都有示例说明使用方法和作用

参数 英文说明 中文说明 版本
acCmdAboutMicrosoftAccess 35 Displays the About Access Information dialog 显示关于ACCESS的信息对话框 97
acCmdAddDataMacroAfterDelete 720

2010
acCmdAddDataMacroAfterInsert 718

2010
acCmdAddDataMacroAfterUpdate 719

2010
acCmdAddDataMacroValidateChange 722

2010
acCmdAddDataMacroValidateDelete 721

2010
acCmdAddFromOutlook 583

2007
acCmdAddInManager 526
打开COM加载项管理器 2002
acCmdAddNamedDataMacro 723

2010
acCmdAddToNewGroup 494

2002
acCmdAddWatch 201 Adds a variable to the Watch Window 添加一个变量到监视窗口 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. 如果没有重叠,就将你选择的控件向下对齐,否则对齐上下边(不知如何用词,自己试试就知道了 97
acCmdAlignCenter 477
居中对齐 2002
acCmdAlignLeft 43 Aligns the left edges of a selection of controls if no overlap else abuts left edge to right edge. 如果没有重叠,就将你选择的控件向左对齐 否则邻接左右边界 97
acCmdAlignmentAndSizing 478

2002
acCmdAlignMiddle 476
垂直居中对齐 2002
acCmdAlignRight 44 Aligns the right edges of a selection of controls if no overlap else abuts left edge to right edge. 如果没有重叠,就将你选择的控件向右对齐 否则邻接左右边界 97
acCmdAlignToGrid 47 Aligns selection to grid. 将你选择的控件对齐网格 97
acCmdAlignTop 45 Aligns the top edges of a selection of controls if no overlap else abuts top edge to bottom edge. 如果没有重叠,就将你选择的控件向上对齐 否则邻接上下边界 97
acCmdAlignToShortest 153 Sizes selected controls to shortest 将选择的控件大小改变至最短 97
acCmdAlignToTallest 154 Sizes selected controls to tallest 将选择的控件大小改变至最高 97
acCmdAnalyzePerformance 283 Displays the Analyze Performance dialog 显示性能分析向导窗口 97
acCmdAnalyzeTable 284 Displays the Table Analyzer Wizard 显示表分析向导 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 显示查找帮助窗口 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. 应用缺省的格式给选择的控件 97
acCmdApplyFilterSort 93 Apply's the filter entered in a Filter Design window. 应用你在过滤设计窗体输入的过滤条件 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. 将光标设成4个箭头形状且同时可移动ACCESS窗口 97
acCmdAppRestore 9 Restores Access window. 还原ACCESS窗体 97
acCmdAppSize 13 Size Access window 改变ACCESS窗体大小 97
acCmdArrangeIconsAuto 218 Auto arrange icons 自动排列图标 97
acCmdArrangeIconsByCreated 216 Arrange the icons in date created order 按创建日期顺序排列图标 97
acCmdArrangeIconsByModified 217 Arrange the icons in date modified order 按修改日期顺序排列图标 97
acCmdArrangeIconsByName 214 Arrange icons in database window in alphabetical order 在数据窗体按阿拉伯字母顺序排列图标 97
acCmdArrangeIconsByType 215 Arranges icons by the type of object 按对象类型排列图标 97
acCmdAutoCorrect 261 Displays the AutoCorrect dialog 显示自动纠正窗口 97
acCmdAutoDial 192 Automatically phones a selected number 自动拔选择的电话号码 97
acCmdAutoFormat 270 Displays the AutoFormat dialog 显示自动格式对话框 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. 列出调 用的活动程序列表 97
acCmdChangeToCheckBox 231 Changes selected control to a check box 更改为复选框 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 更改为标签 97
acCmdChangeToListBox 229 Changes selected control to a list box 更改为列表框 97
acCmdChangeToOptionButton 233 Changes selected control to an option button 更改为选项 按钮 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 在关系窗口中删除所有的表 97
acCmdClearAllBreakpoints 132 Clears all break points in the database 删除在数据库中的断点 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. 关闭当前对象 97
acCmdCloseAll 646

2007
acCmdCloseDatabase 538

2007
acCmdCloseWindow 186 Closes the current window 关闭当前窗口 97
acCmdCollectDataViaEmail 608

2007
acCmdColumnWidth 117 Displays the Column Width dialog 显示列宽 97
acCmdCompactDatabase 4 Compacts a database. 压缩数据库 97
acCmdCompatCheckCurrentObject 696

2010
acCmdCompatCheckDatabase 695

2010
acCmdCompileAllModules 125 Compiles all modules 编译所有模块 97
acCmdCompileAndSaveAllModules 126 Compiles and saves all modules in the database. 编译并保存数据库的所有模块 97
acCmdCompileLoadedModules 290 Compiles loaded modules 编译已加载的模块 97
acCmdCompleteWord 306 Displays list of objects/methods 显示对外/模块列表 97
acCmdConditionalFormatting 500
条件格式 2002
acCmdConnection 383 Used to create a connection to a server 联接到服务器 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 开启/关闭控年向导 97
acCmdConvertDatabase 171 Opens the Convert Database dialog 打开数据库转换对换框 97
acCmdConvertLinkedTableToLocal 700

2010
acCmdConvertMacrosToVisualBasic 279 Converts macros to code 将宏转换为代码 97
acCmdCopy 190 Copies the selection to the clipboard. 复制所选择的内容到剪贴板 97
acCmdCopyDatabaseFile 516
复制数据库文件 2002
acCmdCopyHyperlink 328 Copies the hyperlink 复制超链接 97
acCmdCreateMenuFromMacro 334 Creates a menu toolbar from a macro 将宏转换为菜单 97
acCmdCreateRelationship 150 Displays the Create Relationship dialog 显示创建关系对话框 97
acCmdCreateReplica 263 Displays the Create Replica dialog???
97
acCmdCreateShortcut 219 Opens the Create Shortcut dialog 打开创建快捷方式对话框 97
acCmdCreateShortcutMenuFromMacro 336 Creates a shortcut menu from a macro 将宏转化为快捷菜单 97
acCmdCreateToolbarFromMacro 335 Creates a toolbar from a macro 将宏转化为工具条 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 改变视图为数据项模式 97
acCmdDataOutline 468

2002
acCmdDatasheetView 282 Switches to datasheet view 切换数据表视图 97
acCmdDateAndTime 226 Displays the Date and Time dialog 显示日期和时间对话框 97
acCmdDebugWindow 123 Displays the debug window but you have to open a mopdule first 显示调式窗口 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 删除监视 97
acCmdDesignObject 697

2010
acCmdDesignView 183 Switches to Design View 切换到设计窗口 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 移动ACCESS子窗体 97
acCmdDocRestore 14 Restores Access child window 恢复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. 创建所选择的对象副本 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 显示关系编辑窗口 97
acCmdEditTriggers 384

2000
acCmdEditWatch 202 Opens the Edit Watch dialog 打开编辑监视窗口 97
acCmdEncryptDecryptDatabase 5 Opens the Encrypt/Decrypt Database dialog. 加密/解密数据库 97
acCmdEnd 198 Stops the running of a procedure 中止程序运行 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 按选择内容筛选 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 查找下一个 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 查找上一个 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 冻结列 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 在关系窗口中隐藏表 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 缩进代码 97
acCmdIndexes 152 Toggles display of the Indexes dialog
97
acCmdInsertActiveXControl 258 Displays the Insert ActiveX Control dialog 显示插入ACTIVEX控件对话框 97
acCmdInsertChart 293 Inserts a chart 插入一个图表 97
acCmdInsertFile 39 This is not insert file into module which is acCmdInsertFileIntoModule

acCmdInsertFileIntoModule 118 Displays the Insert File dialog 显示插入文件对话框 97
acCmdInsertHyperlink 259 Displays the Insert Hyperlink dialog 显示插入超级链接对话框 97
acCmdInsertLogo 585

2007
acCmdInsertLookupColumn 273 Displays the LookUp wizard 显示查找向导 97
acCmdInsertLookupField 291 Starts the Lookup Wizard 启动查找向导 97
acCmdInsertMovieFromFile 469

2002
acCmdInsertNavigationButton 724

2010
acCmdInsertObject 33 Opens the Insert Object Dialog 打开插入对象对话框 97
acCmdInsertPage 331 Inserts a new page to a tab control
97
acCmdInsertPicture 222 Displays the Insert Picture dialog 显示插入图片对话框 97
acCmdInsertPivotTable 470

2002
acCmdInsertProcedure 262 Displays the Insert Procedure dialog 显示插入程序对话框 97
acCmdInsertQueryColumn 82 Insets a column into the QBE grid. 在查询设计视图中插入列 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. 显示连接属性对话框 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 在列中排列图标 97
acCmdLinkedTableManager 519
打开链接表管理器 2002
acCmdLinkTables 102 Displays the Link tables dialog 显示链接表窗口 97
acCmdListConstants 303 Display drop down in code window of available constants 常数列表 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. 在对话框中显示窗体列表 97
acCmdMoveColumnCellDown 573

2007
acCmdMoveColumnCellUp 572

2007
acCmdNewDatabase 26 Opens the new database dialog 新建数据库
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 快速报表 97
acCmdNewObjectAutoReportWeb 706

2010
acCmdNewObjectBlankForm 600

2007
acCmdNewObjectBlankFormWeb 703

2010

分享