Running Multi-Iteration Loops

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to write a loop that runs about 70,000 times. I know this is
big, and I expect it to take a while. But for some reason, my Access has
trouble running loops bigger than 9 iterations, I get a message that says
"subscript out of range" and the loop truncates at 9. Right now I am using a
do...while loop. Any ideas as to why I am prohibited from running large
loops, or how I can fix this? Thank you.
 
j said:
Hi,

I am trying to write a loop that runs about 70,000 times. I know this
is big, and I expect it to take a while. But for some reason, my
Access has trouble running loops bigger than 9 iterations, I get a
message that says "subscript out of range" and the loop truncates at
9. Right now I am using a do...while loop. Any ideas as to why I am
prohibited from running large loops, or how I can fix this? Thank you.
Click to expand...

I suppose we'd have to see your code that is doing the loop. My hunch is that
you are doing something incorrect.
 
You must log in or register to reply here.

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

Similar Threads

Loop Limits Question 7
Ground loop isolator causes loss of audio signal 9
How to write an array to a range without looping 3
multi dimensional array problem with redim 4
Problem with a loop and column references 27
iterators (pointers) 5
Selecting different Worksheets from a Loop 4
for loop question 1

Back
Top