I guess it is not possible?

[OverDrive]

I would like to create a command button that will allow a user to insert a different picture per record into a form for all his employees without going into design mode.

"Short Term Explanation"

I would like to create a command button that will give me access to my files on my hard drive to choose a picture to insert into a calculated control (image control). This way, the person using the database would not have to have access to design mode to be able to do this function every time he wants to add or change a new employees picture.

Anyone?
Thanks
OverDrive

 

[braindead2]

If you have the field set as an ole object or a hyperlink to the picture You should not have to be in design view to add the picture. All you need to do is right click on the field that holds the ole object and on the popup menu it will give the option to insert object
if you want a button I think something like

me.youroleobjectfield.setfocus
docmd.runcommand accmdinsertobject 'or acCmdinserthyperlink

should work

 

[OverDrive]

Thank you so much . . . THATS IT!

I appreciate the time and effort you put into giving me these answers!

Thanks Man!
Chance~