V
vcsphx
All, I am running into a strange issue that I have never seen before. I have
a recordset that gets it's data from a server and I am looping through the
recordset (using Do...Loop) to do few calculations. The problem is the
looping is working fine until it reaches certain point (in one case,
irrespective of what filter I use, VBA gets frozen at the 41st row when it
gets to the movenext line and in other case, it gets stuck when I started
looking at "December" month data). I am using the DAO recordset and I have
done similar looping before but this is the first time I am running into this
issue. Do you see why and how it can be fixed? Any help is appreciated!
Thanks!
a recordset that gets it's data from a server and I am looping through the
recordset (using Do...Loop) to do few calculations. The problem is the
looping is working fine until it reaches certain point (in one case,
irrespective of what filter I use, VBA gets frozen at the 41st row when it
gets to the movenext line and in other case, it gets stuck when I started
looking at "December" month data). I am using the DAO recordset and I have
done similar looping before but this is the first time I am running into this
issue. Do you see why and how it can be fixed? Any help is appreciated!
Thanks!