Recent content by AussGrid

  1. A

    VBA error (3201 no Current Record)

    Well I'm cheating a bit as really this is really being designed for Excel but I've found no solutionson nested queries like this anywhere. The procedure I'm trying to carry out is pretty simple in theory, looping through the recordset and grouping result so that when the value in a field...
  2. A

    VBA error (3201 no Current Record)

    Spikepl, Still not loving the loops unfortunately; Currently I have: Do x=rs!x Do while rs!x=x and not rs.eof [Statements] rs.movenext Loop rs.movenext Loop but still returning the 3021. Have tried several variations on this but no success. Any...
  3. A

    VBA error (3201 no Current Record)

    LeagueOneDale, Having the same problem with almost identical coding, what did you change to get the loop to run without error? I have been using something along the lines of: Do While Not rs.eof x = rs!x Do While rs!= x and Not rs.eof rs.MoveNext Loop rs.MoveNext Loop Cheers,
Top Bottom