I am not very experienced in Access but have to make a data base that displays a matching photo. The program that I use for photographing school students creates a database that has 1st name, lst name, student id and a reference # for each sudent. It also can create a copy of the image named by either the student name(Fn_Ln or Ln_Fn), the student ID # or the reference #. I have tried to bring the images into access without much success. I was able to get one image in but when there are 100, 150, 250 images manually entering a file name is for the birds. How can I use the file name on the images to automatically open when the particular student is selected?? This is my first post to this group but i posted this to another section I'm not sure which is the right place but I think this is.
would prefer that the image "pop up" when the particular record is accessed
Right - so when the record is created, you have to ask the user to select the image. You store the link as a text value and then next time it opens, have an On_Current event that takes the text value and applies it to the picture frame.