EntireRow RecordSet

[mp3909]

Hi,



Is it possible to debug.print the entirerow of a recordset? i.e. I want to say print out the 15th row?

I managed to open up this table into a recordset in access VBA.

I know how to access each field but don't know how to print out the entirerow of a recordset.

Any help please?

Thanks

[orange]

Review https://msdn.microsoft.com/en-us/lib.../ff193530.aspx

The Fields collection of a Recordset object represents the Field objects in a row of data, or in a record. You use the Field objects in a Recordset object to read and to set values for the fields in the current record of the Recordset object.

To refer to a Field object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:

Fields(0)

[moke123]

the link orange posted will give you the background of the fields collection
and then to traverse it you can try something like this

For i = 0 To rs.Fields.Count - 1
Debug.Print rs.Fields(i).Name & " = " & rs.Fields(i)
Next i