By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

VBA Access

P: 1
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.
Aug 16 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,669
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.
Aug 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.