Microsoft KB Archive/164007

= ACC97: Reports Exported to HTML Have No Page Links =

Article ID: 164007

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q164007



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



SYMPTOMS
When you export a report to HTML format and then view the report in your Web browser, there are no links 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 that 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; 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  tags and displaytext. Without the tags and displaytext, the placeholders will not be hyperlinks when you view them in a Web browser.



Steps to Reproduce Behavior
 Start Microsoft Access and open the sample database Northwind.mdb. Select the "Alphabetical List of Products" report in the Database window, and then on the File menu, click Save As/Export. In the Save As dialog box, click "To an External File or Database," and then click OK. 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 in the File Name box. Note the folder to which you are exporting the files. Click Export. 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.</li>  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:

<pre class="fixed_text">     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 </li> Start Microsoft Internet Explorer, or another Web browser program.</li> 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:// /test/Alphabetical List of Products.html

Note that the URL depends upon where your files are located on the Web Server.</li> 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.</li></ol>

<div class="references_section">