The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

OpenDataAccessPage Macro Action

Office 2007

You can use the OpenDataAccessPage action to open a data access page in Page view or Design view.

 Note   This action will not be allowed if the database is not trusted. For more information about enabling macros, see the links in the See Also section of this article.


The OpenDataAccessPage action has the following arguments.

Action argumentDescription
Data Access Page NameThe name of the page to open. The Data Access Page Name box in the Action Arguments section of the Macro Builder pane shows all pages in the current database. This is a required argument.

If you run a macro containing the OpenDataAccessPage action in a library database, Microsoft Office Access 2007 first looks for the page with this name in the library database, and then in the current database.

ViewThe view in which the data access page will open. Click Browse or Design in the View box. The default is Browse.


This action is similar to double-clicking the data access page in the Navigation Pane, or right-clicking the data access page in the Navigation Pane and then clicking Design View.

To run the OpenDataAccessPage action in a Visual Basic for Applications (VBA) module, use the OpenView method of the DoCmd object.

See Also
  • Enable or disable macros in Office documents