VBA Access

[dlalela]

My question is exactly like Forsi's. I am working on an emplyee database where all records about an employee is kept.

I am using access 2003, and I would like to know how to add photos (e.g employee photos) for each record on a form without using the ole object.

I would like to click on a command button like Add/Change and I would like it take me to a folder on the computer where I can select each photo, add it and the photo must change for each record (path to the image).

Thanks for any assistance.

[ADezii]

You can use a File Dialog Box to navigate to a Folder containing all your Graphic Images. Once you select an Image, its Absolute Path can be captured via the File Dialog and stored in a Field (TEXT) along with other Employee Information. Each Employee's Photo can then be dynamically loaded into an Image Control on a Form within its Current() Event.