How to put 10th - 20th records into the Recordset

[markask]

Hi,

After connected a .mdb, how to put 10th - 20th records from a table into the Recordset? I don't think pagesize-absolutepage can do this.

Thank you in advance.

 

[johnwm]

If it must in a recordset object use GetRows and fabricate your own recordset

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[markask]

John,
Thank you.
After getrows, we got an array.....how to make my own recordset from the array?

 

[johnwm]

Do a search on this forum for 'fabricated recordset' as this has been discussed a number of times. You will find:
thread222-726943
thread222-556040

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[markask]

johnwm,

Thank you. That is an interesting option.

 

[duiji]

Would something like this help you out. It is not as fast as get rows but ............

lngRange = 11
lngEndRecord = 30


strSQL = "SELECT Top " & lngRange & " RecordID FROM Test WHERE RecordID IN (SELECT Top " & lngEndRecord & " RecordID FROM Test ORDER BY RecordID ASC) ORDER BY RecordID DESC"

RS.Open strSQL, CONN, adOpenStatic