Click OLE Object & Bring up OpenDialogBox to browse for files

[nandhabiwat]

I want to be able to allow the users to double click at a Bound Object Frame on a form and then bring up a dialog box for browsing the graphic file to be stored on DB

So my question really is whether ACCESS can called up an openDialogbox?

Thanks a lot in advance for valuable advice.

 

[llkhoutx]

Yes, search for the "Common dialog" and you'll find the code. Note that A97 common dialog code is different from A2K and later.

 

[Mile-O]

I posted two examples (one using Windows and one using the Common Dialog box) on a thread called Browse button for an Input Box (or something like that). It was posted by kupe in the Modules & VBA forum.

You'll find it quite easily with the Search function.

 

[llkhoutx]

M-O-P: You've got a good memory, or are posters famous or infamous?

 

[nandhabiwat]

Thanks a lot folks

You guys are my lifesavers. I really do appreciate your advices. Thanks a lot once again. I give you guy 5 Thumbs Up!

 

[Mile-O]

M-O-P: You've got a good memory, or are posters famous or infamous?

I can remember most posts that I participate in; especially those with people I see posting on a regular basis.