move to particular record number in recordset

goodrags · June 26th, 2006, 10:36 PM

Hello friends,

I need to move to a particular record number in a record set (for eg: 300th record in a recordset of 450 records) and then carryout certain calculations from the 300th record till the last record.How can this be achieved. (I am using dao 3.6 object library).
I tried the string find method but it did not work out. Any suggestions?
Thanx for the help

Raghavendra_Mudugal · June 27th, 2006, 06:34 AM

Hello,

try using
rs.AbsolutePosition = <record pointer long number>

When you set this the record pointer is positioned to the number what you assign
intenally, so you can say move next there to move the pointer to next record
like 300th to 301.

Hope this helps

With Regards,
Raghavendra Mudugal

BrianWren · June 27th, 2006, 03:03 PM

You can also use:

Code:

    rs.MoveFirst
    rs.Move 300

If you donât know which record you are after, and .Find doesnât work, and .Seek doesnât work, you can do it the hard way:

Code:

    rs.moveFirst

Code:

    Do While True
        If rs!TestField = TestValue Then Exit Do
        rs.MoveNext
        If rs.EOF then Exit Do
    Loop

(Pretty ugly, but sometimes you just need to grab a recordset by the throat and have your way with it...)

goodrags · June 27th, 2006, 09:11 PM

Thanx guys, the .absoluteposition did not work with dao3.6 error msg"this funtion not suported by the object".However the move first,move 300 and the subsequent suggestion of "catching the record by the throat" certainly helped.Thanx for helping out guys. Bye