passing data in multiple rows in a recordset

Hot Topic

Projects, objects & modules
Linking to an Oracle DB via MSAccess/VBA
Take out the ability to input values on combo box?
Copy an Excel File and Update some of it's cells
Using parts of a cell value as a variable?
Office Communicator 2005 sign-in name, auto populate after install somehow?
Loop causing MS Word freeze
SetSourcedata of pivotchart on a pivot table that changes
Place a CR in normal Text Box via vba
How can I connect to the Team Foundation server?

Microsoft ISV

Interactions with Outlook
Trying to create a global variable
SendKeys open application
Sending char to other windows controls
Registration Limits and Useage Rules
Userform Controls
creating hyperlink through vba
ado recordset problem
Recursive Function
Compatibility Issue Excel 2000 and Excel 2003

passing data in multiple rows in a recordset

I have a recordset that consit of 5 rows 6 columns. each column has a name. i would like to retrieve the second row in the recordset. I can read the first row, but I am lost as to read the second row in the recordset...

help!!




Answer this question

passing data in multiple rows in a recordset

  • lurch_man

    hi,

    there are a couple of Move methods that let you navigate the rows of a recordset, MoveFirst, MoveNext, MovePrevious, MoveLast and just Move. You need to be wary though as moving back and forward through a recordset using these methods will depend what kind of cursor the recordset was opened with, for example you can't call MoveFirst or MovePrevious if your recordset is using a forward only cursor.



  • passing data in multiple rows in a recordset
Answer this question