Displaying a picture on a form in Access

So on my form, frm-member, I have a box that was asked to be added so it can display the persons photo when their record is brought up.

I have not created a table yet to hold the pictures for a few reasons.
1) I don't know what is the best practice for storing photos in a database
URL or in the table itself?  If a URL how do I do that and if in the table how do I do that?

2) I don't know how to have the picture display on the form when the persons record is brought up.

Any thoughts?

John SheehySecurity AnalystAsked:
Who is Participating?
als315Connect With a Mentor Commented:
Take a look at my article: Images on continuous forms
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You might want to consider this or at least be aware of if you are dealing with images in an Access database ... and I can totally vouch for this program.  

It does *all* the work for you. Examples show how to add a simple 'control' panel to Load, Save, Zoom In/Out, Size To Fit and much more.  AND ... virtually eliminates BLOAT associated with storing images in an Access MDB. I have 3 clients who sell commercial run-time products that use DBPix.

Note. I have no connection with DBPix ... except I have used it many times ...

Helen FeddemaCommented:
This depends on the Access version, if you want to actually store the images in a table.  What version are you using?  For more recent versions, is it a desktop database (2013 terminology), a Web app, or a 2010 hybrid app?
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

John SheehySecurity AnalystAuthor Commented:
It is a 2010 ACCDB with a front end and a back end.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Most developers store the photos in a specific folder, and then store the path to that photo in their database table. You can then use this code in the Form's Current event to show them in your Image control:

Me.YourImageControl.Picture = Me.YourFieldThatSToiresThePath
John SheehySecurity AnalystAuthor Commented:
I know I am late in responding but this answer was perfect for my use.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.