b1_better
10-09-2010, 02:04 PM
I am creating a personnel database in Access. I want to link employee photos to my form. The pics are located on my network drive.
In my mdb I have a text field named Empl_Photo for the photo path. On my form I have a Bound Object Frame and the control source is Empl_Photo.
1 - I have the code to browse folders to locate the photo, I just don't know how to take that info and automatically update my Empl-Photo field with the path information.
2 - After the field is updated, I want to be able to use a Command button to make the photo appear in my frame so I can make sure it's the correct employee.
Is this possible? I'm a novice...so use small words. :wot Thanks!
In my mdb I have a text field named Empl_Photo for the photo path. On my form I have a Bound Object Frame and the control source is Empl_Photo.
1 - I have the code to browse folders to locate the photo, I just don't know how to take that info and automatically update my Empl-Photo field with the path information.
2 - After the field is updated, I want to be able to use a Command button to make the photo appear in my frame so I can make sure it's the correct employee.
Is this possible? I'm a novice...so use small words. :wot Thanks!