How do I link jpg file in ms access table so when I open the repor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I link jpg file in ms access table so when I open the report I see the
picture but don't have to keep the picture in a table.
I would like to specify the source of the .jpg file in a table.

Thank you


Artie
 
i haven't done this in a while. the trick is to save the filename in the
table in a way that you can programatically link it up with the actual file.
this normally is done by requiring the actual files to be in subfolder(s)
under the mdb's location then using vba to get the mdb location and build
the file path from that. then you need a viewer control that will display
jpg's in a form or report, the last time i did this i used the 'imagn'
activex control from http://www.jpg.com/. there may be something else that
will display jpgs now.
 
hi,
the way i use is to put the file path in the table. then
change the image controls picture property with dlookup.
Me.Image6.Picture = DLookup("[filepath]", "IMA", "[id] ='"
& Me.Text0 & "'")
note: the DLookup line wrapped.
you can see this site for images on reports.
http://www.microsoft-
accesssolutions.co.uk/bound_image_report.htm
 
The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images 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.

If you've already starting storing images in your database, and you'd like
to export them all, see:
http://www.lebans.com/oletodisk.htm
 
i found this post really helpful but when i tried it out i got an error on
Me.Text0
i cant figure out where this Me.Text0 comes in here, maybe im missing
something
thanks

[email protected] said:
hi,
the way i use is to put the file path in the table. then
change the image controls picture property with dlookup.
Me.Image6.Picture = DLookup("[filepath]", "IMA", "[id] ='"
& Me.Text0 & "'")
note: the DLookup line wrapped.
you can see this site for images on reports.
http://www.microsoft-
accesssolutions.co.uk/bound_image_report.htm
-----Original Message-----
How do I link jpg file in ms access table so when I open the report I see the
picture but don't have to keep the picture in a table.
I would like to specify the source of the .jpg file in a table.

Thank you


Artie
.
Click to expand...
Click to expand...
 
Back
Top