Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Running Multi-Iteration Loops

Discussion in 'Information Technology' started by j, Jul 28, 2006.

  1. j

    j
    Expand Collapse
    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.
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    j wrote:
    > 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.


    I suppose we'd have to see your code that is doing the loop. My hunch is that
    you are doing something incorrect.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page