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

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.
Side idea,
 you could also resize the image? with VSO image resizer since size of these images is the main problem as well.

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