Rows Method

Object List Next Object

Defined By: Recordset

Description:

Returns an object that represents the Rows (records) range beginning at start and having number of rows. The row range can consist of an arbitary number of columns.

Declaration:

Function Rows(ByVal start As Long,ByVal number As Long) As Dynaset

Details:

Rows values are zero-based, meaning that the first row or record in the underlying database is Row(0). Note that the two values are start column and number of columns, not start row to end row. The following code shows how to return the data in the first four rows.

Dim s As String

s = <RecordSet>.Rows(0,3).Value