Encode File Message Box

[kruser]

Want to export queries to plain text files. Each time I do this I get a pop-up window asking me to indicate the file encoding, Windows Text, RTF, etc. This is fine, but I want to automate this process & not have to manually enter each time. How can I do this?

 

[thornmastr]

Do you want to export the query itself to a text file or the results of the query to a text file? Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[kruser]

I'm exporting the results of the query, but that's irrelevant. How can I automate my response to or, better, eliminate the pop-up?

 

[thornmastr]

The following works very nicely. Look up OutputTo for all the options/parameters.


Public Sub TestLaunchqry()

DoCmd.OutputTo acOutputQuery, "qry1", acFormatTXT, "C:\qry1.txt", False

End Sub
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[kruser]

This worked great! Thank you very much!!!!