<strong id="yd969"><track id="yd969"></track></strong>

<li id="yd969"></li>

<rp id="yd969"><object id="yd969"></object></rp>

office交流網--QQ交流群號

Access培訓群：792054000 Excel免費交流群群：686050929 Outlook交流群：221378704

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

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

2019-03-08 10:22:00

tmtony8

原創

28288

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

RunCommand.rar 2177MD5

分享

Access數據庫自身

Access數據表技巧

Access查詢技巧

Access窗體控件

Access報表圖表

Access VBA函數模塊

Access Dao/Ado/鏈接表

Access Activex第三方控件

Activex控件或Dll 在某些電腦無法正常注冊的解決辦法(regsvr32注冊時卡?。?/a>

Access ADP Sql Server等

Access 行業應用開發

文章分類

聯系我們

聯系人：	王先生
Email：	18449932@qq.com
QQ：	18449932
微博：	officecn01