Working with Microsoft Access Objects

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Working with Microsoft® Access objects primarily means working with Form, Report, and DataAccessPage objects and the controls they contain. You can use these powerful Access objects to format and display data and make it possible for the user to add or edit data in a database. In addition, Access exposes many other objects you can use to work with your Access application; among the most important are the CurrentProject, CurrentData, CodeProject, CodeData, Screen, and DoCmd objects and the Modules and References collections. This section presents an overview of how to work with Access objects by using Microsoft® Visual Basic® for Applications (VBA).

**Note   **You can use the Object Browser and Access Visual Basic Reference Help to learn more about individual objects, properties, methods, and events.

Tables and relationships, the data in tables, and queries are managed and maintained by a database engine. For .mdb-type databases, Access uses the Microsoft® Jet database engine. For .adp-type databases, Access uses the Microsoft® SQL Server database engine or any other ActiveX Data Objects (ADO) data source. You programmatically work with tables, data in tables, or queries by using ADO or Data Access Objects (DAO).

In This Section

• Understanding the Access Application Object
  Use the properties and methods provided by the Application objects to create and work with other Access objects.
• Built-in Access Functions and Methods
  Learn about functions and methods that appear in the Object Browser as methods of the Application object.
• Working with Reports, Forms, and Data Access Pages
  Use reports, forms, and data access pages provided by Access to display data to the user.

Related Sections

• Working with Office Applications
  Take advantage of different objects, collections of objects, properties, methods, and events to build your application.
• Working with Microsoft Excel Objects
  Use Microsoft® Visual Basic® for Applications (VBA) to work with Microsoft® Excel objects, from within either Excel itself or another Microsoft® Office XP application to gain access to every part of Excel.
• Working with Microsoft FrontPage Objects
  Create, deploy, modify, and manage Web sites using Microsoft® FrontPage®.
• Working with Microsoft Outlook Objects
  Create custom Microsoft® Outlook® objects and manipulate those objects from within Outlook or from another application using Microsoft® Visual Basic® for Applications (VBA) code from within Outlook or another Microsoft® Office XP application by using Automation.
• Working with Microsoft PowerPoint Objects
  Automate Microsoft® PowerPoint® by using the Application object, from which you can open an existing Presentation object or create a new presentation.
• Working with Microsoft Project Objects
  Build powerful custom applications easily with the Microsoft® Project object model.
• Working with Microsoft Word Objects
  Use ® Visual Basic® for Applications (VBA) to work with the Microsoft® Word® Document object, Application object, and Documents collection.
• Working with Microsoft Visio Objects
  Design, model, and manage complex enterprise-level systems with the sophisticated tool set provided by Microsoft® Visio® products.