catalog - containing data and picture of product

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

Help explains using OnCurrent and AfterUpdate for a form -
How do I print a report using a table with the item
information including a text field (255) with a URL for
items picture - ie a different picture for each item from
the same folder

This should be simple - I've even checked for templates

I am trying to produce a line item catalog with a picture

Thanks for your help - Ian
 
Ian said:
Help explains using OnCurrent and AfterUpdate for a form -
How do I print a report using a table with the item
information including a text field (255) with a URL for
items picture - ie a different picture for each item from
the same folder

This should be simple - I've even checked for templates

I am trying to produce a line item catalog with a picture
Click to expand...

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 code
illustrated in the Current event for Forms would be in the Print event (more
efficient than doing it in the Format event -- the Format event can execute
multiple times for a given record).

However, for your printed 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
 
Back
Top