POSITION of current row

[sal21]

I use

While Not RST.EOF

RST.MoveNext
'test=number actual row

Wend

during this loop is possible to know wath is the current line number row

[HansV]

Code: Select all

Dim lngRow As Long
RST.Open ...
lngRow = 0
Do While Not RST.EOF
    lngRow = lngRow + 1
    ....
    RST.MoveNext
Loop