技巧

热门文章

最新文章

联系方式

Access交流网

电  话：0760-88315075
热  线：0760-88315075

邮  编：528463
咨询QQ：1918333016
营销QQ：4008553990

Email：1918333016@qq.com

网  址：www.access-cn.com

当前位置：首页 > 技巧 > ACCESS数据库
ACCESS数据库

ACCESS数据库RunCommand方法参数列表说明说明

Access的Docmd.RunCommand 对于不太会VBA的朋友来讲，非常方便，但它的帮助不太详细，且大多是英文，下面就列出它的中文说明


参数中文对照说明版本
acCmdDocMinimize最小化ACCESS子窗体Minimize internal Access window97
acCmdAppMinimize最小化ACCESS窗体Minimize Access window97
acCmdDocMaximize最大化ACCESS子窗体Maximizes  Access child window97
acCmdQueryTotals总计查询Toggles the Totals Line in a QBE grid97
acCmdAutoDial自动拔选择的电话号码Automatically phones a selected number97
acCmdFont字体Display the font selection dialog.97
acCmdSubdatasheetExpandAll子数据表全部展开
2002
acCmdSubdatasheetCollapseAll子数据表全部收缩
2002
acCmdQueryTypeAppend追加查询Changes a Query to an Append Query97
acCmdRegisterActiveXControls注册ACTIVEX控件Opens the ActiveX Controls dialog97
acCmdProperties属性Toggles the Properties window97
acCmdReferences引用参照Displays the References dialog.97
acCmdRenameColumn重命名列Highlights column heading to enable renaming97
acCmdRename重命名Allows editting of selected object name in the database window97
acCmdStopLoadingPage中止一个网页的加载Halts the loading of a Web page97
acCmdEnd中止程序运行Stops the running of a procedure97
acCmdBringToFront至于最前Brings selection to the front of all other objects.97
acCmdStepToCursor执行到光标处Runs through the code to the line containing the cursor97
acCmdPasteAppend粘贴为新记录Pastes a copied record as a new record97
acCmdPasteAsHyperlink粘贴为超级链接
2002
acCmdPaste粘贴Pastes from ther clipboard97
acCmdVerticalSpacingIncrease增加选择对象的间距Increases the vertical space between selected objects97
acCmdHorizontalSpacingIncrease增加水平间距Increases the horizontal space between selected objects97
acCmdBookmarksToggle增加/删除一条书签Adds/removes a bookmark97
acCmdFormHdrFtr增加/删除页眉页脚Adds or removes form headers and footers97
acCmdReportHdrFtr增加/删除报表页眉页脚Adds or removes report headers and footers97
acCmdOpenNewHyperlink在新窗口中打开超级链接联接的项目Opens the item associated with the hyperlink in a new window97
acCmdViewModules在数据库窗口中显示模块Displays the Module tab in Database Window97
acCmdViewMacros在数据库窗口中显示宏Displays the Macro tab in Database Window97
acCmdViewQueries在数据库窗口中显示查询Displays the Query tab in Database Window97
acCmdViewReports在数据库窗口中显示报表Displays the Report tab in Database Window97
acCmdViewList在数据窗体按列表方式显示项目Displays items in a list in the database window97
acCmdViewLargeIcons在数据窗体按大图标方式显示项目Displays large icons in database window97
acCmdArrangeIconsByName在数据窗体按阿拉伯字母顺序排列图标Arrange icons in database window in alphabetical order97
acCmdSelectDataAccessPage在设计状态下选择整个数据页Selects the whole data access page when in design mode2000
acCmdSelectForm在设计状态下选择整个窗体Selects the whole form when in design mode97
acCmdNewObjectDiagram在设计窗口中打开一个新的图表Opens a new Diagram in design mode.2000
acCmdSaveModuleAsText在模块窗体时打开文件另存对话框Opens the File Save As box when in a module97
acCmdLineUpIcons在列中排列图标Line up icons in columns97
acCmdHideTable在关系窗口中隐藏表Hides a table in the Relationships window97
acCmdClearAll在关系窗口中删除所有的表Clears all tables from the Relationships window97
acCmdMoreWindows在对话框中显示窗体列表Displays the Window List dialog box.97
acCmdPreviewOnePage在打印预览中显示为一页Display one page in print preview97
acCmdPreviewFourPages在打印预览中显示为四页Display four pages in print preview97
acCmdPreviewTwelvePages在打印预览中显示为十二页Display twelve pages in print preview97
acCmdPreviewTwoPages在打印预览中显示为两页Display two pages in print preview97
acCmdPreviewEightPages在打印预览中显示为八页Display eight pages in print preview97
acCmdViewShowPaneGrid在查询设计视图中切换网格面板的显示Toggles the display of the Grid Pane when in the design of a View2000
acCmdViewShowPaneDiagram在查询设计视图中切换关系面板的显示Toggles the display of the Diagram Pane when in the design of a View2000
acCmdViewShowPaneSQL在查询设计视图中切换SQL面板的显示Toggles the display of the SQL Pane when in the design of a View2000
acCmdInsertQueryColumn在查询设计视图中插入列Insets a column into the QBE grid.97
acCmdViewVerifySQL在查询设计时校验SQL语法Verifies the SQL in the design of a View2000
acCmdTableNames在查询设计器中切换是否显示表名Toggles display of the Table Names Line in a QBE grid97
acCmdQueryGroupBy在查询设计器中切换分组的显示与否Adds and hides the Group By column in the design of a View.2000
acCmdSpelling运行拼写检查器Runs the Spell Checker.97
acCmdRunOpenMacro运行宏Run a macro97
acCmdRun运行查询Runs a query97
acCmdEditHyperlink允许编辑超链接Allows the editing of a Hyperlink97
acCmdApplyFilterSort应用你在过滤设计窗体输入的过滤条件Apply's the filter entered in a Filter Design window.97
acCmdHideColumns隐藏列Hides the selected column(s)97
acCmdWindowHide隐藏获得焦点的窗体Hides the window that has the focus.97
acCmdSend以缺省的邮件系统发送选择的对象Opens the default mail system to send selected object97
acCmdBookmarksNext移至下一条书签Moves to the next bookmark97
acCmdBookmarksPrevious移至上一条书签Moves to the previous bookmark97
acCmdRemoveTable移去表Removes the selected table from the QBE grid97
acCmdDocMove移动ACCESS子窗体Move Access child window97
acCmdRecordsGoToLast移到最后一条记录Moves to the last record.97
acCmdRecordsGoToNext移到下一条记录Moves to the next record.97
acCmdRecordsGoToPrevious移到上一条记录Moves to the previous record.97
acCmdRecordsGoToFirst移到第一条记录Moves to the first record.97
acCmdSubdatasheetRemove移除子数据表
2002
acCmdTransparentBackground移除窗体的背景Removes the background of a control. Equivalent to selecting the Font/Fore Color icon from the toolbar and then Transparent.97
acCmdCompactDatabase压缩数据库Compacts a database.97
acCmdSelectReport选择整个报表Selects the whole report when in design mode97
acCmdSelectAllRecords选择所有记录Selects all the records97
acCmdSelectRecord选择当前记录Selects the whole of the current record.97
acCmdSelectAll选择窗口中的所有内容Selects all the contents of the window97
acCmdQueryTypeSelect选择查询Changes a Query to a Select Query97
acCmdRepairDatabase修复数据库Opens the Repair Database file selection dialog box. Note this cannot be used to repair the current database.97
acCmdRowHeight行高Displays the Row Height dialog97
acCmdRecordsGoToNew新增一条记录Moves to a new record97
acCmdNewObjectDataAccessPage新建数据页Opens the new Data Access Page dialog2000
acCmdNewDatabase新建数据库Opens the new database dialog
acCmdNewObjectView新建视图Opens a new view in design mode2000
acCmdNewObjectClassModule新建模块Creates a new Class Module97
acCmdNewObjectModule新建模块Creates a new Module.97
acCmdNewObjectFunction新建函数
2002
acCmdNewGroup新建工作组
2002
acCmdNewObjectForm新建窗体Displays the New Form dialog97
acCmdNewObjectQuery新建查询Displays the New Query dialog97
acCmdNewObjectTable新建表Displays the New Table dialog97
acCmdNewObjectReport新建报表Displays the New Report dialog97
acCmdVerticalSpacingMakeEqual相同选择对象的间距Makes the vertical space between selected objects equal97
acCmdAutoCorrect显示自动纠正窗口Displays the AutoCorrect dialog97
acCmdAutoFormat显示自动格式对话框Displays the AutoFormat dialog97
acCmdToolbarsCustomize显示自定义工具栏对话框Displays the Customise Toolbars dialog97
acCmdShowTable显示增加表窗口Displays the Add Table dialog97
acCmdUserLevelSecurityWizard显示用户级安全向导对话框Displays the User Level Security Wizard dialog97
acCmdUserAndGroupAccounts显示用户和组帐号对话框Displays the Security User and Group Accounts dialog box.97
acCmdUserAndGroupPermissions显示用户和组权限对话框Displays the User and Groups Permissions dialog97
acCmdAnalyzePerformance显示性能分析向导窗口Displays the Analyze Performance dialog97
acCmdShowAllRelationships显示所有的关系Displays all Relationships in the Relationships window97
acCmdShowDirectRelationships显示所选择的表的关系Displays all connected Relationships from selected table97
acCmdViewDataAccessPages显示数据窗体里的数据页选卡Displays the Pages tab in the Database Window2000
acCmdViewDiagrams显示数据窗体里的关系选卡Displays the Diagrams tab of the database window2000
acCmdViewStoredProcedures显示数据窗体里的存储过程选卡Displays the Stored Procedures tab of the database window2000
acCmdViewForms显示数据窗体里的窗体选卡Displays the Form tab in Database Window97
acCmdViewViews显示数据窗体里的查询选卡Displays the Views tab of the database window2000
acCmdViewTables显示数据窗体里的表选卡Displays the Table tab in Database Window97
acCmdDateAndTime显示日期和时间对话框Displays the Date and Time dialog97
acCmdUnhideColumns显示取消隐藏栏位的对话框Displays the Unhide Columns Dialog97
acCmdWindowUnhide显示取消隐藏的对话框，如果没有窗体隐藏过，则出错Displays the Window Unhide dialog box if any Windows have been hidden. Otherwise produces an error.97
acCmdColumnWidth显示列宽Displays the Column Width dialog97
acCmdLinkTables显示链接表窗口Displays the Link tables dialog97
acCmdJoinProperties显示连接属性对话框Displays the Join Properties dialog.97
acCmdSortingAndGrouping显示或隐藏排序和分组对话框Displays/hides the sorting and grouping dialog.97
acCmdViewFieldList显示或隐藏查询中的字段列表Displays and hides the Field List in a View2000
acCmdAboutMicrosoftAccess显示关于ACCESS的信息对话框Displays the About Access Information dialog97
acCmdEditRelationship显示关系编辑窗口Displays the Edit Relationship dialog97
acCmdWorkgroupAdministrator显示工作组管理员对话框
2002
acCmdCompleteWord显示对外/模块列表Displays list of objects/methods97
acCmdDebugWindow显示调式窗口Displays the debug window but you have to open a mopdule first97
acCmdCreateRelationship显示创建关系对话框Displays the Create Relationship dialog97
acCmdInsertLookupColumn显示查找向导Displays the LookUp wizard97
acCmdInsertFileIntoModule显示插入文件对话框Displays the Insert File dialog97
acCmdInsertPicture显示插入图片对话框Displays the Insert Picture dialog97
acCmdInsertProcedure显示插入程序对话框Displays the Insert Procedure dialog97
acCmdInsertHyperlink显示插入超级链接对话框Displays the Insert Hyperlink dialog97
acCmdInsertActiveXControl显示插入ACTIVEX控件对话框Displays the Insert ActiveX Control dialog97
acCmdWordMailMerge显示WORD邮件对话框Opens the Mail Merge dialog box97
acCmdTabControlPageOrder显示TAB控件页顺序对话框Displays the Page Order dialog97
acCmdTabOrder显示TAB次序对话框Displays the Tab Order dialog.97
acCmdMicrosoftAccessHelpTopics显示ACCESS帮助目录Displays the Help contents97
acCmdFieldList显示/隐藏字段列表窗口Display/hide the Field List dialog.97
acCmdViewToolbox停靠工具箱Toggles the display of the Toolbox97
acCmdConditionalFormatting条件格式
2002
acCmdTableAddTable添加表
2002
acCmdReplace替换Opens the Replace dialog97
acCmdIndent缩进代码Indents line of code97
acCmdTileHorizontally水平平铺ACCESS子窗体Tiles the Access child windows horizontally97
acCmdHorizontalSpacingMakeEqual水平间距相同Makes the horizontal space between selected objects equal97
acCmdRefresh刷新Refeshes the data in the active window.97
acCmdQueryTypeSQLDataDefinition数据定义查询Changes the Query to a Data Definiton Query97
acCmdQueryTypeMakeTable生成表查询Changes a Query to a Make Table Query97
acCmdToggleFilter设置一个过滤的开关Toggles a filter on/off97
acCmdToggleBreakpoint设置一个断点的开关Turns a break point on/off97
acCmdTransparentBorder设置透明边Removes the colour from a border. Equivalent to selecting the Line/Border Color icon from the toolbar and then Transparent.97
acCmdSetDatabasePassword设置数据库密码Displays the Set Database Password dialog97
acCmdSetNextStatement设置代码下一行将被执行Sets the next line of code to be run97
acCmdPrimaryKey设置/取消字段主键Sets/removes the Primary key on the selected field(s).97
acCmdClearHyperlink删除字段的超链接Clears a hyperlink from a field.2000
acCmdClearAllBreakpoints删除在数据库中的断点Clears all break points in the database97
acCmdDeleteRecord删除选择的记录Deletes the selected record97
acCmdDeleteRows删除行Deletes rows97
acCmdBookmarksClearAll删除所的有书签Clears all bookmarks97
acCmdDeleteWatch删除监视Deletes the selected watch variable97
acCmdDeleteQueryColumn删除查询列Removes a column fom the QBE grid97
acCmdQueryTypeDelete删除查询Changes a Query to a Delete Query97
acCmdDeleteTableColumn删除表中选定列Deletes the selected column from a table97
acCmdDeleteTable删除表
2002
acCmdDelete删除Deletes selected item97
acCmdAlignLeft如果没有重叠，就将你选择的控件向左对齐 否则邻接左右边界Aligns the left edges of a selection of controls if no overlap else abuts left edge to right edge.97
acCmdAlignRight如果没有重叠，就将你选择的控件向右对齐 否则邻接左右边界Aligns the right edges of a selection of controls if no overlap else abuts left edge to right edge.97
acCmdAlignBottom如果没有重叠，就将你选择的控件向下对齐，否则对齐上下边（不知如何用词，自己试试就知道了Aligns the bottom edges of a selection of controls if no overlap. Else aligns top to bottom.97
acCmdAlignTop如果没有重叠，就将你选择的控件向上对齐 否则邻接上下边界Aligns the top edges of a selection of controls if no overlap else abuts top edge to bottom edge.97
acCmdObjBrwFindWholeWordOnly全字匹配Toggles the Find Whole Word Only option97
acCmdSubformDatasheet切换子窗体数据表的显示Toggles display of a subform to/from datasheet view97
acCmdViewGrid切换网格的显示Toggles display of the Grid.97
acCmdDatasheetView切换数据表视图Switches to datasheet view97
acCmdSwitchboardManager切换面板管理器
2002
acCmdSnapToGrid切换对齐网格的选项Toggles the Snap To Grid option.97
acCmdDesignView切换到设计窗口Switches to Design View97
acCmdFormView切换到窗体视图Switches to form view97
acCmdViewRuler切换标尽的显示Toggles the display of the ruler.97
acCmdInsertLookupField启动查找向导Starts the Lookup Wizard97
acCmdFilterExcludingSelection排除筛选Filters out records that match selection97
acCmdWindowSplit模块窗体拆分Toggles the window split in a module97
acCmdSaveAsDataAccessPage另存为数据页
2000
acCmdSaveAsQuery另存为查询Saves a filter as a query97
acCmdSaveAsReport另存为报表Displays the Save a Form as a Report dialog97
acCmdSaveAsIDC另存为IDCSame as selecting IDC in the File Save As dialog box97
acCmdSaveAsHTML另存为HTML格式Same as selecting HTML in the File Save As dialog box. Not Save Ass HTML on File menu which starts Web Wizard. That is acCmdPublish97
acCmdSaveAsASP另存为ASPSame as selecting ASP in the File Save As dialog box97
acCmdSaveAs另存为Displays the Save As/Export selection dialog97
acCmdCallStack列出调 用的活动程序列表Displays a list of active procedure calls.97
acCmdConnection联接到服务器Used to create a connection to a server2000
acCmdQueryTypeSQLUnion联合查询Changes the Query to a Union Query97
acCmdQuickWatch快速监视Displays the Quick Watch dialog97
acCmdNewObjectAutoForm快速表单Creates a new form if a table/query has been selected in database window97
acCmdNewObjectAutoReport快速报表Creates a new report if a table/query has been selected in database window97
acCmdControlWizardsToggle开启/关闭控年向导Turns the control wizard on and off97
acCmdAlignCenter居中对齐
2002
acCmdResolveConflicts解决冲突对话框Displays the Resolve Conflicts dialog97
acCmdUnfreezeAllColumns解冻所有冻结的栏位Unfreezes all frozen columns97
acCmdQueryTypeCrosstab交叉表查询Changes a Query to a Crosstab97
acCmdSizeToNarrowest将选择对象的大小改为最小的尺寸Sizes selected controls to narrowest97
acCmdSizeToWidest将选择的对象最宽Sizes selected controls to widest97
acCmdSendToBack将选择的对象放在所有对象后面Takes selection behind all other objects.97
acCmdConvertMacrosToVisualBasic将宏转换为代码Converts macros to code97
acCmdCreateMenuFromMacro将宏转换为菜单Creates a menu toolbar from a macro97
acCmdCreateShortcutMenuFromMacro将宏转化为快捷菜单Creates a shortcut menu from a macro97
acCmdCreateToolbarFromMacro将宏转化为工具条Creates a toolbar from a macro97
acCmdAppMove将光标设成4个箭头形状且同时可移动ACCESS窗口Changes mouse into 4 headed arrow to enable the Access window to be moved.97
acCmdCut剪切Cuts the selection to the clipboard.97
acCmdVerticalSpacingDecrease减少选择对象的间距Decreases the vertical space between selected objects97
acCmdHorizontalSpacingDecrease减少水平间距Decreases the horizontal space between selected objects97
acCmdEncryptDecryptDatabase加密/解密数据库Opens the Encrypt/Decrypt Database dialog.97
acCmdDocRestore恢复ACCESS子窗体Restores Access child window97
acCmdRestore恢复
2002
acCmdClose关闭当前对象Closes object which has the focus.97
acCmdCloseWindow关闭当前窗口Closes the current window97
acCmdShowOnlyWebToolbar关闭除WEB工具栏外的所有工具栏Closes all toolbars but the Web toolbar97
acCmdQueryTypeUpdate更新查询Changes a Query to an Update Query97
acCmdChangeToComboBox更改为组合框Changes selected control to a combo box97
acCmdChangeToOptionButton更改为选项 按钮Changes selected control to an option button97
acCmdChangeToTextBox更改为文本框Changes selected control to a textbox97
acCmdChangeToImage更改为图像Changes selected control to an image97
acCmdChangeToCommandButton更改为命令按钮
2002
acCmdChangeToListBox更改为列表框Changes selected control to a list box97
acCmdChangeToCheckBox更改为复选框Changes selected control to a check box97
acCmdChangeToLabel更改为标签Changes selected control to a label97
acCmdChangeToToggleButton更改切换按钮Changes selected control to a toggle button97
acCmdStepOut跟踪执行到调用代码下一行Runs code to next statement in calling procedure97
acCmdStepInto跟踪执行到代码下一行Steps into the next line of code97
acCmdDataEntry改变视图为数据项模式Changes view to data entry mode97
acCmdSizeToFit改变控件的大小到最适状态Changes size of control to best fit.97
acCmdSetControlDefaults改变据选择的控件的默认值Change the defaults for the selected control.97
acCmdSizeToFitForm改变窗体的大小到它的设计状态时的大小Changes the size of the Form Window to it's design size.97
acCmdCopy复制所选择的内容到剪贴板Copies the selection to the clipboard.97
acCmdCopyDatabaseFile复制数据库文件
2002
acCmdCopyHyperlink复制超链接Copies the hyperlink97
acCmdServerProperties服务器属性
2002
acCmdUngroupControls分开成组的控件
2002
acCmdShowNextStatement返回屏幕到下一个将要执行的代码处Returns the screen back to the next line of code to run97
acCmdSizeToGrid对齐网格边界Snaps edges of selection to grid size.97
acCmdFreezeColumn冻结列Keeps the selected column in view97
acCmdImport导入Displays the File
acCmdOutputToText导出为TXT格式Saves selected module as a text file with no prompt for file name or location. Saves in current directory.97
acCmdOutputToRTF导出为RTF格式Out puts selected object in RTF format97
acCmdOutputToExcel导出为EXCEL格式Exports the selected object to Excel97
acCmdExport导出
2002
acCmdFormatCells单元格格式Displays the Format Cells dialog.97
acCmdSingleStep单步运行宏Single steps through a macro97
acCmdPrintPreview打印预览Opens the print preview window.97
acCmdPrintRelationships打印关系
2002
acCmdPrint打印Opens the Print dialog box.97
acCmdRunMacro打开运行宏窗口Opens the Run Macro dialog97
acCmdSpeech打开语音识别，如果没有出提示没有此项功能
2002
acCmdPageSetup打开页面调整对话框Opens the Page Setup dialog97
acCmdViewCode打开选择对象的代码窗口Opens the Code window for the selected object.97
acCmdNewObjectMacro打开新建宏窗口Opens a New Macro Window97
acCmdWebPageProperties打开网页属性表
2002
acCmdWebPagePreview打开网页预览
2002
acCmdConvertDatabase打开数据库转换对换框Opens the Convert Database dialog97
acCmdOpenDatabase打开数据库Displays the open database dialog. Does not appear to work from code.97
acCmdStartupProperties打开启动属性对话框Opens the Startup Properties dialog97
acCmdLinkedTableManager打开链接表管理器 
2002
acCmdRelationships打开关系窗品Opens the Relatiosnhips window.97
acCmdCreateShortcut打开创建快捷方式对话框Opens the Create Shortcut dialog97
acCmdOpenHyperlink打开超级链接联接的项目Opens the item associated with the hyperlink97
acCmdQueryParameters打开查询参数对话框Displays the Parameters dialog97
acCmdInsertObject打开插入对象对话框Opens the Insert Object Dialog97
acCmdEditWatch打开编辑监视窗口Opens the Edit Watch dialog97
acCmdZoomBox打开比例框Opens the zoom box97
acCmdVisualBasicEditor打开VBA代码编辑器
2002
acCmdSQLView打开SQL视图Changes to SQL View97
acCmdAddInManager打开COM加载项管理器
2002
acCmdToolbarControlProperties从自定义框显示工具栏控件的属性表Display properties for controls on Toolbars from the customize box?97
acCmdTileVertically垂直平铺ACCESS子窗体Tiles the Access child windows vertically97
acCmdAlignMiddle垂直居中对齐
2002
acCmdDuplicate创建所选择的对象副本Create a duplicate of the selected object.97
acCmdQueryTypeSQLPassThrough传递查询Changes the Query to a Pass Through Query97
acCmdUndo撤消上一个操作Undoes the last operation.97
acCmdRedo撤消Redoes last thing that was undone97
acCmdListConstants常数列表Display drop down in code window of available constants97
acCmdFindNext查找下一个Finds next occurrence of previously searched for phrase97
acCmdFindPrevious查找上一个Find previous occurrence of the last string searched for. Not really Edit Find but an enhancement97
acCmdFind查找Opens the Find dialog box.97
acCmdInsertChart插入一个图表Inserts a chart97
acCmdInsertRows插入行Inserts rows97
acCmdWindowCascade层叠排列子窗体Cascades the Access child windows97
acCmdTestValidationRules测试表的验证规则Tests a table's validation rules97
acCmdQuickPrint不显示印对话框直接打印Prints without displaying the print dialog box97
acCmdDocSize变更ACCESS子窗体大小Size Access child window97
acCmdCompileLoadedModules编译已加载的模块Compiles loaded modules97
acCmdCompileAllModules编译所有模块Compiles all modules97
acCmdCompileAndSaveAllModules编译并保存数据库的所有模块Compiles and saves all modules in the database.97
acCmdSaveLayout保存在关系图中的版面设置Saves the layout of the Relationships window97
acCmdSaveAllModules保存所有模块Saves all Code Modules?97
acCmdSaveRecord保存记录Saves the current record97
acCmdSave保存Saves the current object97
acCmdZoomSelection按选择区域放大
2000
acCmdFilterBySelection按选择内容筛选Filters the displayed records by the selected item97
acCmdSortAscending按选择的字段升序排列 Sorts by the selected field in ascending order97
acCmdSortDescending按选择的字段降序排列 Sorts by the selected field in descending order97
acCmdViewSmallIcons按小图标排列窗体对象Displays small icons in database window97
acCmdMacroConditions按下显示/取消宏条件列Toggles the display of the Macro Conditions column97
acCmdMacroNames按下显示/取消宏名称列Toggles the display of the Macro Names column97
acCmdArrangeIconsByCreated按创建日期顺序排列图标Arrange the icons in date created order97
acCmdFilterByForm按窗体筛选Displays the filter by form dialog97
acCmdZoom75按75%比例预览报表Zoom print preview to 75%97
acCmdZoom500按500%比例预览报表
2002
acCmdZoom50按50%比例预览报表Zoom print preview to 50%97
acCmdZoom25按25%比例预览报表Zoom print preview to 25%97
acCmdZoom200按200%比例预览报表Zoom print preview to 200%97
acCmdZoom150按150%比例预览报表Zoom print preview to 150%97
acCmdZoom1000按1000%比例预览报表
2002
acCmdZoom100按100%比例预览报表Zoom print preview to 100%97
acCmdZoom10按10%比例预览报表Zoom print preview to 10%97
acCmdAppMaximize 最大化ACCESS窗体Maximizes Access Window.97
acCmdArrangeIconsAuto 自动排列图标Auto arrange icons97
acCmdApplyDefault 应用缺省的格式给选择的控件Apply's default formatting to selected control.97
acCmdAnswerWizard 显示查找帮助窗口Displays the Help Find dialog97
acCmdAnalyzeTable 显示表分析向导Displays the Table Analyzer Wizard97
acCmdAddWatch 添加一个变量到监视窗口Adds a variable to the Watch Window97
acCmdAlignToTallest 将选择的控件大小改变至最高Sizes selected controls to tallest97
acCmdAlignToShortest 将选择的控件大小改变至最短Sizes selected controls to shortest97
acCmdAlignToGrid 将你选择的控件对齐网格Aligns selection to grid.97
acCmdAppRestore 还原ACCESS窗体Restores Access window.97
acCmdAppSize 改变ACCESS窗体大小Size Access window97
acCmdArrangeIconsByModified 按修改日期顺序排列图标Arrange the icons in date modified order97
acCmdArrangeIconsByType 按对象类型排列图标Arranges icons by the type of object97
acCmdAdvancedFilterSort  显示高组查询生成窗口，以生成过滤排序等Displays QBE for filter97
acCmdAddToNewGroup

