Is a folder browsing mechanism possible in Access?

[JC10001]

Hello everyone. Here is what I would like to do.

Right now I have a form that outputs a csv file (which the user names) to a certain folder called 'output'.

What I would like to do is allow the user to specify the location of the file in case they don't want to put it in the output folder. Now I know that I could ask the users to type in the entire file paths and it would work that way but it wouldn't be very convenient.

I am wondering if it's possible to add a "browse" button to a form that would bring up the same kind of box that you see in most programs. This way the user could go to the specified folder and save the document there.

So is this possible? I have searched but I have not been able to find anything. If anyone could be so kind as to provide me a link to information on how to do this I would really appreciate it. A brief explanation would also suffice.

Thanks.

 

[Rich]

Have you searched in the SampleDatabases page, there's an example posted there?

 

[ghudson]

If you had searched this forum for "browse" then you would have found many threads with suggestions and samples for what you are seeking.

Check out these APIs for calling the standard windows "File Open" and "Browse Folder" using VBA...

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm

API: BrowseFolder Dialog
http://www.mvps.org/access/api/api0002.htm

HTH

 

[bradcccs]

At least you searched first


http://www.mvps.org/access/api/api0002.htm

Has been covered many times though. Your search must have been unlucky.