<%dim yahoo yahoo=1 index=1 short=0 crumb1="DoCmd Macros" %> Docmd
Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links

DoCmd Examples - Access VBA<%response.write "
" & crumb1 %>

Docmd Macro VBA Example
Developer Home > Access Database Tutorials > DoCmd Examples<% response.write " > " & crumb %>
<% dim Gnum,Ynum Gnum="3847865006" Ynum="7164" dim Page_Type Page_Type="Prog" %>

DoCmd AddMenu
DoCmd ApplyFilter
DoCmd CancelEvent
DoCmd Close
DoCmd CopyObject
DoCmd DeleteObject
DoCmd FindRecord
DoCmd FindNext
DoCmd GotoControl
DoCmd HourGlass
DoCmd Min/Max/Restore
DoCmd OpenForm
DoCmd OpenQuery
DoCmd OpenReport
DoCmd OutputTo
DoCmd RunSQL
DoCmd SendObject
DoCmd TransferDatabase
DoCmd TransferText

Create Export Specs


Microsoft Office:
  MS Access 2003
  Access 2007
  Access 2010
  Access 2013

Docmd Access Visual Basic

The Access VBA Docmd object allows you to run a macro command within a visual basic module. This method is preferred over actually creating macros in your database. The command is used in all of our databases - you can see examples of Inventory, Reservation and Orders databases in our case studies. Many of the action methods of the DoCmd object have parameters or arguments.  Many of the arguments are required and others are optional.  If you do not define one of the optional arguments the value of the argument will revert to its default value.

The DoCmd object does not work for the following macro actions:

  • AddMenu

  • MsgBox - Replaces by MsgBox function

  • RunApp - Use the Shell function instead to run another application

  • RunCode - Run the function directly in Access Visual Basic

  • SendKeys - Use the SendKeys command

  • SetValue - Assign values directly in VBA

  • StopAllMacros

  • StopMacro 

The following list of DoCmd methods shows the commonly used commands.  The general format for the command is Docmd.Action.  There are often one or more options to these action methods. The method examples & definitions on the coding example pages are paraphrased from Access help for clarity and additional code examples have been added.
Example Page Example Description
DoCmd Add Menu The AddMenu command example demonstrates how to add an item to customized dropdown menus at the top of the Microsoft Access database screen.
DoCmd Apply Filter These examples employ the Docmd.ApplyFilter method to display only records that contain the state MD in the State field.
DoCmd Cancel Event The Cancel Event method quits the event that caused Microsoft Access to run the code containing this action.  All further execution of the event is aborted.
DoCmd Close The Access Close method carries out the Close action in Visual Basic to close a form, report, or query in the running database.
DoCmd Copy Object Docmd.CopyObject allows you to duplicate any database object.
DoCmd Delete Object The DoCmd DeleteObject method performs a delete operation on Access's objects such as tables, queries, forms and reports.
DoCmd Find Record The Access DoCmd.FindRecord method performs the Find Record action in Visual Basic.  This command is often used in conjunction with the Docmd.FindNext to automate searching for datasheet records based on user input.
DoCmd Find Next Find the next record that meets the criteria specified by the previous FindRecord action or the Find In Field dialog box.
DoCmd Goto Control Move the focus to the indicated field or control in the current record of the open form, datasheet, table datasheet, or query datasheet.
DoCmd Hour Glass Change the mouse pointer to an hourglass icon (or another icon of your choice) while program is running. This method is used when running a procedure from VBA that takes a while to run.
DoCmd Minimize Minimize docmd shrinks the active window down to the smallest size available while still showing the forms close and min/max size icons.
DoCmd Maximize The maximize command changes the size of the active Access form to the maximum dimensions allowed by the active Access application.
DoCmd Restore Docmd Restore returns the size of the active form to the setting previous to a maximize or minimize docmd execution.
DoCmd Open Form Open in Form view, datasheet, print preview, or design view
DoCmd Open Query Open a select or crosstab query in design, datasheet, or print preview. Or, execute an action query from VBA script
DoCmd Open Report Open a report in design or print preview, or to print the report directly to the default printer.
DoCmd Output To Output data in the current database (a datasheet, form, report, module, DAP) to a file in Excel, DOS text (*.txt), or rich-text format.
DoCmd Run SQL Run an SQL action query by using the SQL command. You may also run a DDL query
DoCmd Send Object Include the specified datasheet, form, report, module, or data access page in an e-mail message - there it can be viewed and sent.
DoCmd Transfer Text The TransferText method sends/receives records from/to the database or project and a file on your hard drive. The transfertext method may also be employed to establish data table links between databases.
TransferDatabase Import or export data from/to the current database (.mdb) or project (.adp) and other databases such as FoxPro, dBase, and ODBC databases.

Microsoft Office:
MS Access 2003
Access 2007
Access 2010
Access 2013

Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>