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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outputting Reports that contain Linked Pictures

Status
Not open for further replies.

essendon

IS-IT--Management
Jun 1, 2004
4
AU
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


 
The recipient can download SnapShot Viewer for free at


The Microsoft Snapshot Viewer enables you to view a report snapshot without having Microsoft Access 97 or Access 2000 or the run-time version of Microsoft Access on your computer.

A handy program that saves a picture of an Access report enabling you to make the report available others who do not have Microsoft Access. All they need is a copy of MS Snapshot Viewer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top