Temporarily interrupt macro

J

JoJoMom

One step in my macro runs a find duplicates query. I want to delete
duplicates then continue with the macro. I'm relatvely new to macros, so
nothing too complex please.
 
A

Arvin Meyer

JoJoMom said:
One step in my macro runs a find duplicates query. I want to delete
duplicates then continue with the macro. I'm relatvely new to macros, so
nothing too complex please.
Click to expand...

It might be simpler for you to just build 2 separate macros. Run the first,
delete your dupliccates, then run the second. There is no built-in capacity
to stop and resume a macro, so you'd need to do that with a modal form, and
possibly some VBA code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top