query prompts

  • Thread starter Thread starter SPM2
  • Start date Start date
S

SPM2

I have a query that needs to run , The problem is with the prompts. I've
turned of all the prompts in the tools->options->edit/find page but it still
asks for deletion confirmation...is there any way round this? I want it to
do the delete without prompting the user.

Thanks
 
Try this ...

DoCmd.SetWarnings False
<your code to run query>
DoCmd.SetWarnings True
 
That worked fine.
Thanks

Try this ...

DoCmd.SetWarnings False
<your code to run query>
DoCmd.SetWarnings True
 
Back
Top