How to create a button to automatically browse to replace file in tabl

[durwood]

I have a table that has an OLE object in one field. That file is a picture. I would like to create a command button on my form that will browse to a directory and when the file is selected automatically put it in this field for the current record.

 

[raskew]

Do you mean that you're storing a file path and name in the field?

 

[LonnieJohnson]

You can use the standard Windows Picture Insertion dialog box by the following code:

ObjectName.SetFocus
DoCmd.RunCommand acCmdInsertObject

Hope this helps...B-) ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[durwood]

Yes, I can browse for the picture file while entering data in the table, but I would like to simplify this process for the end user.