Save Report as a .bat

[The Boondock Saint]

Is there a way I could have a button on a form, which saves a report into a
..bat file?

or even if it could save it as a .txt file cause i can automate a task to
rename the bat file before i run it.

Cheers Saint

 

[The Boondock Saint]

Ive got it working in a Module

With
Sub exporttxt()
DoCmd.OutputTo acReport, "Thumbnail Query", acFormatTXT, "prothumb.bat",
False
End Sub

But how can i get a button to run that command?

 

[John Vinson]

Ive got it working in a Module

With
Sub exporttxt()
DoCmd.OutputTo acReport, "Thumbnail Query", acFormatTXT, "prothumb.bat",
False
End Sub

But how can i get a button to run that command?

Put the code into the Click event of the button.


John W. Vinson[MVP]

 

[TC]

You do realize that the content of the .bat file will have to be MS-DOS
batch commands?

Is that what you get from the query? MS-DOS batch commands?

TC (MVP Access)
http://tc2.atspace.com