DoCmd.SetWarnings

[B F Cole]

I use the DoCmd.SetWarnings False before running append and update queries
to suspend the warning messages that the user sees followed by
DoCmd.SetWarnings True to resume the screen messages. This also suspends
the duplicate record error message, which is useful to know. Is there a way
to trap all of these messages while SetWarnings False is active and write
them to a MessageLog table for later review?

Thanks for your suggestions,
Bill