output report to HTML without getting multiple files

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

What do I need to set in my report to just get one page
rather than multiple pages (to output to HTML)? I cannot
find any way to set page length to something other than a
regular form and it paginates the report on HTML, giving
me multiple HTML files rather than just one with all of
the info in one HTML file.
 
AFAIK, there's no way to use Access Save as HTML the way you want to do.
And, it is sometimes inconvenient.

You can put VBA code in the Print event to write the information from the
controls, along with appropriate HTML markup, to a text file... you will
still be taking some advantage of the formatting of Reporting, but you'll be
doing more work.

You could write VBA code to post-process those individual HTML files into a
single file -- they are, after all, only text files. And, perhaps
surprisingly, I don't think you'd have to know a great deal of HTML to
remove some of the navigation that is included on the generated pages; they
are only hyperlinks, and that would be the only place in a report, normally,
that you'd find the <A ... > tag.

Follow up and let us know what you decided to do... I am interested. I've
faced a similar problem, opted for the first suggestion I made here, but the
requirement for that output faded away so I never actually implemented it.

Larry Linson
Microsoft Access MVP

Visit http://www.microsoft.com, search for "wish list" and leave a
suggestion for different HTML generation options in a future version of
Access.

Larry Linson
Microsoft Access MVP
 
That's what I was afraid of. :( I think I'm going to
write the report as a .rtf file and use MicrosoftWord to
write the .html file. That seems to be the easiest thing
I can currently come up with.
Truly appreciate your help with this. I am amazed at how
well this bulletin board works and always get an answer
to my questions. Thanks
 
write the report as a .rtf file and use MicrosoftWord to

Access is known to truncate fields when writing to RTF.
Actually, I think it probably has the same problem when writing
to HTML, but fewer people try that...

We write to a snapshot, and embed the snapshot viewer OCX
into the web page.

(david)
 
Back
Top