count loops

[boomtap via AccessMonster.com]

Is there a way to have a macro count how many times it loops?

 

[Steve Schapel]

Boomtap,

Yes. You can put an unbound textbox on a form, and within each "loop"
you can use a SetValue action in the macro...
Item: [NameOfTextbox]
Expression: [NameOfTextbox]+1

Note that the RunMacro action has a Repeat Count argument that you can
use to control the number of iterations, or a Repeat Expression argument
that you can use to determine when it stops.

 

[boomtap via AccessMonster.com]

Worked great Steve. Thanks!

Boomtap,

Yes. You can put an unbound textbox on a form, and within each "loop"
you can use a SetValue action in the macro...
Item: [NameOfTextbox]
Expression: [NameOfTextbox]+1

Note that the RunMacro action has a Repeat Count argument that you can
use to control the number of iterations, or a Repeat Expression argument
that you can use to determine when it stops.

Is there a way to have a macro count how many times it loops?