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.
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.
[vba]
ary = RS.GetRows
Range("B3").Value = ary(2,1)
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks a lot for your help