need help badly!

  • Thread starter Thread starter todd
  • Start date Start date
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?
 
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?
Click to expand...

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.
 
Back
Top