ACC2002: OutputTo Macro Action or Method Creates an Incomplete Data Access Page (282388)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q282388
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you save a form or a report to a data access page by using the OutputTo macro action or method, there are problems with the resulting page. These problems include:

  • The script validation to verify the browser or Office Web Components on the computer is missing.
  • Banners from sections on the page are missing.
  • The HTML STYLE tag is outside of the HTML HEAD tag on the page.
  • There are missing HTML META tags on the page.

RESOLUTION

Open the page in the Data Access Page designer in Access, and then save it.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

You can save forms and reports as data access pages. This can help you get started converting existing form-based applications for use on your intranet or Internet site.

Steps to Reproduce the Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Start Access, and then open the sample database Northwind.mdb.
  2. Insert a new module, and then type or paste the following code:
    Sub SaveFormAsPage()
    DoCmd.OutputTo acOutputForm, "Customers", acFormatDAP, "c:\Customers.htm", True
End Sub
  3. Type the following line in the Immediate window, and then press ENTER.
    SaveFormAsPage
  4. Internet Explorer should open the page that you just saved. Click Source on the View menu to view the HTML for the page.

    Note the problems that are described in the "Symptoms" section of this article.

REFERENCES

For more information about saving objects as a data access pages, click Microsoft Access Help on the Help menu, type about saving an object as a data access page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbbug KB282388
©2004 Microsoft Corporation. All rights reserved.