DoCmd.OutputTo question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Jeff said:
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 ?
Click to expand...

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.
 
Back
Top