runmacro stops at 20

G

Guest

I am running a macro within a macro and it stops after running 20 times but i have a recordset of more than that can i remove this default in macro so that it can run unlimited or to a given limit more than 20?
 
T

tina

i could find no reference in Access Help to a limit on the number of repeats
allowed. so i tested a RunMacro action with various RepeatCount values up to
10,000 - and it repeated the specificed number of times on every test.
are you getting an error message when the macro stops, and if so, what? if
you're not getting an error message, how are you verifying that the macro
did not run the specified number of times?
are you looping thru a table or recordset to update certain field values in
certain (or all) records? if so, you might find it faster/easier to use an
Update query instead.

hth


imbackd said:
I am running a macro within a macro and it stops after running 20 times
but i have a recordset of more than that can i remove this default in macro
so that it can run unlimited or to a given limit more than 20?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top