Getting query error

[Oded Kovach]

Hello there

I have a mdb with many action quries

In order to prevent the user from watching the messages of (you are going to
add/delete/modify XXX rows) i place docmd.setwanrnings FALSE before running
action query. But disabling the warnings also prevents me of getting errors
just like (0 rows added due to Null value)
Is there a way with code to know whether the query succesedded or not?

 

[Allen Browne]

Instead of turning SetWarnings off, use the Execute method:
dbEngine(0)(0).Execute strSQL, dbFailOnError

If you want to be able to roll-back, use a transaction.
Example at:
http://members.iinet.net.au/~allenbrowne/ser-37.html