Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.
COURSE of the MONTH
11 days, 6 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2-
2
- +1
7 Comments
Active today
When it comes to images in Access, you can do it the easy way or the hard way.
The easy way:
http://www.ammara.com (DbPix)
The hard way:
Any other way.
I've used DbPix many times over the years and it's a stellar product.
The easy way:
http://www.ammara.com (DbPix)
The hard way:
Any other way.
I've used DbPix many times over the years and it's a stellar product.
Active today
<<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. >>
What happened there? This is basically the only way to do it with Access with what is built into the product.
Sounds like thumbnails would be a better way to go, then show the full picture when clicked. But that implies image manipulation beyond what Access offers.
Something like DBPix as Joe recommended is going to be a given. I'm wondering if Access is even the right product to do this with.
Yes, you can use images in Access, but if that the focus of the app, then you might be better off with a .Net based app.
Jim.
What happened there? This is basically the only way to do it with Access with what is built into the product.
Sounds like thumbnails would be a better way to go, then show the full picture when clicked. But that implies image manipulation beyond what Access offers.
Something like DBPix as Joe recommended is going to be a given. I'm wondering if Access is even the right product to do this with.
Yes, you can use images in Access, but if that the focus of the app, then you might be better off with a .Net based app.
Jim.
Member_2_7970851,
Even with linked images, (depending on your environment) displaying 350+ images in 90 records may be pushing the limits of what Access can do.
Remember, Access must "render" each image, so if your images are large, ...Access may run out of gas.
(this is more pronounced in reports (IIRC)
Give what Joe and Jim stated a try first.
You did not posts the specifics of your table(s) design, ...so I will presume that you may be storing the image paths in multiple fields, for the same sample (record), ...(Image1, Image2, Image3, ...ect.)
If so, then you might want to consider trying a "One To Many" relationship between the Samples and Images.
For example:
tblSamples
sID (PK)
sName
sValue
...ect
tblSampleImages
siID (PK
sID (FK)
siPath
...In this way you can have 1 sample and many images. (and save all the overhead associated with having multiple, repeating fields)
Then use a main form and a subform (in continuous view) to display the Samples and (multiple) images
Might look something like this:
Perhaps not ideal, ...put you could give it a shot to see if it performs better than your current setup.
JeffCoachman
Even with linked images, (depending on your environment) displaying 350+ images in 90 records may be pushing the limits of what Access can do.
Remember, Access must "render" each image, so if your images are large, ...Access may run out of gas.
(this is more pronounced in reports (IIRC)
Give what Joe and Jim stated a try first.
You did not posts the specifics of your table(s) design, ...so I will presume that you may be storing the image paths in multiple fields, for the same sample (record), ...(Image1, Image2, Image3, ...ect.)
If so, then you might want to consider trying a "One To Many" relationship between the Samples and Images.
For example:
tblSamples
sID (PK)
sName
sValue
...ect
tblSampleImages
siID (PK
sID (FK)
siPath
...In this way you can have 1 sample and many images. (and save all the overhead associated with having multiple, repeating fields)
Then use a main form and a subform (in continuous view) to display the Samples and (multiple) images
Might look something like this:
Perhaps not ideal, ...put you could give it a shot to see if it performs better than your current setup.
JeffCoachman
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
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
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
Brian
Featured Post
New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month11 days, 6 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.