2002
acCmdAlignmentAndSizing

2002
acCmdBackgroundPicture

2002
acCmdBackgroundSound

2002
acCmdBackup

2002
acCmdClearGrid
Clears all information from the QBE grid.97
acCmdClearItemDefaults
No idea at all. Possibly something to do with defaults in the design of Forms and reports.97
acCmdCreateReplica
Displays the Create Replica dialog???97
acCmdDataAccessPageAddToPage

2002
acCmdDataAccessPageBrowse
Changes from Design View to Page View of a Data Access Page2000
acCmdDataAccessPageDesignView
Changes from Page View to Design View of a Data Access Page2000
acCmdDataAccessPageFieldListRefresh

2002
acCmdDatabaseProperties
Display the database properties dialog97
acCmdDatabaseSplitter

2002
acCmdDataOutline

2002
acCmdDeleteGroup

2002
acCmdDeletePage
Deletes a page from a tab control97
acCmdDeleteTab
Not used to delete a tab from a tab control that is acCmdDeletePage97
acCmdDemote
Used on Data Access Pages to demote a Group heading2000
acCmdDiagramAddRelatedTables

2000
acCmdDiagramAutosizeSelectedTables

2000
acCmdDiagramDeleteRelationship

2000
acCmdDiagramLayoutDiagram

