Picture of Employee in a Form

[RustyRick]

How can I lock a picture of an employee to his Employee record?

 

[RustyRick]

Don't seem to have it on my PC. I can get a picture onto about anything. But to tie a different pic with each employee seems to be intangible?

 

[RustyRick]

I can see that I use MS Paint Brush. How do I tie a photo file name to a OLE box. I get one pic across all employees. And he isn't even that good.

 

[Simon_MT]

Try using the image control instead. MS Pants! Use jpegs they are more efficient if you are using Access 2007+.

Simon

 

[RustyRick]

We'd have around 150 employees. And I can store them is a folder, no problem. My questions are. What format does Access like? Which format is best? jpg or....
When just how do I get each contact record through the form connect with the right picture. I've chase my tail, jumped through hoops etc, and can't seem to understand how to tie a pic to a record. I can put pics on the form.

 

[Simon_MT]

Try jpegs. The Image file name should correspond with the EmployeeID.

Use a query to map the explicit file name using the EmployeeID.

Simon