I have used the setwarnings in the following manner.
Dim stDocName As String
DoCmd.SetWarnings (False)
stDocName = "qry Emp update"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SetWarnings (True)
the query used is an append query
This code works fine in both the original .MDB and .MDE databases but when I package either format and distribute in a runtime environment the warning messages are not supressed. The runtime version does not have the ability to change the settings under Tools\Options confirm changes\deletions\action querys. These options are turned off when I develop and package the program. Has anyone else had this problem? How can I stop these messages from appearing to the enduser.
Dim stDocName As String
DoCmd.SetWarnings (False)
stDocName = "qry Emp update"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SetWarnings (True)
the query used is an append query
This code works fine in both the original .MDB and .MDE databases but when I package either format and distribute in a runtime environment the warning messages are not supressed. The runtime version does not have the ability to change the settings under Tools\Options confirm changes\deletions\action querys. These options are turned off when I develop and package the program. Has anyone else had this problem? How can I stop these messages from appearing to the enduser.
