I've used access to do some simple things and know my way around a bit, but I need help from the experts now because the task I'm currently working on will require some code...
I have a single table containing 10,000 rows of user data. The table headers are PersonID, Surname, FirstName, and MiddleName. However, there is a current need to add a column in which I intend to attach a passport photo to each of these 10,000 names.
I currently have all 10,000 passport photographs (saved using each person's Surname, Firstname, Middlename, and PersonID in jpeg format) in a folder, but it is going to take forever to attach pictures one after the other. I know it is possible to write a script or module or something which would instruct MS Access to read the user data from the table, locate the picture folder, open the folder, search for the corresponding Surname, FirstName, MiddleName, and PersonID picture file, and attach this jpeg file to the correct row in the table.
I would more than grateful for any assistance i can get.