[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Displaying a picture on a form in Access

Posted on 2013-06-14
6
Medium Priority
?
301 Views
Last Modified: 2013-07-02
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
0
Comment
Question by:John Sheehy
[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
6 Comments
 
LVL 75
ID: 39249133
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.  
http://www.ammara.com/dbpix/access.html

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

mx
0
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 39249263
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?
0
 

Author Comment

by:John Sheehy
ID: 39249282
It is a 2010 ACCDB with a front end and a back end.
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
LVL 40

Accepted Solution

by:
als315 earned 2000 total points
ID: 39249790
Take a look at my article: Images on continuous forms
0
 
LVL 85
ID: 39249792
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
0
 

Author Closing Comment

by:John Sheehy
ID: 39293608
I know I am late in responding but this answer was perfect for my use.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question