Larry - Thank you for info - Tripod had a brilliant
solution for picture acquisition which place the correct
url into the text field in the table - however, there are
no reports.
Thanks for the kind words. When I created those examples, there were really
a lot of questions about forms and few about reports.
How do I create a report with - description, info, etc,
and picture ? at the moment I get - description, info, etc, and url ?
Which approach are you using and in what kind of control are you trying to
display the image? If you are trying to use an OLE Frame, there have been
reports of troubles; I've used Image Controls with good results. You just
put the code that would be used in the Current event of a Form into the
Print event of the Report -- that would be the code that loads the path and
filename of the image into
Did you take a look at Stephen Lebans' site, as referenced below?
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
