update, insert

[mikela]

Hello,

everytime my program does an insert or an update, it appears a pop up
warning, saying, 1 row will be updated, you won't be able to do a rollback...

or something like this, then I have to press yes everytime.

Is there any way to take that off??? As it is very annoying for the
customer....

Thank you in advance!

 

[Douglas J. Steele]

Presumably you're running a query that's doing the insert or update?

Either put DoCmd.SetWarnings Off before you run the query (and
DoCmd.SetWarnings On after), or use the Execute method of the database or
QueryDef object.

If you need more information, post back showing exactly what code you're
running that's causing the messages.