ACC97: Reports Exported to HTML Have No Page Links

• Microsoft Access 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you export a report to HTML format, and then you view the report in your Web browser, there are no links that enable you to move from page to page in the report. Because of this, you can only view the first page of the report.

CAUSE

The HTML templates that ship with Microsoft Access 97 are not designed to be used with reports. They do not contain the placeholders for page numbers or navigation links that are necessary for multi-page reports.

RESOLUTION

Create your own custom template, or copy and then customize the template you want to use. Add the appropriate placeholders for the page number and the navigation links.

For more information about creating an HTML template with the appropriate placeholders for multi-page reports, search the Help Index for "HTML documents, template files." The topic "About HTML template files" contains information about creating the template and the topic, "HTML template file example" contains an example of using the page number and navigation link placeholders. Note that in addition to adding the placeholders, the example surrounds the placeholders with the appropriate <A> tags and displaytext. Without the tags and displaytext, the placeholders will not be hyperlinks when you view them in a Web browser.

MORE INFORMATION

Steps to Reproduce Behavior

1. Start Microsoft Access and open the sample database Northwind.mdb.

2. Select the "Alphabetical List of Products" report in the Database window, and then on the File menu, click Save As/Export.

3. In the Save As dialog box, click "To an External File or Database," and then click OK.

4. In the Save Report In dialog box, select HTML documents (*.html; *.htm) in the Save As Type box, and type "Alphabetical List of Products.html" (without the quotation marks) in the File Name box. Note the folder to which you are exporting the files. Click Export.

5. In the HTML Output Options dialog box, browse to locate Sky.htm, which is located by default in \Program Files\Microsoft Office\Templates\ Access. Click OK.

6. Copy all of the HTML files for the report to a folder on your Web server computer where you have Read permission. In an unaltered copy of Northwind.mdb, those files are:

         Alphabetical List of Products.html
         Alphabetical List of ProductsPage2.html
         Alphabetical List of ProductsPage3.html
         Alphabetical List of ProductsPage4.html
         Alphabetical List of ProductsPage5.html
         \Program Files\Microsoft Office\Templates\Access\Sky.jpg
         \Program Files\Microsoft Office\Templates\Access\Msaccess.jpg
   

7. Start Microsoft Internet Explorer 3.0, or another Web browser program.

8. Type the Uniform Resource Locator (URL) in the address box of your Web browser to view "Alphabetical List of Products.html." For example, if you saved your HTML files in a folder called Test in the wwwroot folder of your Web Server, type:

         http://<servername>/test/Alphabetical List of Products.html
   

   Note that the URL depends upon where your files are located on the Web Server.

9. Note that the report is displayed in your Web browser, but there are no navigation links; you can only view the first page of the report.

REFERENCES

For more information about creating HTML files in Microsoft Access 97, search the Help Index for "HTML documents, creating."

For more information about HTML templates and image files, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q159324
   TITLE     : Web Pages Created with HTML Wizard Templates Look Alike