SetWarnings

[Guest]

I am using an OutputTo macro in my AutoExec module. Is there any way to turn
off the prompt that asks if you want to replace the existing file? I have
DoCmd.SetWarnings False as my first statement; however, I am still prompted
to answer yes or no.

 

[Steve Schapel]

Booner,

As far as I know, no, this is not possible. The best you can do is to
remove the file first, using the Kill method, but this will need to be
within a VBA procedure rather than a macro.

 

[Guest]

Thanks,

Booner,

As far as I know, no, this is not possible. The best you can do is to
remove the file first, using the Kill method, but this will need to be
within a VBA procedure rather than a macro.