Using Data Access Pages
You learned earlier in this chapter how to use the DoCmd object's OpenDataAccessPage method to open a data access page in either browse mode or design mode. Briefly, the syntax is
DoCmd.OpenDataAccessPage datapagename, datapageview
in which datapagename is the name of the data access page to open, and datapageview specifies whether to open the page in browse mode (acDataPageBrowse, the default) or in design mode (acDataPageDesign). While it is possible to open a data access page in design mode and manipulate it using VBA code, you will most often be opening pages in browse mode and making them visible so the user can work with them. The following code opens the Northwind database and displays the data access page “Review ...
Get Office® XP Development with VBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
