bitmaps in reports

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I'm using Access 2003 in an Access 2000 format.

I have a report that contains text and a few bitmaps
and .jpg files. When I try to save the report as a Word
doc, all of the images are missing. I'm really trying to
email the report containing images but when I use

DoCmd.SendObject acSendReport, "General Information",
acFormatHTML, EmailTO, EmailCC, EmailBCC

VBA command the email is created as plain text, not html
and the report attached to the email is also missing the
images.

What am I doing wrong? Thank you in advance.
 
I don't believe acFormatHTML saves in "Word" format, but HTML. Neither,
however, carries the graphics elements forward. I have had good luck using
Adobe Acrobate format -- that file could be attached to an e-mail. Another,
free, alternative is to save the Report output in Snapshot format and have
your users download the free Snapshot viewer from the Microsoft site.

Larry Linson
Microsoft Access MVP
 
Thanks for te information Larry. However, I have
hyperlinks in the report as well and hyperlinks won't
work in the snapshot viewer. .pdf won't work either

I'm really generating a one page report which I would
ultimately like to output as a browser page
(.html/.htm). The report has images and hyperlinks
embedded into it. It also has text fields that are
generated at run time. I went the Word route because you
can click on hyperlinks to follow them in Word, but as
you pointed out, images aren't forwarded.

Given what I'm trying to do, can you offer any advice on
where to look or other VBA commands I can use to do
this. Again, thank you for your help!

Pete
 
For a project that never got implemented, I had an idea of using report
content and events to cause the execution of VBA code in the Print event
that would generate and write HTML to a text file.

That still isn't going to get your pictures to the website, because the
pictures are separate files that are referenced from HTML, not _part_ of the
HTML. Maybe you could FTP each picture to the website when you encounter it,
from the VBA.

Larry Linson
Microsoft Access MVP
 
Back
Top