Access Reports and the Internet
Microsoft makes it easy to develop Internet-aware applications by adding hyperlinks to reports and by allowing you to save an Access report as an HTML document. These features are covered in the following sections.
Adding a Hyperlink to a Report
You can add hyperlinks to reports in the form of labels. When added, they serve as a direct link to a UNC or URL. To add a hyperlink to a report, follow these steps:
The Hyperlink Address and Hyperlink SubAddress properties come into play only when a report is saved as HTML and viewed in a Web browser, such as Internet Explorer 5.0. Saving a report as an HTML document is covered in the following section.NOTEAttached labels (those associated with a text box) do not have HyperLink Address or HyperLink SubAddress properties.
Saving a Report as HTML
To save a report as HTML, choose File, Export. Use the Save As Type drop-down list to select HTML documents (*, *l). Pick a location and name for the file, and then click Export. The document is saved as HTML and assigned the name and location you specified. Click Autostart to display the report in the default Web browser after the HTML is generated.
Saving a Report as XML
You can also save reports as XML by selecting the report within the database window (or by having the report open and in focus) and clicking File, Export from the menu bar. Choose XML Documents (*.xml) from the Save As Type drop-down. Accept the default filename or specify a different filename and click Export. Access generates three files: filename , filename .xsl, and filename .xml. The .xsl file is the style sheet for displaying the XML data. When you open the file within a browser, the report is displayed along with the data. If you open the .xml file within a browser, you are viewing the actual XML code. Saving reports as XML is covered in detail in Alison Balter's Mastering Access 2002 Enterprise Development .