Update queries

socoolbrewster · March 4th, 2004, 09:12 AM

I have created several updates queries for my database which at present when run Access issues a warning message. Is possible to disable these messages and create my own? And if so how?

Gaz

Andrew Antoniak · March 4th, 2004, 09:23 AM

You can use the DoCmd operator if you use code. From memory the syntax is "DoCmd Setwarnings.false" or something very similar. However you should remember at the end of your code to use "DoCmd Setwarnings.true"

BethMoffitt · March 4th, 2004, 10:03 AM

Before execution it would be:

Code:

DoCmd.SetWarnings False

and after the query use:

Code:

DoCmd.SetWarnings True

Beth M

socoolbrewster · March 4th, 2004, 11:57 AM

Thanks Beth your suggestion work.

Many thanks to everyone else also

Gaz

Steven · March 4th, 2004, 06:18 PM

Another option would be to use Execute instead of RunSQL

So you'd have something along the lines of:

Code:

CurrentDb.Execute("DELETE * FROM Table1 WHERE Field1='Something'")

rather than:

Code:

DoCmd.SetWarnings False
DoCmd.RunSQL ("DELETE * FROM Table1 WHERE Field1='Something'")
DoCmd.SetWarnings True

Diff'rent Strokes. It takes. Diff'rent Strokes. It takes. Diff'rent Strokes to move the world, yes it does

I am a loud man with a very large hat. This means I am in charge