Engram 9 VBA Scripts » Access VBA Programming

Get to Know the DoCmd Object

The DoCmd object is one of your most potent programming allies because it can do virtually
anything you can do in Access's program window. When you type DoCmd. into the Code
window, the hefty list of items that appears in the little menu (see Figure 16-3) represents
various methods of the DoCmd object. Each method, in turn, represents something that the
DoCmd object can do.

Figure 16-3:

DoCmd methods in the Code window.

DoCmd methods in the Code window. Get Instant Access

Review
Professional Excel Templates

Popular Articles
MAPIFolder Object Properties
Query Table from Text File Excel
Using Excel OM to Create New
Linking an Excel Spreadsheet to
Working with Random Access Files

The DoCmd methods that you're most likely to use, especially as a beginning programmer, Using Get Attributes Method
The Translate Coordinates Method
are summarized in Table 16-1. Like with any Access object, you can use the Object Browser
Keypress events Excel VBA
to get more information on any DoCmd method. Coding User Form Excel 2007 VBA
Programming with Windows API Excel
Table 16-1 DoCmd Methods Worth Getting to
Whats difference between using
Know
Making Layer Active AutoCAD 2006
Goal DoCmd Method Listing Examples VBA Open
Pairing Spin Button with Text Box
Adding an Embedded Chart Using VBA
Close a form or report DoCmd.Close

Categories
Open a form DoCmd.OpenForm
AutoCAD 2006 VBA
Excel 2003 VBA
Do a menu command DoCmd.DoMenuItem Excel 2007 VBA
Excel 2003 VBA
Outlook 2002 VBA
Open a report DoCmd.OpenReport
Access 2007 VBA
Excel 2007 VBA Methods
Export data DoCmd.OutputTo Excel 2007 VBA
Visual Studio 2005 VBA
Excel VBA Macros
Excel 2002 VBA XML ASP
Goal DoCmd Method
Excel VBA Programming
Excel VBA Programming
Print data DoCmd. . PrintOut Access 2003 VBA
Visual Basic VBA
Excel 2007 VBA
Rename an object DoCmd. .Rename
Excel VBA Programming
Excel 2003 VBA Macros
Run a macro DoCmd. . RunMacro Office 2007 VBA
VBA 2007 Reference
Office 2003 VBA
Run an action query DoCmd. . RunSQL
Excel 2007 VBA
Access 2007 VBA
Save an object DoCmd. .Save Access VBA Programming
VBA 6 Reference
Select an object DoCmd. .SelectObject Excel VBA Reference
Access 2003 VBA
Office 2007 VBA
E-mail an object DoCmd. .SendObject Access VBA Programming

Import/export spreadsheet DoCmd.TransferSpreadsheet

Import/export spreadsheet DoCmd.TransferSpreadsheet

You can read about the Object Browser in Chapter 5. But just as a quick head-start, in case
you're already familiar with the Object Browser, you can find the DoCmd object in the
Classes column. When you click it, you'll see its methods in the Members column. The
bottom of the window shows a summary of the syntax for using the method. For details,
though, you want to click the Object Browser's Help button, as shown in Figure 16-4.

Help for highlighted item

Figure 16-4:

DoCmd selected in the Object Browser.

, Ohjecä ßmwser

|<AII
3._i äl^l JJ
Libraries:-

DoCmd j üj Ä

Library | ciasi' [ Member

HR
Access

KR Application Dependencylnfo [aJ DependencyObjects ^iDoCmd Document

B*B Fiolrl

Members of'DoCmd' AddMenu ApplyFilter 3» Beep sft Can eel

CopyData base File CopyObject DeleteObject DoMenultem Echo 3»

FinHPornrH

Classes

Dependencylnfo [aJ DependencyObjects ^iDoCmd Document

B*B Fiolrl

Sub Close([OCyec [Save^sflcOosi

Member of Acce;

Members of'DoCmd' AddMenu ApplyFilter 3» Beep sft Can eel

CopyData base File CopyObject DeleteObject DoMenultem Echo 3»

FinHPornrH

tType A s AcQbiectType -Save - a cSave Prompt]) is DoCmd

DoCmd Summary syntax

+2 -1
« Previous Page Next Page »

Recommended

Professional Excel Templates

Related Posts
Professional Excel Templates
More DoCmd methods for forms
Get to Know the DoCmd Object
Listing Using the DoCmd Object for Special Tasks
Changing colors - Access VBA Programming
Responding to a Msg Box button click

Related Category
Spreadsheet

Responses
JENS
Is Docmd Object categorized to Object or method?

Reply
7 days ago

Post a comment

Name...

Email...

Website... Optional

Comment it up...

Comment

About | Contact | Write For Us | Shop | Privacy Policy | Resources