printing pictures in access

[mrpookz]

ok, I have a DVD access files which list all of my DVD's, I Have the Covers
of each of these dvd's as a bitmap format picture, what I want to do is when
I print this file the pictures also print. Is this possible? If so how?

 

[Roger Carlson]

Basically, you will want to store the path and filename to each picture in
the corresponding record in your table. Then you can load the image
programmatically in either a form or a report.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "Picture.mdb" which illustrates how to do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Larry Linson]

ok,

I have a DVD access files which list all of my
DVD's, I Have the Covers of each of these
dvd's as a bitmap format picture, what I want
to do is when I print this file the pictures also
print. Is this possible? If so how?

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, and they are not standard Windows
bitmap images, .BMP, 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