2000
acCmdDiagramLayoutSelection

2000
acCmdDiagramModifyUserDefinedView

2000
acCmdDiagramNewLabel

2000
acCmdDiagramNewTable

2000
acCmdDiagramRecalculatePageBreaks

2000
acCmdDiagramShowRelationshipLabels

2000
acCmdDiagramViewPageBreaks

2000
acCmdDocumenter
Displays the Documentor dialog97
acCmdDropSQLDatabase

2002
acCmdEditingAllowed
I think that this is something to do with the Editing Mode of a form.97
acCmdEditTriggers

2000
acCmdExit
Closes Access completely.97
acCmdFavoritesAddTo
Displays the Add To Favorites dialog97
acCmdFavoritesOpen
Displays the Open Favorites dialog97
acCmdFindNextWordUnderCursor
Finds the next occurrence of the word which is under the cursor. Not really Edit Find but an improvement on it.97
acCmdFindPrevWordUnderCursor
Finds the previous occurrence of the word which is under the cursor. Equivalent to Ctrl Shift and F397
acCmdFitToWindow
Fit print preview in window.97
acCmdGoBack
Returns to the previous Web page97
acCmdGoContinue
Resumes/starts code97
acCmdGoForward
Moves to the next Web page97
acCmdGroupByTable

2000
acCmdGroupControls

