Browse for directory (not file)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

grossman - 20 Jan 2006 00:19 GMT

I'm creating export functionality. The names of the exported files are set. I
do, however, want the user to specify the directory where the file should be
saved. How do I create a control that will allow the user to select only the
directory where the file should be saved?

BTW...I'm an Access novice.

Thanks!

Reply to this Message

Marshall Barton - 20 Jan 2006 00:56 GMT

>I'm creating export functionality. The names of the exported files are set. I
>do, however, want the user to specify the directory where the file should be
>saved. How do I create a control that will allow the user to select only the
>directory where the file should be saved?

This may be rather intimidating, but it's so well tested
that you can just Copy/Paste into a new Standard module and
use it as the example shows.
http://www.mvps.org/access/api/api0002.htm

Signature

Marsh
MVP [MS Access]

Reply to this Message

grossman - 20 Jan 2006 19:49 GMT

Works great! Thanks!

> >I'm creating export functionality. The names of the exported files are set. I
> >do, however, want the user to specify the directory where the file should be
[quoted text clipped - 5 lines]
> use it as the example shows.
> http://www.mvps.org/access/api/api0002.htm

Reply to this Message