[moleiro]

Once I've run a "Do While Not RS.EOF ... Loop", how do I reset the cursor to BOF so I can run another loop later in my script?

[klewlis]

You can't.

At least, I've never found a way. You can either rerun the query, or store the Recordset in an array to use multiple times. :)

[Amadeus]

Probably a little late with the answer, but if you just want to get back to the start, you should just be able to use one of the Move commands. RS.MoveFirst would be the best one, or if supported, just an RS.Move(place number here). HTH!

[Fygar]

Yea, I'd say you want to use a MoveFirst for this case. That's what I use anyways...

[klewlis]

You use MoveFirst after looping through to EOF?

Cuz I'm pretty sure that doesn't work ;)

[Fygar]

Sure it does, unless I'm missing something in this topic...

Do Until Rs2.EOF
    Lots' of code....
    Rs2.MoveNext
Loop

Rs2.MoveFirst

Do Until Rs2.EOF
    Lots' of other code....
    Rs2.MoveNext
Loop

See, using .MoveFirst to get to the First record to begin a new loop....

[klewlis]

hm... that's weird. i've never been able to get it to work. i've always had to re-run the query...

[Amadeus]

Hmm....should work, unless the recordset has been closed, or something like that.

[Fygar]

What cursor type, lock, etc are you using?

[gheaven]

You need to use an adOpenKeyset results set. The default is adForwardOnly.