PDA

View Full Version : Accessing records in Recorset



flowergirl
08-28-2011, 09:33 PM
I have a recordset which has 4 records. how can I access the records.

Say, I want to display the content of the second record in cell B3.

Thanks for your help.

Bob Phillips
08-29-2011, 03:05 AM
ary = RS.GetRows
Range("B3").Value = ary(2,1)

flowergirl
09-05-2011, 12:35 AM
Thanks a lot for your help