SetWarnings not Turning Warnings back on

[bhujanga]

I often have vba code that runs action queries and I want the warnings temporarily suppressed during their execution, so pretty much the standard usage for the SetWarnings method.
So at the beginning I put in:
DoCmd.SetWarnings (WarningsOff)
And at the end I put in
DoCmd.SetWarnings (WarningsOn)

Sometimes this seems to work, but most of the time the warnings stay off, which gives me problems. Does anyone know why this doesn't function? In fact, it might be that the only time it works right is if it's in a macro instead of code I find it suspicious that it doesn't automatically capitalize warningson and warningsoff, like the editor doesn't recognize them as special words.

 

[MajP]

There is no such constants as WarningsOn and WarningsOff. It is a parameter for you to pass TRUE or FALSE. The reason is works some of the time is that it is evaluating "warningsOff" to something other than -1 (true). It does not comeback on because "warningson" will resolve to something other than TRUE.

 

[MajP]

BTW google "option explicit". If you require variable declaration this would have not been a problem. When you tried to run the code it would have told you that "warningson" is an undeclared variable. In other words it thinks warningson is variant variable.

 

[bhujanga]

That makes sense. So I should just be able to put True or False, or 0 or -1 in there as the case may be. Thanks.