When I save a report as HTML it saves it as multiple files. 5pages equals 5 HTML files. Does anyone know a way using VB code to get the files to merge to create one file (or any other way). This way when the file is put on a web page the user just scrolls through to see the report in a continuous report.
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access report saved as HTML
- Thread starter theodo
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
I have been searching for the same thing... I do not know about you but I am calling the reports using code (VBA) via the docmd.outputto statement...
IE:
DoCmd.OutputTo acOutputReport, "ReportName", acFormatHTML, , True, "aTemplate.htm"
which of course creates a web page for every page in the report.. while it is nice... it is not what my user wants...
I know you can output queries and get one page... but my user already has complex reports with heavy coding... so this is not an option for me... although if you know how to code with VBA... this may or may not work for you...
DoCmd.OutputTo acOutputQuery, "A name of a Query", acFormatHTML, , True, "a template name.htm"
IE:
DoCmd.OutputTo acOutputReport, "ReportName", acFormatHTML, , True, "aTemplate.htm"
which of course creates a web page for every page in the report.. while it is nice... it is not what my user wants...
I know you can output queries and get one page... but my user already has complex reports with heavy coding... so this is not an option for me... although if you know how to code with VBA... this may or may not work for you...
DoCmd.OutputTo acOutputQuery, "A name of a Query", acFormatHTML, , True, "a template name.htm"
- Status
Similar threads
- Locked
- Question
- Locked
- Question
