Stuart McLachlan
stuart at lexacorp.com.pg
Mon Apr 22 16:12:37 CDT 2013
Do it in VBA instead of using macros. Then you can trap and log any errors. -- Stuart On 22 Apr 2013 at 16:00, David A Gibson wrote: > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >