Export Report to HTML

[Gerrit.B]

Is it possible to export a access report to html with getting several pages for longer reports.
If possible i would like to keep existing images and lay-out in this report.

Is this possible using vba?

G.

 

[jackd]

Is it possible to export a access report to html with getting several pages for longer reports.
If possible i would like to keep existing images and lay-out in this report.

Is this possible using vba?

G.

What have you tried so far?

 

[Gerrit.B]

So far i Googled a couple of days on several forums.
A lot of people are trying and asking the same but no one gets a answer.

Regards,

G.

 

[Norie]

Isn't there an option to export as HTML?

No idea how successful it might be but it's definitely there.

 

[jackd]

So far i Googled a couple of days on several forums.
A lot of people are trying and asking the same but no one gets a answer.

Regards,

G.

Try modifying this with your own "ReportName" and "OutputFileName"

DoCmd.OutputTo acOutputReport, "ReportName", acFormatHTML, "OutputFileName.htm"

Good luck.

jack

 

[Gerrit.B]

Jack,

I tried your method, and it works, it converts my report to htm.
Still 2 issues:
* All images in report are lost.
* Got several pages output instead of 1 long page.

I made a mistake in my first post and typed "with" instead of "without" several pages.

Regards,

G.

 

[hafizimran]

Jack,

I tried your method, and it works, it converts my report to htm.
Still 2 issues:
* All images in report are lost.
* Got several pages output instead of 1 long page.

I made a mistake in my first post and typed "with" instead of "without" several pages.

Regards,

G.

sir in Access 2010, report can be exported as ".html"

 

[SydneyGeek]

Jack,

I tried your method, and it works, it converts my report to htm.
Still 2 issues:
* All images in report are lost.
* Got several pages output instead of 1 long page.

I made a mistake in my first post and typed "with" instead of "without" several pages.

Regards,

G.

I would generally use PDF instead. Highly formatted reports don't convert to HTML easily.
The alternative is to build your own page via a template, but that is probably more work than you want to do.

Denis