Common Dialog Control?

[andm]

Hi,

I'd like to give the user the ability to choose their own file. I know that it's called a "Common Dialog Control" in Visual Basic, but I'm wondering how to create the same behavior in Access?

I want the user to click on a button that will give them access to all the files on their computer (like when in Explorer). Then they click on the file that they want to download...and the rest I can do from there.

Thank you!!
Andrea

 

[chrismcbride]

You can set a reference to the Windows Common Dialog control in Tools/ Refernces. This must be done while you have a code module open. Also you must have a licence to use the control. The only way I know for sure how to get this licence is to install VB onto the development machine. Users can access the Dialog control without the licence, you just can't deploy it.
There are a few helpful postings on this bulletin board, if you try a Search.
HTH
Chris

 

[Fornatian]

Send me an e-mail and I'll send you an example database that uses code behind buttons to run a fileopen dialog and then return the filename to a specified form field.

Ian