Avatar of Brian Cellura
Brian Cellura
 asked on

adding multiple pictures to access forms

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.
Microsoft AccessDatabases

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Jim Dettman (EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Jeffrey Coachman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Brian Cellura

ASKER
Okay Gang,

thank you for the comments, i am going to take a look and the product that Joe suggested, and you all are right it might be too much for access to deal with but I wanted to see if there is an elegant solution, I will let you know what I find after I try the software out. I do believe in not reinventing the wheel.

Cheers Brian
Jeffrey Coachman

OK,...keep us posted
Brian Cellura

ASKER
I looked into the Dbpix, and I do believe it would work, I do not think it is a straight forward as it is played out to be I have been in contact with their support group, which has only been midly helpful, basically I was left with the feeling that it was not worth all the effort, for a couple of picture maybe but to really be useful for a larger data set of pictures it seems awkward. It was not very clear how to do batch uploads of multiple pictures. I will look at it again when I have more time but for now that seems to be the best solution. Thank you for all your time.

Brian
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

System suggested closing this Q.