adding multiple pictures to access forms
Posted on 2016-08-08
I have an access database with a form for recording samples I take in the field, while in the field I take photos of the samples, I take anywhere from 2 to up-to 12 photos, it varies per sample. I would like to when I bring up the form have the pictures show up as well, I have over 90 samples and or data points with corresponding photos totaling over 350+ so embedding as on OLE is out of the question. I added all the links or folder and name paths to each record in the database an starting trying to use image controls to link the paths but often only one or two pics would show up, never any more than 3. So What I want to do is some how get the photos to show up in the form and then if I click on a photo it opens up the original photo.