Open a database object

ShowOpen a table

ShowOpen a form or subform

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click Forms Button image under Objects.
  2. Click the form or subform you want to open.
  3. Do one of the following:

To open the form in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.), click Design on the Database window toolbar.

To open the form in Form view, (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.) click Open on the Database window toolbar.

 Note   If the main form is open in Design view, and you want to open a subform in a separate window, select the subform, and click Subform in New Window on the View menu. The subform control in the main form will turn white and display the name of the subform. You must save changes to the main form and subform individually.

ShowOpen a report or subreport

ShowOpen a query (select or crosstab) that shows records

ShowOpen a data access page

To open a data access page (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.), you must have Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later on your computer.

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click Pages Button image under Objects.
  2. Click the data access page you want to open.
  3. Do one of the following:

To open the page in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.), click Design on the Database window toolbar.

To open the page in Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Microsoft Internet Explorer 5.0 or later.), click Open on the Database window toolbar.

To open the page in Internet Explorer, do one of the following:

  • Open the page in Design view or Page view, and then click Web Page Preview on the File menu.
  • If Internet Explorer is your default Web browser, in Windows Explorer, double-click the HTML file to open the page in Internet Explorer.

 Note   You can also open a page in Page view by clicking Open on the File menu in Microsoft Access. Access opens the page without opening the database that the page is connected to, so wizards, builders, and add-ins are not available.

ShowOpen a macro

ShowOpen a module

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click Modules Button image under Objects.
  2. Do one of the following:

To open a new standard module (standard module: A Visual Basic for Applications (VBA) module in which you can place Sub and Function procedures that you want to be available to other procedures throughout your database.), and then click the New button on the Database window toolbar.

To open an existing standard or class module, select the module you want to open, and then click Design on the Database window toolbar.

To open a form module (form module: A module that includes Visual Basic for Applications (VBA) code for all event procedures triggered by events occurring on a specific form or its controls.) or report module (report module: A module that includes Visual Basic for Applications (VBA) code for all event procedures triggered by events occurring on a specific report or its controls.), open the form or report in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.), and then click Code Button image on the toolbar.

To open a new class module (class module: A module that can contain the definition for a new object. When you create a new instance of a class, you create the new object. Procedures defined in the module become the properties and methods of the object.) that isn't associated with a form or report, click Class Module on the Insert menu.

 
 
Applies to:
Access 2003