Hi, I'm at a bit of a standstill in a project I'm working on for a customer. Basically, I work for an ID Printer company and this order is for a school set of printed ID's.
Our software populates fields (name, grade,photo, etc) from an access database. I currently have a database of all the students that I'll be making IDs for. So, basically, I have a database of students (all identified by student number) and a folder full of their pictures (also identified by student ID number).
For instance, if an individual entry in the database was named S110566, the associated picture would be named S110566.jpg.
My question is this: Is there any way to make access pull the pictures from the picture folder into the database so that each picture is matched with its respective student ID number? I'm asking because there are roughly 2000 students, and linking every picture individually would be extremely time consuming.
I'd really appreciate any insight that one of you Access wizards could provide. thanks!