Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Multi-page Report into One HTML File

Status
Not open for further replies.

WhtChoklat

Technical User
Jul 11, 2003
20
0
0
US
I have a multi-page report that I am exporting to an HTML File. I want to make it so that instead of exporting three html files (one for each page) it will put all three pages into one HTML file. Is this possible, and could someone please help me.
 
I had the same problem. I could not find a solution within Access, so I used a different solution.

I created a mail merge document in word, linked it to my Access database, and generated the report. From Word I then saved to HTML.

It is, I'll admit, a bit clunky, but it does work.
 
you could try on your button

DoCmd.OpenReport stDocName, acPreview
DoCmd.OutputTo acOutputReport, stDocName, acFormatHTML, stOutput, True

That should work

Hope this helps
Hymn
 
Tried it.. Still 2 pages of HTML, but thanks for your suggestion, Hymn.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top