Macro SetWarnings (Access 2003) not working

  • Thread starter Thread starter JellyShredder
  • Start date Start date
J

JellyShredder

I've seen the answer in this community but they don't seem to work. Am I
missing something?
Access 2003
My macro runs a Beep; Message; SetWarnings "No"; OutputTo Excel (to
overwrite existing file of same name); there are 20 lines of "OutputTo" for
each different query; SetWarnings "Yes"; Beep; Message.
I still get prompted 20 times "Yes/No" to overwrite.
Thanks in advance :^)
 
Back
Top