View Full Version : Linking images to a record


jbradly
09-05-2000, 09:36 AM
I have a database with records of name, id number, and photo (which is displayed in the table as a unique photo name for each record). I want to create a justified form that shows the correct picture with the name so that as you scroll through the form you can see the photo, name, and ID of each individual. I am using Access 97 and I cannot upgrade to 2000. I could cut and paste each picture but I have over 3000 records and I don't have a lot of time. Any suggestions?

OutbackInvestments
09-06-2000, 04:19 AM
Cant you set the field picture to OLE data type and do it that way?
Then, if you need it automatically, I think this works.
Form_On_Current:
[Picture]=[Name]&".jpg"
I think that might get it to work.
Hope it helps