ACC97: Error When Clicking Page Link in Report Exported to HTML
ID: Q172287
|
The information in this article applies to:
-
Microsoft Access 97
-
Microsoft FrontPage 97 for Windows
-
Microsoft FrontPage for Windows, versions 1.0, 1.0a, 1.1, 1.1a
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you export a report to HTML format, and then view the report in
your Web browser, you may receive one of the following error messages
when you click on one of the page links:
HTTP/1.0 500 Server Error (161)
-or-
HTTP/1.0 400 Bad Request
CAUSE
You edited a template in Microsoft FrontPage, and then you used that
template when you exported the report to HTML.
RESOLUTION
After you have edited the template in Microsoft FrontPage, open it in a
text editor, such as Notepad. In the tokens that create the navigation
links, replace any instance of the string "%3c" with the character "<";
replace any instance of the string "%3e" with the character ">" as well.
For example, change
<a href="%3c!--AccessTemplate_FirstPage--%3e">First</a>
<a href="%3c!--AccessTemplate_PreviousPage--%3e">Previous</a>
<a href="%3c!--AccessTemplate_NextPage--%3e">Next</a>
<a href="%3c!--AccessTemplate_LastPage--%3e">Last</a>
to:
<a href = "<!--AccessTemplate_FirstPage-->">First</a>
<a href = "<!--AccessTemplate_PreviousPage-->">Previous</a>
<a href = "<!--AccessTemplate_NextPage-->">Next</a>
<a href = "<!--AccessTemplate_LastPage-->">Last</a>
After you have saved the edited template, export the report to HTML again.
You can also edit the HTML files to which the report was exported and add
the hyperlinks that allow you to move to different pages. For example, on
the first page of the exported report, the navigation hyperlinks would be:
<A HREF = "#">First</A>
<A HREF = "#">Previous</A>
<A HREF = "Report1_1Page2.html">Next</A>
<A HREF = "Report1_1Page5.html">Last</A>
However, this method is not recommended because it is inconvenient if the
report contains more than a few pages.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97. This
problem no longer occurs in Microsoft Access 97 Service Release 1.
NOTE: Stand-alone Microsoft Access 97 Service Release 1 is not currently
available, but you can update your copy of Microsoft Access 97 to Service
Release 1 by downloading Microsoft Office Service Release 1 from
Microsoft's Web site at:
http://officeupdate.microsoft.com/Articles/sr1fact.htm
MORE INFORMATIONSteps to Reproduce Problem
- Start Microsoft Access and open the sample database Northwind.mdb.
- On the Help menu, click Contents And Index and search for "HTML
documents, template files," and then display the topic "HTML template
file example."
- Select all of the text in the topic.
- Start a text editor, such as Notepad.
- Paste the text from the Help topic into the text file.
- Save the file under the name FPTest.htm in the \Templates\Access
subfolder of the Microsoft Office folder. The default location of this
folder is
\Program Files\Microsoft Office\Templates\Access
- Start Microsoft FrontPage.
- On the Tools menu, click Show FrontPage Editor.
- Open the file that you saved in step 6.
- On the File menu, click Save As. Click As File and save the file as
FPTest2.htm.
- Quit Microsoft FrontPage and switch to Microsoft Access.
- On the File menu, click Save As HTML.
- In the first screen of the Publish To The Web Wizard, click Next.
- In the screen which asks what you want to publish, click the Reports
tab and select Products By Category; then, click Next.
- When prompted for an HTML template, click Browse and locate the file
FPtest2.htm that you created in step 12. Click Select, and then click
Next.
- In the next screen, select Static HTML, and then click Next.
- When prompted for a location to publish to, choose a directory that
has Read access. Click Finish.
- In a browser, enter the address of the output file you created in step
17, for example:
http://<servername>/<directory>/Products by Category_1.html
- Click Next to move to the next page. Notice that you receive one
of the errors described in the "Symptoms" section.
REFERENCES
For more information about navigation links in templates, please see the
following article in the Microsoft Knowledge Base:
Q164007 Reports Exported to HTML Have No Page Links
Keywords : kberrmsg IntpOff IntpWeb HtmView
Version : 97
Platform : WINDOWS
Issue type : kbbug
|