In Access 2013, what is best way to  'link' to a photo of an applicant or employee?

bcreen
bcreen used Ask the Experts™
on
I'd like to be able to NOT STORE employee/candidate head shots in my Access 2013 database (back-end) because of the space it takes up.
Can 'links' to the photos stored on a folder on our terminal server or file server be stored in a particular field type in Access 2013 and when that employee's record is loaded in a form, the photo be automatically be displayed?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solutions Only
Retired IT Professional
Commented:
Yes! You can store the path to the image file in table field.

The photo is displayed in a form or report.
Hamed NasrRetired IT Professional

Commented:
On a form add an Image control, Image0
Properties sheet-Format
Picture Type: Linked
Picture: D:\pict.jpg    

In code:
Image0.Picture = text_Field_Containing_ImagePath

Open in new window

Scott McDaniel (Former Microsoft Access MVP - EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
In Access 2010 and newer, you can just set the ControlSource of the Image control to the path of your image and not worry with code. See this article:

http://www.experts-exchange.com/articles/10315/Images-on-continuous-forms.html

It discusses Continuous Forms, but the same concepts apply to Single forms as well.
Merete

Commented:
Side idea,
 you could also resize the image? with VSO image resizer since size of these images is the main problem as well.
bcreen

Author

Commented:
Ideas all worked !  Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial