Outputting Reports that contain Linked Pictures

[Essendon]

Hi,

My database has a picture link field that holds the path of a jpg image. (e.g. "C:\project\images\pic1.jpg").
I have a report that has code that pulls the image from the path and displays it in a Image Frame on the report (Me![Image_Frame].Picture = Image_Path_Variable). This works fine when I open the report within access, but if I output the report to the HDD, eg:

DoCmd.OutputTo acReport, "Leasehold Motel Email Report", acFormatRTF, "c:\test.rtf"

when I go to open test.rtf all is good, but no picture. The same thing happens when I try HTML(acFormatHTML), no picture again. However if use snapshot format, then I get the picture.

I am going to be emailing the reports, I really need the pictures to be embedded into a format that is easy for people to use. The reports will be emailed out to many people on the internet, most of whom won't have ms access. Is there a format that will allow me to do this? Can only people with Access view snapshot files?

Thankyou in advance for any advice at all!

Peter


[This message has been edited by Essendon (edited 05-06-2002).]

[This message has been edited by Essendon (edited 05-06-2002).]

 

[dynamictiger]

I don't know if this would work, but it might. Try changing the property on your image box after linking the picture to embedded.

 

[Ring]

a similar problem

Hi, I see your post about the picture in report just now, it was posted back a few months ago. So, I think you may have solve this problem. If you have, may be you will extend your help to me.

I need to print a report with picture in it. However, the path in the database may lead to a jpg file that does not exist anymore. So I will need to replace that particular picture with a NotFound.jpg. But I can't get the testing part correct:

The following is my codes:

If (Me![Filename] = Null) Then
Me![ImageFrame].Picture = "D:\picture\NotFound.jpg"
Else

Me![ImageFrame].Picture = Me![Filename]

End If

The If statement is not working cause data field does have a file path there. If I delete the path, the code still run thru and error message: type mismatch.

Please help.

Thanks.
Ring