SetWarnings

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

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.
 
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.
 
Thanks,


Steve Schapel said:
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.
Click to expand...
 
Back
Top