Solved

Displaying a picture on a form in Access

Posted on 2013-06-14
6
296 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 40

Accepted Solution

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

731 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