outputottext directory/filename

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

Guest

Hi,

I have a report that I outputtotext for conversion with a PERL script running through a MS-Dos batch file.

When I run this report, Access asks me for an encoding method for saving the file. As the default encoding is fine, can I suppress this message?

Also, and I'm embarrased to be asking this as I should know it, how do I change the output filename/directory? I want to hard code these so the report is always in the same location with the same name for running the batch script against. Also, not being prompted to overwrite an existing file (I will always want to) would be good...

Thanks in advance,
Mike
 
Mike:

Take a look at the Visual Basic OutputTo method as discussed in the help
file. You can also use the TransferText method. Either will accept a file
name to send the data to. If there is an existing file, there's two
methods to deal with that, either before you call either of the above
methods call the Kill statement providing the file name (to delete the file)
or use the FileCopy method, outputting the file to a unique name and calling
file copy to overwrite the target file, last calling Kill to delete the
unique file you just output.
 
Back
Top