DoCmd.OutputTo question

[Jeff]

Hello,

I am using DoCmd.OutputTo & it works find. What I would like to know, is
when it brings up the standard Dialog box for the user to choose the Drive &
Directory the user is exporting to, is their any way to track (save) what
path the user chose ?

Any help would be greatly appreciated.

Thank you,
Jeff

 

[Dirk Goldgar]

Hello,

I am using DoCmd.OutputTo & it works find. What I would like to
know, is when it brings up the standard Dialog box for the user to
choose the Drive & Directory the user is exporting to, is their any
way to track (save) what path the user chose ?

I don't think so. If you really need to do that, you could implement
your own version of the OutputTo feature, calling the Windows API to
displaying the BrowseFolder or File Open/Save dialog using code like
that posted at:

www.mvps.org/access/api/api0001.htm
www.mvps.org/access/api/api0002.htm

and then calling either DoCmd.OutputTo or one of the DoCmd.Transfer...
methods to output the object, providing the folder path or file name the
user has chosen.