I have an application in ACCESS 2003 that runs a macro that needs to be iterated more than 20 times in some occasions. In those cases appears a sign that states that a macro cannot be called by itself more than 20 times. Is there any simple way to override this obstacle, since I don't know VBasic?
Iterate a macro more than 20 times (1 Viewer)
- Thread starter jcsuarez
- Start date
Ranman256
Well-known member
- Local time
- Today, 01:39
- Joined
- Apr 9, 2015
- Messages
- 4,339
can you use a macro, to run a macro,
command: RUN MACRO
and set the REPEAT COUNT = 40 (or your #)
(no VB needed)
but if you want VB, make a form with a text box to put the repeat #:
command: RUN MACRO
and set the REPEAT COUNT = 40 (or your #)
(no VB needed)
but if you want VB, make a form with a text box to put the repeat #:
Code:
for i = 1 to txtBox
docmd.RunMacro "mMyMacro"
next
Last edited:
