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.
