Why won't warnings turn off

[Savil]

Hi all
Acc 97
On the beforeupdate event for a form the code checks for form completeness, no problem. If the form is not complete then the line "cancel = true" is actioned. You then get the message that you have canceled an event blah blah which is very annoying so I changed the cancel line to

docmd.setwarnings false
cancel = true
docmd.setwarnings true

The message still comes up. How can I get rid of it?

 

[smedvid]

Perhaps something like this.. I place in a form open event
Public gcCurrentNode As MSComctlLib.node
Public gcOriginalOptionState As Boolean
'Set Confirm Changes to True - Used for Deletes
gcOriginalOptionState = Application.GetOption("Confirm Record Changes")
Application.SetOption "Confirm Record Changes", True

Then on Unload, I reset the option using the global variable gcOriginalOptionState which I created...
'Reset Option for MS Access to Original Setting
Application.SetOption "Confirm Record Changes", gcOriginalOptionState

htwh???


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Savil]

Thanks for your reply but this is not applicable to Access 97

 

[payback]

Do you get the same error with "DoCmd.CancelEvent" ?

 

[kjv1611]

I believe that the setwarnings method does not turn off the message you are referring to. I think that only turns off messages such as "you are about to paste 42 records to table xyz. Do you want to continue?" The message you are trying to get rid of has to be handled separately.

Have you tried using an Error Handler to trap that error message?

First, do a test with a message box to show what the error number is, then edit the error handler to just do nothing if it produces the specific error you are getting..

I am fairly certain this will work. If you try it, let me know if it did.