Dale Logan
asked on
Show a photo on a form
Experts,
I've been away from working for a year or so and am very rusty. I am helping a non-profit group by building them an Access database. They have been around for 5 or 6 years and are working with kids in Africa by arranging for sponsors to send the kids to school. They have been keeping up with everything in an Excel file. They have over 100 kids now and just can't keep up with it in Excel very well.
I've got a form with subforms created that shows all of the information needed on each kid and want to also show the picture of each kid. I can't find a solution on EE that answers what I am looking for. The database will be accessed via Remote Desktop Connection. I was thinking I could store the images in a folder and then show the image on the form. I just don't know how. I know I would need to provide the path and file name, but just can't figure out how to put it all together. By the way, I never have been very good at VBA, but am able to figure out a few things.
Thanks for any help, Dale.
I've been away from working for a year or so and am very rusty. I am helping a non-profit group by building them an Access database. They have been around for 5 or 6 years and are working with kids in Africa by arranging for sponsors to send the kids to school. They have been keeping up with everything in an Excel file. They have over 100 kids now and just can't keep up with it in Excel very well.
I've got a form with subforms created that shows all of the information needed on each kid and want to also show the picture of each kid. I can't find a solution on EE that answers what I am looking for. The database will be accessed via Remote Desktop Connection. I was thinking I could store the images in a folder and then show the image on the form. I just don't know how. I know I would need to provide the path and file name, but just can't figure out how to put it all together. By the way, I never have been very good at VBA, but am able to figure out a few things.
Thanks for any help, Dale.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Look at my article Images on continuous forms
ASKER
Dale,
Thanks for the help. I now have things working as you recommended. However, I am now stuck on how to use FileDialog procedure to allow users to select which picture goes with which kid. I have searched EE and found several examples, but can't seem to make them work. I will simply create a new question.
Thanks, Dale
Thanks for the help. I now have things working as you recommended. However, I am now stuck on how to use FileDialog procedure to allow users to select which picture goes with which kid. I have searched EE and found several examples, but can't seem to make them work. I will simply create a new question.
Thanks, Dale