If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need help badly!
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? |
#2
|
|||
|
|||
need help badly!
"todd" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|