[AccessD] Macro & Missing data

It's actually quite easy to convert a macro to VBA code. In fact, if your
macro is invoked from a form, say using a button, it's a no-brainer. On the
Database Tools ribbon there's a button to convert macros to Visual Basic.
(2007+)

HTH


On Mon, Apr 22, 2013 at 6:56 PM, David A. Gibson <
davidalangibson2010 at gmail.com> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr