T
todd
I have a database of training for each employee. How can I
attach a photo of each employee to the query that looks
them up by name?
attach a photo of each employee to the query that looks
them up by name?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike Painter
todd said:I have a database of training for each employee. How can I
attach a photo of each employee to the query that looks
them up by name?
I have a field in my employee table that contains the location of the
picture. "C:\EmployeePIctures\Fred.jpg"
In the on current event for the form I have:
Me![EmployeePicture].Picture = Me![pictureloc]
You can use the Dir function and a little code to go through the folder that
holds the pictures and add just new pictures.
I place the location in both the PictureLoc field and the Employees name
field, then all I have to do is edit the name as needed.