You can run Microsoft Access operations from Visual Basic by using methods of DoCmd objects. Actions are used to perform tasks such as closing windows, opening forms, and setting control values.

way

Name description

In Visual Basic, the AddMenu method performs the AddMenu operation.

In Visual Basic, the ApplyFilter method performs the ApplyFilter operation.

In Visual Basic, the Beep method performs the Beep operation.

In Visual Basic, the CancelEvent method performs the CancelEvent operation.

ClearMacroError deletes the error information stored in the MacroError object.

In Visual Basic, the Close method performs the close operation.

Close the database Close the current database.

CopyDatabaseFile copies the database connected to the current project as a Microsoft SQL Server database file for easy export.

In Visual Basic, the CopyObject method performs the CopyObject operation.

In Visual Basic, the DeleteObject method performs the DeleteObject operation.

DoMenuItem displays the corresponding menu or toolbar command of Microsoft Access.

Echo performs echo operation in Visual Basic.

In Visual Basic, use the FindText method to perform the FindText operation.

In Visual Basic, the FindRecord method performs the FindRecord operation.

GoToControl In Visual Basic, the GoToControl method performs the GoToControl operation.

GoToPage performs GoToPage operations in Visual Basic.

GoToRecord In Visual Basic, the GoToRecord method performs the GoToRecord operation.

Hourglass In Visual Basic, the hourglass method performs the hourglass operation.

LockNavigationPane uses the LockNavigationPane action to prevent users from deleting database objects displayed in the navigation pane.

In Visual Basic, the Maximize method performs the maximize operation.

In Visual Basic, the Minimize method performs the minimize operation.

In Visual Basic, the MoveSize method performs the MoveSize operation.

Navigator uses the Navigator to method to control how database objects are displayed in the navigation pane.

OpenDataAccessPage in Visual Basic, the OpenDataAccessPage method performs the OpenDataAccessPage operation.

OpenDiagram in Visual Basic, the OpenDiagram method performs the OpenDiagram operation.

OpenForm in Visual Basic, the OpenForm method performs the OpenForm operation.

OpenFunction Opens a user-defined function in a Microsoft SQL Server database for viewing in Microsoft Access.

OpenModule in Visual Basic, the OpenModule method performs the OpenModule operation.

OpenQuery in Visual Basic, the OpenQuery method performs the OpenQuery operation.

OpenReport in Visual Basic, the OpenReport method performs the OpenReport operation.

OpenStoredProcedure In Visual Basic, the OpenStoredProcedure method performs the OpenStoredProcedure operation.

OpenTable in Visual Basic, the OpenTable method performs OpenTable operations.

OpenView in Visual Basic, the OpenView method performs the OpenView operation.

In Visual Basic, the OutputTo method performs the OutputTo operation.

In Visual Basic, the PrintOut method performs a printout operation.

The Quit Quit method is used to exit Microsoft Access. You can choose one of the options to save the database object before exiting.

Rename In Visual Basic, the Rename method performs the rename operation.

In Visual Basic, the RepaintObject method performs the RepaintObject operation.

Requery performs the Requery operation in Visual Basic.

In Visual Basic, the Restore method performs a restore operation.

The RunCommand RunCommand method is used to run built-in commands.

RunMacro in Visual Basic, the RunMacro method performs the RunMacro operation.

RunSavedImportExport runs the saved import or export specification.

RunSQL in Visual Basic, the RunSQL method performs the RunSQL operation.

In Visual Basic, the Save method performs a save operation.

SearchForRecord You can use the SearchForRecord method to search for a specific record in a table, query, form or report.

In Visual Basic, the SelectObject method performs the SelectObject operation.

In Visual Basic, the SendObject method performs the SendObject operation.

SetDisplayedCategories specifies which categories are displayed under Browse Categories in the title bar of the navigation pane.

In Visual Basic, the SetMenuItem method performs the SetMenuItem operation.

SetProperty in Visual Basic, the SetProperty method performs the SetProperty operation.

SetWarnings in Visual Basic, the SetWarnings method performs the SetWarnings operation.

ShowAllRecords In Visual Basic, the ShowAllRecords method performs the ShowAllRecords operation.

In Visual Basic, the ShowToolbar method performs the ShowToolbar operation.

SingleStep pauses macro execution and opens the Step Macro dialog box.

StartNewWorkflow displays the Start New Workflow dialog box.

TransferDatabase in Visual Basic, the TransferDatabase method performs the TransferDatabase operation.

TransferSharePointList You can use the TransferSharePointList method to import or link data from the 1st_WSS_3 website.

TransferSpreadsheet in Visual Basic, the TransferSpreadsheet method performs the TransferSpreadsheet operation.

TransferSQLDatabase transfers the entire Microsoft SQL Server database specified to another SQL Server database.

In Visual Basic, the TransferText method performs the TransferText operation.

Workflow Tasks Displays the Workflow Tasks dialog box.

Docmd.runcommand has the following methods:

AcCmdDocMinimize Minimize Access to Sub-Form

AcCmdAppMinimize minimize access to the form

AcCmdDocMaximize maximizes access to subforms.

AcCmdQueryTotals total query

AcCmdAutoDial automatically dials the selected phone number.

AcCmdFont font font

The AcCmdSubdatasheetExpandAll subdatasheets are all expanded.

