Stop macro using VBA

[accessman2]

hi,

how do I use VBA to stop the specific Macro running?

Which command I can use? Thanks.

 

[steevie_t]

Apart from using Sendkeys to send Ctrl+Break there isn't a command to explicitly stop a macro.

You could put a condition in the macro that calls a VBA Function that returns a global variable that you can set while the macro is running... But you might as well just use VBA in the first place.

In fact, just use VBA in the first place.

 

[RV]

Accessman2,

don't double post:

http://www.access-programmers.co.uk/forums/showthread.php?t=101699

RV