SetWarnings BOONER 25.09.2006 16:01:03 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.

Re: SetWarnings Steve Schapel <schapel[ at ]mvps.org.ns> 25.09.2006 18:25:03 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. -- Steve Schapel, Microsoft Access MVP BOONER wrote: [Quoted Text] > 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.

Re: SetWarnings BOONER 25.09.2006 20:42:02 Thanks, "Steve Schapel" wrote: [Quoted Text] > 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. > > -- > Steve Schapel, Microsoft Access MVP > > BOONER wrote: > > 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. >