How do I get a browse dialog box

[CJKCyclone]

to pop up?

Access 2000

We have a form where we can type a path to a database file. We'd like to have the functionality to click on a button that says "browse" and have a browse dialog box pop up. Any ideas?

TIA

 

[Jack Cowley]

If you have the Developers Edition of Access then you have the Common Dialog Active X control, which is what you are looking for... I believe that you can use some API calls to open the Windows common dialog but that is beyond my capabilities...

Jack

 

[bradcccs]

Demo I found kicking around some time ago.

Do not know who to credit for the code, as it has no comment entries.

If you struggle to decipher it, let me know.

Brad.

 

[ghudson]

Check these API's out...

API: Call the standard Windows File Open/Save dialog box

API: BrowseFolder Dialog

HTH

 

[cliff7376]

I am using the API code that is in this post to bring up the open/save windowand It works great. The only question I have is this. Is there a function in the code that will allow me to get the path to the file they want to choose. What I am trying to do is get that path and then copy the file from that path to a network share. After that I plan on linking the network share path to that record so everyone can view it.

Thanks
Sean

 

[cliff7376]

nevermind. My mind is out of it today. Sorry