[AccessD] Macro & Missing data

I have / MS Access 2010 / Win 7 Pro 64-bit.  

I run a macro that has warnings turned off as it runs about forty queries.
I found out yesterday that some data is missing.  That's a bummer because I
was wanting a snapshot of the data on a particular day.  I can go and
retrieve the data but some changes may have been made.

Is there a way to know if there was an error without having warnings on and
having to click OK to each action query.

David Gibson