How do I put pictures in Access then print them out?

[Flueln1]

I'm not a programmer. I'm building a database in Access 2003 of my poster
collection. I would like to include a photo of each poster in its associated
record. I've achieved that in the form with some kind of add-on program
(don't remember exact name), but the pictures don't printout on the reports.
As non-technically as possible, can you explain how I can do this.
All my pictures are in .jpg format, but I could make .bmps if necessary.

 

[Bill]

If you store the file name of the image that is to be displayed
in your database records, you will need a small amount of code
to bind the image to the presumably unbound control in your
report at runtime. Assuming your image control is located in
the detail section of your report, in the report's OnFormat of
the detail section, i.e., Detail_Format. If so, then that bit of
code would set the picture property per the name in the
record. You will either have to include path information in
your database or otherwise define it within code, typically
not the best idea.

Post back with the answer to "where is the image file name
stored" and whether the path is stored with it or elsewhere.

I'll post some simple code for inclusion in your report's code
sheet accordingly.

Bill

 

[Larry Linson]

I'm not a programmer. I'm building a database in Access 2003 of my poster
collection. I would like to include a photo of each poster in its associated
record. I've achieved that in the form with some kind of add-on program
(don't remember exact name), but the pictures don't printout on the reports.
As non-technically as possible, can you explain how I can do this.
All my pictures are in .jpg format, but I could make .bmps if necessary.

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.

All the methods illustrated do require some VBA programming; you might be
able to use OLE Objects without programming, if you can live with the other
drawbacks they introduce.

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.

 

[Flueln1]

Currently I'm just keeping all my poster images in a folder on my hard drive
(i.e. not just the ones for the database). Do I need to store them some other
way? Should I create a folder with just the database photos?