SetWarnings off

[phpatrick]

I have an insert into Statement behind my form, after running access show the dialog box "do you want to add ?"
How can I set the warnings off ?
This won't work DoCmd.SetWarnings -1

tkxs in advance, bye

 

[phpatrick]

DoCmd.SetWarnings False,

don't know why, but now it works

 

[PHV]

don't know why
Because -1 = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ed2020]

I suggest using CurrentDB.Execute to run action queries, rather than DoCmd.RunSQL or DoCmd.OpenQuery. It requires fewer lines of code (as you don't have to turn warning messages off first) and also provides for greater flexibility for transaction processing and displaying of error messages.

Ed Metcalfe.

Please do not feed the trolls.....

 

[Melagan]

DoCmd.SetWarnings [COLOR=red]0[/color]

~Melagan
______
"It's never too late to become what you might have been.