Image Lookups

[Richard Wagstaff]

We have a simple Access 2003 database that prints off mailing labels. If
the packet has to go via first class post we type a "1" on the input form
and a "1" appears on the label (2 if it goes 2nd class post) - Simple!

However, the Royal Mail (bless 'em) have now changed the system and I have
to print an image on the label.

I've credted a simple looup table that contains the two images (1st & 2nd
class) but when the label prints it will only show/print the image name
rather than the image itself. In the properties menu there is a "display"
section and I've changed it from content to icon, but still no joy.

Can any kind soul point me in the right direction here?

Regards,

Richard

 

[Larry Linson]

As a start -- see the sample databases at http://accdevel.tripod.com that
illustrate three approaches to handling images in Access (the phenomenon you
describe usually is limited to using OLE Objects). To avoid memory leakage,
see http://www.lebans.com/printfailures.htm at MVP Stephen Lebans' site.

Larry Linson
Microsoft Access MVP