Exporting a Report to Html template

G

Guest

I am looking for some information on how far you can go with exporting an
Access Report to html template. I want to be able to format the template so
that certain fields are set up in a table in a certain order. Currently when
I export a report to HTML it puts each line in a table and it's very hard to
manipulate. Is there a way to better code the template and also the template
I have breaks out the pages and I would like to have the report run on a
continuous page and don't know how to change the code so it does. Here is
the code I used:

<HTML>

<head>
<TITLE><!--AccessTemplate_Title--></TITLE>

<style>
<!--
a:visited { color: #0000FF }
-->
</style>
</head>

<!--The following token places the object name in the title bar of the Web
browser.-->

<P ALIGN = CENTER>
<BODY BACKGROUND = "unsaved:///gray.jpg">

<p>

</BODY>

<!--The following token places all object output inside the <BODY> tag.-->

<!--AccessTemplate_Body-->

<BR><BR>

</p>

<P ALIGN = CENTER>Page <!--AccessTemplate_PageNumber-->.</P>

<!--The following HTML tag adds a company logo to the bottom of the Web
page.-->

</HTML>
 
J

John Nurick

Hi Lisa,

I don't think the standard template setup takes you very far with what
you want to do. The documentation at
http://office.microsoft.com/en-us/assistance/HP052692641033.aspx doesn't
hint at any further ways of controlling the way Access creates HTML
pages, such as putting the whole report in one HTML page. (If the report
is short, try setting a very large page size in the printer driver: if
it fits on one page in Print Preview it should end up on one HTML page.)

Otherwise, you may have to write VBA code that generates the HTML you
need.

Sometimes a useful technique is to create a query that includes HTML
tags in calculated fields (tags to contrl the formatting of the fields
in each record). Then export the query to a text file (space-delimited,
no text qualifiers). Finally add HTML headers (up to and including
<body>) and footers (including and from </body> and change the extension
to .htm.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hello...This thread is a continuation of one from 2003...pasted below: 2
External data from HTML document 2
get username using asp.net 2
Frontpage template ?? 1
No Page_Load event when loading .aspx page into iframe 7
Populating HTML file with data from table 5
Export Data from Report or Query to Excel 1
Background images not displaying. 1

Top