make table delete confirmation

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

Hello, I have a make table query in a cmd button that prompts me everytime
I use it. I tried calling a macro to set the warnings to no, but it's not
working for some reason. I have the warnings set to no and here is the code
I used to call it in the sub cmdUpdateRecord

DoCmd.RunMacro SetWarnings

Any help would be greatly appreciated!
 
Rather than calling the macro, use

DoCmd.SetWarnings False

before you run the rest of your code, and

DoCmd.SetWarnings True

after
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setwarnings - message suppression 1
Macro with make table 1
DoCmd.RunMacro action fails in Access 2007 0
Turning off action query confirmation messages 1
How do I delete a record based on a user enetered string value 1
SetWarnings - Can't find 1
SetWarnings 9
Macro SetWarnings (Access 2003) not working 2

Back
Top