DoCmd Members (Access)

You can use the methods of the DoCmd object to run Microsoft Office Access actions from Visual Basic. An action performs tasks such as closing windows, opening forms, and setting the value of controls.

Methods

Name	Description
AddMenu	The AddMenu method carries out the AddMenu action in Visual Basic.
ApplyFilter	The ApplyFilter method carries out the ApplyFilter action in Visual Basic.
Beep	The Beep method carries out the Beep action in Visual Basic.
BrowseTo	The BrowseTo method performs the BrowseTo action in Visual Basic.
CancelEvent	The CancelEvent method carries out the CancelEvent action in Visual Basic.
ClearMacroError	Removes information about an error that is stored in the MacroError object.
Close	The Close method carries out the Close action in Visual Basic.
CloseDatabase	Closes the current database.
CopyDatabaseFile	Copies the database connected to the current project to a Microsoft SQL Server database file for export.
CopyObject	The CopyObject method carries out the CopyObject action in Visual Basic.
DeleteObject	The DeleteObject method carries out the DeleteObject action in Visual Basic.
DoMenuItem	Displays the appropriate menu or toolbar command for Microsoft Access.
Echo	Carries out the Echo action in Visual Basic.
FindNext	The FindNext method carries out the FindNext action in Visual Basic.
FindRecord	The FindRecord method carries out the FindRecord action in Visual Basic.
GoToControl	The GoToControl method carries out the GoToControl action action in Visual Basic.
GoToPage	Carries out the GoToPage action in Visual Basic. .
GoToRecord	The GoToRecord method carries out the GoToRecord action in Visual Basic.
Hourglass	The Hourglass method carries out the Hourglass action in Visual Basic.
LockNavigationPane	You can use the LockNavigationPane action to prevent users from deleting database objects that are displayed in the Navigation Pane.
Maximize	The Maximize method carries out the Maximize action in Visual Basic.
Minimize	The Minimize method carries out the Minimize action in Visual Basic.
MoveSize	The MoveSize method carries out the MoveSize action in Visual Basic.
NavigateTo	You can use the NavigateTo method to control the display of database objects in the Navigation Pane. .
OpenDataAccessPage	The OpenDataAccessPage method carries out the OpenDataAccessPage action in Visual Basic.
OpenDiagram	The OpenDiagram method carries out the OpenDiagram action in Visual Basic.
OpenForm	The OpenForm method carries out the OpenForm action in Visual Basic.
OpenFunction	Opens a user-defined function in a Microsoft SQL Server database for viewing in Microsoft Access.
OpenModule	The OpenModule method carries out the OpenModule action in Visual Basic.
OpenQuery	The OpenQuery method carries out the OpenQuery action in Visual Basic.
OpenReport	The OpenReport method carries out the OpenReport action in Visual Basic.
OpenStoredProcedure	The OpenStoredProcedure method carries out the OpenStoredProcedure action in Visual Basic.
OpenTable	The OpenTable method carries out the OpenTable action in Visual Basic.
OpenView	The OpenView method carries out the OpenView action in Visual Basic.
OutputTo	The OutputTo method carries out the OutputTo action in Visual Basic.
PrintOut	The PrintOut method carries out the PrintOut action in Visual Basic.
Quit	The Quit method quits Microsoft Access. You can select one of several options for saving a database object before quitting.
RefreshRecord	The RefreshRecord method performs the RefreshRecord macro operation from Visual Basic.
Rename	The Rename method carries out the Rename action in Visual Basic.
RepaintObject	The RepaintObject method carries out the RepaintObject action in Visual Basic.
Requery	Carries out the Requery action in Visual Basic.
Restore	The Restore method carries out the Restore action in Visual Basic.
RunCommand	The RunCommand method runs a built-in command.
RunDataMacro	Use the RunDataMacro method to run a named data macro from Visual Basic.
RunMacro	The RunMacro method carries out the RunMacro action in Visual Basic.
RunSavedImportExport	Rrun a saved import or export specification.
RunSQL	The RunSQL method carries out the RunSQL action in Visual Basic.
Save	The Save method carries out the Save action in Visual Basic.
SearchForRecord	You can use the SearchForRecord method to search for a specific record in a table, query, form, or report.
SelectObject	The SelectObject method carries out the SelectObject action in Visual Basic.
SendObject	The SendObject method carries out the SendObject action in Visual Basic.
SetDisplayedCategories	Specifies which categories are displayed under Navigate to Category in the title bar of the Navigation Pane. .
SetFilter	Use the SetFilter method to apply a filter to the records in the active datasheet, form, report, or table.
SetMenuItem	The SetMenuItem method carries out the SetMenuItem action in Visual Basic.
SetOrderBy	Use the SetOrderBy method to apply a sort to the active datasheet, form, report, or table.
SetParameter	Use the SetParameter method to create a parameter for use by the BrowseTo, OpenForm, OpenQuery, OpenReport, or RunDataMacro methods.
SetProperty	The SetProperty method carries out the SetProperty action in Visual Basic.
SetWarnings	The SetWarnings method carries out the SetWarnings action in Visual Basic.
ShowAllRecords	The ShowAllRecords method carries out the ShowAllRecords action in Visual Basic.
ShowToolbar	The ShowToolbar method carries out the ShowToolbar action in Visual Basic.
SingleStep	Pauses macro execution and opens the Macro Single Step dialog box.
TransferDatabase	The TransferDatabase method carries out the TransferDatabase action in Visual Basic.
TransferSharePointList	You can use the TransferSharePointList method to import or link data from a Windows SharePoint Services 3.0 site.
TransferSpreadsheet	The TransferSpreadsheet method carries out the TransferSpreadsheet action in Visual Basic.
TransferSQLDatabase	Transfers the entire specified Microsoft SQL Server database to another SQL Server database.
TransferText	The TransferText method carries out the TransferText action in Visual Basic.