best way to output to HTML

[Zorro1265]

What would be the best option to output access reports to static HTML pages? I want to keep all the formatting if possible.

 

[Zorro1265]

Wow no one has ever needed to do this before? How do you all post data to a web page then? Zorro

 

[Francescina]

I do this from time to time.
It is very simple: you just create a file (???.HTM) with OPEN (see online help) and write the HTML-code you need. Insert your data where and how you want.
It is very fast, reliable and only the initial programming of the HTML pages takes some time.

 

[tekagami]

could you elaborate on this simplicity? please!!

 

[twinmill]

Here's what I use in my code to generate static HTML pages each time a user quits the application after making data changes:

'Define filename variable (drive and path to server are optional)

Dim strQryAll as String
strQryAll = "Query All Areas_1.html"

'Publish updated data to the server using a query called "Query All Areas"

DoCmd.OutputTo acOutputQuery, "Query All Areas", acFormatHTML, strQryAll

You can also format your query to include a suitable title. This method requires no HTML coding at all on your part.