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 <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
- 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.
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- Start Microsoft Internet Explorer, or another Web browser program.
- 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. - 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:
159324 Web Pages Created with HTML Wizard Templates Look Alike
Additional query words: hyperlink
Keywords: kbinterop kbprb KB164007
