Rob said:
I have a table where i have stored pictures of
ads (in .tiff format), stored as OLE Objects.
This table also has an id field which is related
to a table called advertisers. I have a form
where i would like to display the corresponding
ad to the particular advertiser. Any suggestions?
If there is only one picture per advertiser, then the example for OLE
objects in the
sample imaging databases at
http://accdevel.tripod.com will give you a
starting point for your own database application. The sample databases
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 have more than one picture per advertiser, you may want to put the
records with the pictures in a Form which you embed in a Subform Control in
the main Form that shows advertisers.
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.
Larry Linson
Microsoft Access MVP