2002
acCmdHidePane

2000
acCmdHyperlinkDisplayText
Shows the text that is displayed for a hyperlink97
acCmdIndexes
Toggles display of the Indexes dialog97
acCmdInsertFile
This is not insert file into module which is acCmdInsertFileIntoModule




Have tried using it to insert into an OLE Object


acCmdInsertMovieFromFile

2002
acCmdInsertPage
Inserts a new page to a tab control97
acCmdInsertPivotTable

2002
acCmdInsertSpreadsheet

2002
acCmdInsertSubdatasheet

2002
acCmdInsertTableColumn
Inserts column into a table97
acCmdInsertUnboundSection

2002
acCmdInvokeBuilder
Open the Buiilder dialog97
acCmdLastPosition
Returns cursor to last position in the module window97
acCmdLayoutPreview
Print Preview with sample data97
acCmdLoadFromQuery
Opens the Applicable Query dialog97
acCmdMakeMDEFile
Creates a MDE File but does not appear to be able to be used for the active Database.97
acCmdMaximiumRecords

2002
acCmdMicrosoftOnTheWeb
Displays the Microsoft On the Web Menu???97
acCmdMicrosoftScriptEditor
Opens the Microsoft Script Editor when in the design of a Data Access Page2000
Does not appear to work from code.


