Storing pics

[bill crumpton]

I have a database that stores pic of subjects. I would like to store the pics in a separate folder and not in Access. How do I tell Access to link to the picture that is stored on the same drive but different folder? I would like Access to automatically link to the picture that I would name as the subjects ss#. The SS# is also on the subjects form in the Access DB. Any help is greatly appreciated.

BAC

 

[gedeanom]

I have a database that stores pic of subjects. I would like to store the pics in a separate folder and not in Access. How do I tell Access to link to the picture that is stored on the same drive but different folder? I would like Access to automatically link to the picture that I would name as the subjects ss#. The SS# is also on the subjects form in the Access DB. Any help is greatly appreciated.
BAC

save the folder string (ie: "C:\project\images\") in a field of table, then use it as a public variable in the program ("ImageFolder"),
so when the form event is after update, use :

private sub form_afterupdate()
image1.picture = imagefolder & ss#
end sub

 

[bill crumpton]

I think I understand but not fully. I am a little unclear on how to link the picture with the field.

BAC