Access 2000 question

[Guest]

I am fairly new to Access. I need to have a form display an image, but the
image is different for each record. Each record contains a customer # and
the image to be displayed is named accordingly, such as customer # abc123
would need to have the image abc123.bmp displayed. I am running into
roadblocks trying to do this in Access and would appreciate any suggestions
and would be glad to provide more information. Thanks.

Richard

 

[Lynn Trapp]

The Employee form in the Northwind database shows how to do this.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

I see how to go through each record manually and do this. What I am doing is
importing this file into Access with the customer # and then needing to print
the correct bitmap, which is a captured signature, with the correct customer,
inserted into the form. Is this possible? I would like to automate this if
possible.

 

[Lynn Trapp]

Store the path to the bitmap file in your customer's table and reference
that in the code for your form, just like they did in Northwind.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html