AcCmdSubdatasheetCollapseAll subdatasheets are shrunk.

AcCmdQueryTypeAppend supplementary query

AcCmdRegisterACTIVEXControls registers ActiveX controls.

AcCmdProperties property

AcCmdReferences reference

AcCmdRenameColumn Rename column

AcCmdRename rename

AcCmdStopLoadingPage stops loading web pages.

AcCmdEnd aborts the program.

AcCmdBringToFront as for the front

AcCmdStepToCursor is executed to the cursor.

Paste acCmdPasteAppend as a new record

AcCmdPasteAsHyperlink paste as hyperlink

AcCmdPaste paste

AcCmdVerticalSpacingIncrease increases the spacing of the selected objects.

Increase the horizontal spacing.

AcCmdBookmarksToggle Add/Delete bookmarks.

AcCmdFormHdrFtr Add/Delete Headers and Footers

AcCmdReportHdrFtr Add/Delete Report Headers and Footers

AcCmdOpenNewHyperlink opens the hyperlinked item in a new window.

AcCmdViewModules displays modules in the database window.

AcCmdViewMacros displays macros in the database window.

AcCmdViewQueries displays queries in the database window.

AcCmdViewReports displays reports in the database window.

AcCmdViewList displays items as a list in a data form.

AcCmdViewLargeIcons displays items as large icons in data forms.

AcCmdArrangeIconsByName arranges the icons in the data form in Arabic alphabetical order.

AcCmdSelectDataAccessPage selects the entire data page in design state.

AcCmdSelectForm selects the whole form in design state.

AcCmdNewObjectDiagram opens a new diagram in the design window.

When the module is formed, AcCmdSaveModuleAsText opens the Save File as dialog box.

AcCmdLineUpIcons arranges icons in columns.

AcCmdHideTable hides the table in the relationship window.

AcCmdClearAll deletes all tables in the Relationships window.

AcCmdMoreWindows displays the list of forms in the dialog box.

AcCmdPreviewOnePage is displayed as a page in print preview.

AcCmdPreviewFourPages is displayed as four pages in print preview.

AcCmdPreviewTwelvePages is displayed as twelve pages in print preview.

AcCmdPreviewTwoPages is displayed as two pages in print preview.

AcCmdPreviewEightPages is displayed as eight pages in print preview.

AcCmdViewShowPaneGrid toggles the display of grid panels in query design view.

AcCmdViewShowPaneDiagram toggles the display of the relationship panel in the query design view.

AcCmdViewShowPaneSQL switches the display of SQL panel in query design view.

AcCmdInsertQueryColumn Inserts a column in the query design view.

AcCmdViewVerifySQL verifies SQL syntax at query design time.

AcCmdTableNames toggles whether to display table names in query designer.

AcCmdQueryGroupBy toggles the display of groups in query designer.

AcCmdSpelling runs the spelling checker.

AcCmdRunOpenMacro running macro

AcCmdRun runs the query

AcCmdEditHyperlink allows editing hyperlinks.

AcCmdApplyFilterSort applies the filter criteria you entered in the filter design form.

AcCmdHideColumns hidden column

AcCmdWindowHide hides the form with focus.

AcCmdSend uses the default mail system to send the selected object.

AcCmdBookmarksNext moves to the next bookmark.

Accmdbookmarks Previous moves to the previous bookmark.

AcCmdRemoveTable delete table

AcCmdDocMove Mobile Access Sub-Form

AcCmdRecordsGoToLast moves to the last record.

AcCmdRecordsGoToNext moves to the next record.

AcCmdRecordsGoToPrevious moves to the previous record.

AcCmdRecordsGoToFirst moves to the first record.

Subdatasheet delete delete subdatasheet

AcCmdTransparentBackground deletes the background of the form.

AcCmdCompactDatabase compressed database

AcCmdSelectReport selects the entire report.

AcCmdSelectAllRecords selects all records.

AcCmdSelectRecord selects the current record.

AcCmdSelectAll selects everything in the window.

AcCmdQueryTypeSelect select query

AcCmdRepairDatabase repair database

AcCmdRowHeight row height

AcCmdRecordsGoToNew add records.

AcCmdNewObjectDataAccessPage new data page

AcCmdNewDatabase new database

AcCmdNewObjectView new view

AcCmdNewObjectClassModule new module

AcCmdNewObjectModule new module

AcCmdNewObjectFunction new function

AcCmdNewGroup new working group

AcCmdNewObjectForm new form

AcCmdNewObjectQuery new query

AcCmdNewObjectTable new table

AcCmdNewObjectReport new report

AcCmdVerticalSpacingMakeEqual equalizes the spacing of the same selected objects.

AcCmdAutoCorrect displays the AutoCorrect window.

AcCmdAutoFormat displays the AutoFormat dialog box.

AcCmdToolbarsCustomize displays the Customize Toolbar dialog box.

AcCmdShowTable displays the Add Table window.

AcCmdUserLevelSecurityWizard displays the User-level Security Wizard dialog box.

AcCmdUserAndGroupAccounts displays the User and Group Accounts dialog box.

AcCmdUserAndGroupPermissions displays the User and Group Permissions dialog box.

AcCmdAnalyzePerformance displays the performance analysis wizard window.

Call the menu command of the Print dialog box.

DoCmd。 RunCommand acCmdPrint

return

DoCmd。 RunCommand acCmdUndo