Share this Page URL
Help

Chapter 12. Access and the Web > Exporting Data as HTML - Pg. 417

Access and the Web 417 Figure 12-1. You can create an HTML template to apply to data you export as HTML. The template uses the tokens described in Table 12-1 In the following steps, we'll export the expense detail query as HTML again and apply a simple HTML template to the query's data. Figure 12-1, shows the HTML template file open in Notepad. (You can find this document in the Chap12 folder.) You can see in which sections the Access tokens appear. In the HEAD section of the HTML document, we've added an IMG tag that refers to the Northwind Traders logo we've used in other examples. Table 12-1. Access Tokens Used in an HTML Template Token <!--AccessTemplate_Title--> Description Displays the name of the database object you export. The object's name appears in the Web browser's title bar. Place this token in the TITLE section of the HTML template. Marks where the output of the database object will appear. Place this token in the BODY section of the template. Creates a link to the first page of a multipage report. Place this token in the BODY section of the template. Creates a link to the page that precedes the current page. Place this token in the BODY section of the template. Creates a link to the page that follows the current page. Place this token in the BODY section of the template. Creates a link to the last page of a multipage report. Place this token in the BODY section of the template. Displays the current page number. Place this token in the BODY section of the template. <!--AccessTemplate_Body--> <!--AccessTemplate_FirstPage--> <!--AccessTem-plate_PreviousPage--> <!--AccessTemplate_NextPage--> <!--AccessTemplate_LastPage--> <!--AccessTemplate_PageNumber--> Apply an HTML template during export 1. In the Database window, select qryExpenseDetails in the list of queries, and then click Export on the File menu.