Share via


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

  • 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.