DoCmd Object (Access) Published: July 16, 2012 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. For example, you can use the OpenForm method of the
DoCmd object to open a form, or use the Hourglass method to
change the mouse pointer to an hourglass icon. Most of the
methods of the DoCmd object have arguments — some are required,
while others are optional. If you omit optional arguments, the
arguments assume the default values for the particular method.
For example, the OpenForm method uses seven arguments, but only
the first argument, FormName, is required. The following example
shows how you can open the Employees form in the current
database. Only employees with the title Sales Representative are
included. The DoCmd object doesn't support methods corresponding
to the following actions: MsgBox. Use the MsgBox function.
RunApp. Use the Shell function to run a