Hi,

Does anyone know how to display external files (i.e. jpg files) in
reports? I have stored the file location in a table and am looking
for a control to display it in a report. I can display the photo in a
form but the same control does not work in the report. I have based
my tables and control off of Larry Linson, Imaging in Access example
database. (Awesome resource!)

Please help.
Thanks.
Kevin

Image controls work for me in reports. I load the path and filename into the
Picture property in the Print event. In reports, to avoid memory leakage,
you should also see MVP Stephen Lebans'
http://www.lebans.com/printfailures.htm. PrintFailure.zip is an Access97 MDB
containing a report that fails during the Access formatting process prior to
being spooled to the Printer Driver. This MDB also contains code showing how
to convert the contents of the Image control to a Bitmap file prior to
printing. This helps alleviate the "Out of Memory" error that can popup when
printing image intensive reports.

Larry Linson
Microsoft Access MVP


"Kevin" <kzingler2 (AT) marcct (DOT) org> wrote

How do you do it on the form? The way I do it on my forms is a form_current
event.
me.imgname.picture = me.txtPicturePath
for my reports i write the same code just i put it in the Detail_Format
event.
let me know if this helped.
Chaim B.


kzingler2 (AT) marcct (DOT) org (Kevin) wrote in message news:<6b8efbe0.0411241131.1d4fa841 (AT) posting (DOT) google.com>...

Chaim,

I have tried your expression with no luck - do you have a sample
database that works?

Kevin

chaimb (AT) gmail (DOT) com (Chaim B.) wrote in message news:<24b98d13.0411241521.5578f207 (AT) posting (DOT) google.com>...

Larry,

I have put this code into the open event of the
report:Me![imgTheImage].Picture = Me![txtImagePathAndFile]

When I run the report I get an error message - runtime error 13 - Type
mismatch.

How can I fix this?

Thanks
Kevin

"Larry Linson" <bouncer (AT) localhost (DOT) not> wrote

I use a hyperlinked text or button to access photos for my database. I
save the record as a unique value of some sort and use that value to
name the images. This way you can change the hyperlink as needed for
each record when you view the record.

"Kevin" <kzingler2 (AT) marcct (DOT) org> wrote

Why did you choose the Open event? The only events to consider for this
purpose are the Format and Print events of the Report Section containing the
Image control. Nothing is actually displayed at the time of a Report's Open
event (which fires but once for a Report) and, if I remember correctly, no
Record is "current" at Open time.

I use the Print event for efficiency, because the Format event may fire more
than once for each Record. Print, AFAIK, only fires once when the Record is
displayed (the same record may be displayed more than once if you are in
Preview and page back and forth -- and Print will fire each time it
displays).

Larry Linson
Microsoft Access MVP