[AccessD] Macro & Missing data

I was afraid that was going to be the answer.  I'm the second person to have
inherited this from the person who originally wrote it.  I guess I dig in
and see what I can do with it.

Thanks,
David

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, April 22, 2013 4:13 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Macro & Missing data

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
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com