Link to home
Start Free TrialLog in
Avatar of Lou Dufresne
Lou DufresneFlag for United States of America

asked on

MS Access 2013 - Macros - How to run a macro from start to finish.

I have written a macro that runs a series of queries and displays a message when the mactro ends. When i run the macro it stops at each query and then asks if it should run that query.

At one point I used to know the command that when placed in a macro the macro ran from start to fnish without stopping along the way. However i forgot that line of code.

Question: What command and syntax to add to the macro code to allow it to run from start to finish without stoping unless there is an error?

Question Part 2 : Can i usee this same Commenad and Syntax in Access 2013 VBA ?


Thanks for you asistance
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lou Dufresne

ASKER

Thanks everyone
    Together these answers are exactly what I needed.

Ldufresne