acCmdNewObjectStoredProcedure
Opens a new Stored Procedure in design mode.2000
acCmdObjBrwGroupMembers
Toggles the Group Members option97
acCmdObjBrwHelp
Opens Help on selected item97
acCmdObjBrwShowHiddenMembers
Toggles the Show Hidden Members option97
acCmdObjBrwViewDefinition
Displays the selected module97
acCmdObjectBrowser
Displays the Object Browser97
acCmdOfficeClipboard

2002
acCmdOLEDDELinks
Opens the OLE/DDE Links dialog.97
acCmdOLEObjectConvert
Display the Convert dialog97
acCmdOLEObjectDefaultVerb
Displays OLE object in its native application.97
acCmdOpenSearchPage
Equivalent to pressing the Search the Web button on the Web Toolbar97
acCmdOpenStartPage
Equivalent to pressing the Start Page button on the Web Toolbar97
acCmdOpenTable
Opens a table97
acCmdOpenURL
Equivalent to pressing the Go button on the Web Toolbar97
acCmdOptions
Opens the Tools Options dialog box.97
acCmdOutdent
Outdents a line of code97
acCmdPageHdrFtr
Toggles display of the page header and footer97
acCmdPageNumber
Displays the Page Number dialog97
acCmdPageProperties

2002
acCmdParameterInfo
If not using autofill shows the list of arguments for a function97
acCmdPartialReplicaWizard

2002
acCmdPasteSpecial
Displays the Paste Special dialog97
acCmdPivotAutoAverage

2002
acCmdPivotAutoCount

2002
acCmdPivotAutoFilter

2002
acCmdPivotAutoMax

2002
acCmdPivotAutoMin

2002
acCmdPivotAutoStdDev

2002
acCmdPivotAutoStdDevP

2002
acCmdPivotAutoSum

2002
acCmdPivotAutoVar

2002
acCmdPivotAutoVarP

2002
acCmdPivotChartByRowByColumn

2002
acCmdPivotChartDrillInto

2002
acCmdPivotChartDrillOut

2002
acCmdPivotChartMultiplePlots

2002
acCmdPivotChartMultiplePlotsUnifiedScale

2002
acCmdPivotChartShowLegend

2002
acCmdPivotChartType

2002
acCmdPivotChartUndo

2002
acCmdPivotChartView

2002
acCmdPivotCollapse

2002
acCmdPivotDelete

2002
acCmdPivotDropAreas

2002
acCmdPivotExpand

2002
acCmdPivotRefresh

2002
acCmdPivotShowAll

2002
acCmdPivotShowBottom1

2002
acCmdPivotShowBottom10

2002
acCmdPivotShowBottom10Percent

2002
acCmdPivotShowBottom1Percent

