countyworker
asked on
question about do while loop?
What's the correct coding when you have a access table you want to loop thru each record to do processing and then after it has processed the last record exits the loop
for example pseudo code:
bring table to workspace
go to first record
do while not end of table
processing stuff here for each record-queries and etc.
move to next record coding here if needed
loop
thanks
for example pseudo code:
bring table to workspace
go to first record
do while not end of table
processing stuff here for each record-queries and etc.
move to next record coding here if needed
loop
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use of course the do while ... loop function. BUT this loop cost a lot of time. The fastest way to go trough each record is the FOR ... to ... Step ... Next function and a record.movenext.
countyworker:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
Experts: Post your closing recommendations! Who deserves points here?
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
Experts: Post your closing recommendations! Who deserves points here?
Moderator, my recommended disposition is:
Split points between: rdrunner and Arthur_Wood
DanRollins -- EE database cleanup volunteer
Split points between: rdrunner and Arthur_Wood
DanRollins -- EE database cleanup volunteer
*mental note taken...*