How Can I Transfer report to txt file

[goni07]

I have make report but my printer print file just .inp or txt
how can I transfer from report to .txt or .inp

 

[John Big Booty]

Re: How Can I Transfer raport to txt file

Have a look at the DoDmd.OutputTo method, see also this link.

It's going to look something like;

DoCmd.OutputTo acOutputReport, "YourReportName, acFormatTXT, "YourOutPutFileName.txt"

 

[goni07]

Re: How Can I Transfer raport to txt file

thank you very much it funksionirt very good but I will this text file tu save in Folder
ex. filepath = "C:\Temp but i dont know how
can you help me how to save this text file
thank you

 

[John Big Booty]

use;

DoCmd.OutputTo acOutputReport, "YourReportName", acFormatTXT, "C:\Temp\YourOutPutFileName.txt"

 

[goni07]

thank you very much
it work excellent
thank