2002
acCmdPivotShowBottom2

2002
acCmdPivotShowBottom25

2002
acCmdPivotShowBottom25Percent

2002
acCmdPivotShowBottom2Percent

2002
acCmdPivotShowBottom5

2002
acCmdPivotShowBottom5Percent

2002
acCmdPivotShowBottomOther

2002
acCmdPivotShowTop1

2002
acCmdPivotShowTop10

2002
acCmdPivotShowTop10Percent

2002
acCmdPivotShowTop1Percent

2002
acCmdPivotShowTop2

2002
acCmdPivotShowTop25

2002
acCmdPivotShowTop25Percent

2002
acCmdPivotShowTop2Percent

2002
acCmdPivotShowTop5

2002
acCmdPivotShowTop5Percent

2002
acCmdPivotShowTopOther

2002
acCmdPivotTableClearCustomOrdering

2002
acCmdPivotTableCreateCalcField

2002
acCmdPivotTableCreateCalcTotal

2002
acCmdPivotTableDemote

2002
acCmdPivotTableExpandIndicators

2002
acCmdPivotTableExportToExcel

2002
acCmdPivotTableFilterBySelection

2002
acCmdPivotTableGroupItems

2002
acCmdPivotTableHideDetails

2002
acCmdPivotTableMoveToColumnArea

