G said:
I have 2 types of pictures I'm dealing with.
One is the bitmap (which does print) and the other is a
link to a picture. When it comes up in report print
preview, the picture shows fine, but when I hit print, it
does not print the picture. Everything else prints fine.
Any suggestions on this?
It is really hard to debug without details of how you are trying to do what
does not seem to be working. What approach are you using to print the image:
an Image Control, an Unbound OLE Frame, or something else? If the former,
and the image is one that requires one of the graphics filters, and those
are not installed, that could be the problem. If the latter, then you are at
the mercy of whatever software is registered to process the image type -- we
do see complaints, from time to time, about image processing software that
does not play well with reports.
For an overview and examples, 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. The examples are forms; for reports, the code in
form's Current event should be in the Report Section's Print event.
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.
And, in fact, Stephen's approach, converting to bitmap, may be all you need,
if the bitmap you are printing works nicely.
Larry Linson
Microsoft Access MVP
