A aman909 Registered User. Local time Today, 17:02 Joined Jun 20, 2007 Messages 28 Sep 17, 2007 #1 I have created a delete query and it works fine. When the query is run a message box appears asking if you wanna delete the records etc....? Is there a way to stop this message box from appearing?
I have created a delete query and it works fine. When the query is run a message box appears asking if you wanna delete the records etc....? Is there a way to stop this message box from appearing?
KenHigg Registered User Local time Today, 12:02 Joined Jun 9, 2004 Messages 13,327 Sep 17, 2007 #2 You should be able to use the 'Set Warnings' option using code or from a macro. Are you running it from code?
You should be able to use the 'Set Warnings' option using code or from a macro. Are you running it from code?
A aman909 Registered User. Local time Today, 17:02 Joined Jun 20, 2007 Messages 28 Sep 17, 2007 #3 From a macro
A aman909 Registered User. Local time Today, 17:02 Joined Jun 20, 2007 Messages 28 Sep 17, 2007 #4 KenHigg said: You should be able to use the 'Set Warnings' option using code or from a macro. Are you running it from code? Click to expand... running it form a macro. How do i stop the warnings from the macro then
KenHigg said: You should be able to use the 'Set Warnings' option using code or from a macro. Are you running it from code? Click to expand... running it form a macro. How do i stop the warnings from the macro then
KenHigg Registered User Local time Today, 12:02 Joined Jun 9, 2004 Messages 13,327 Sep 17, 2007 #5 With the 'Set Warnings' macro action. Be sure to turn them back on after you run the query
