Export Report why always ask the pathway

[le888]

Hi,

I have export 3 reports to the same pathway (same folder) and I have programmed automatically. The code below works fine.

DoCmd.OutputTo acReport, stDocName1, acFormatTXT, "C:\Access\Tasks\project1.txt"

DoCmd.OutputTo acReport, stDocName2, acFormatTXT, "C:\Access\Tasks\project2.txt"

DoCmd.OutputTo acReport, stDocName3, acFormatTXT, "C:\Access\Tasks\project3.txt"

However, Access always asks the path way for the first output texte file and the two others export automatically to the same folder. I wonder if I can by pass the question and when I click on the button, it export automatically to the folder.

Thanks,

Le

 

[GohDiamond]

This may be a stab in the dark:
Perhaps if you turn off the warnings it will not ask you, but simply execute the code. See http://msdn2.microsoft.com/en-us/library/aa220747(office.11).aspx

DoCmd.SetWarnings False​

Don't forget to turn warnings back on after the code

DoCmd.SetWarnings True​

Let us know if that works for you,

Goh