Browse for directory (not file)

[Guest]

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!

 

[Marshall Barton]

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

 

[Guest]

Works great! Thanks!

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