2002
acCmdPivotTableMoveToDetailArea

2002
acCmdPivotTableMoveToFilterArea

2002
acCmdPivotTableMoveToRowArea

2002
acCmdPivotTablePercentColumnTotal

2002
acCmdPivotTablePercentGrandTotal

2002
acCmdPivotTablePercentParentColumnItem

2002
acCmdPivotTablePercentParentRowItem

2002
acCmdPivotTablePercentRowTotal

2002
acCmdPivotTablePromote

2002
acCmdPivotTableRemove

2002
acCmdPivotTableShowAsNormal

2002
acCmdPivotTableShowDetails

2002
acCmdPivotTableSubtotal

2002
acCmdPivotTableUngroupItems

2002
acCmdPivotTableView

2002
acCmdProcedureDefinition
Displays the object browser at the definition of word under cursor97
acCmdPromote
Used on Data Access Pages to promote a Group heading2000
acCmdPublish
Starts the Web Publisher Wizard97
acCmdPublishDefaults
Sets or calls Webpublishing Wizard defaults?97
acCmdQueryAddToOutput
Adds a field to the output of a View.2000
acCmdQuickInfo
Displays syntax help97
acCmdRecoverDesignMaster
Displays the Recover Design
Master dialog


acCmdRefreshPage
Refreshs the current Web Page97
acCmdRemove

2000
acCmdRemoveFilterSort
Removes all filters and sorts97
acCmdRenameGroup

2002
acCmdReset
Resets running code97
acCmdServerFilterByForm

2002
acCmdShowEnvelope

2002
acCmdShowMembers
Displays the methods/properties drop down97
acCmdStepOver
Steps over a line of code97
acCmdSubformDatasheetView

2002
acCmdSubformFormView

2002
acCmdSubformInNewWindow

2002
acCmdSubformPivotChartView

2002
acCmdSubformPivotTableView

2002
acCmdSynchronizeNow
Displays the Synchronize Now dialog97
acCmdTableCustomView

2002
acCmdTransferSQLDatabase

2002
acCmdUpsizingWizard

2002
acCmdViewDetails
Displays details in database window97
acCmdViewFunctions

2002
acCmdViewTableColumnNames

2000
acCmdViewTableColumnProperties

2000
acCmdViewTableKeys

2000
acCmdViewTableNameOnly

2000
acCmdViewTableUserView

2000
acCmdWebTheme

2002
acCmdWindowArrangeIcons
Arranges any minimized Access child windows along the bottom of the Access window.



(设置_安全_修复-相关文章技巧链接)：
VBA代码调用Access数据库系统压缩和修复数据库功能
发布人:zstmtony  
分享到：
点击次数：  更新时间：2016-11-26 21:24:16  【打印此页】  【关闭】
上一条：Access数据库手动添加链接表及代码打开链接表管理器  下一条：[Microsoft][ODBC Microsoft Access 驱动程序] Microsoft Jet 数据库引擎打不开文件'(未知的)'


相关文章

热门文章

热门产品