Link to home
Start Free TrialLog in
Avatar of bcreen
bcreenFlag for United States of America

asked on

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

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?
ASKER CERTIFIED SOLUTION
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Side idea,
 you could also resize the image? with VSO image resizer since size of these images is the main problem as well.
Avatar of bcreen

ASKER

Ideas all worked !  Thanks.