<div>
ok - I have worked out a way ... using the following code, where rs is a valid recordset object &nbsp;<br />
<br />
&nbsp; &nbsp; Dim vFieldNames()<br />
&nbsp; &nbsp; Dim i<br />
&nbsp; &nbsp; i = 0<br />
&nbsp; &nbsp; ReDim vFieldNames(rs.Fields.Coun<wbr />t, 1)<br />
&nbsp; &nbsp; For i = 0 To rs.Fields.Count - 1<br />
&nbsp; &nbsp; &nbsp; &nbsp; arr(i, 0) = rs.Fields(i).Name<br />
&nbsp; &nbsp; &nbsp; &nbsp; arr(i, 1) = rs.Fields(i).Value<br />
&nbsp; &nbsp; Next i<br />
<br />

</div>


ok - I have worked out a way ... using the following code, where rs is a valid recordset object  

    Dim vFieldNames()
    Dim i
    i = 0
    ReDim vFieldNames(rs.Fields.Count, 1)
    For i = 0 To rs.Fields.Count - 1
        arr(i, 0) = rs.Fields(i).Name
        arr(i, 1) = rs.Fields(i).Value
    Next i



<div>
DanRollins - I answered my own question - please set to zero points and leave in tact for others to view (I couldnt find an answer on this topic)<br />
<br />
MTIA<br />
<br />
Darrin
</div>


DanRollins - I answered my own question - please set to zero points and leave in tact for others to view (I couldnt find an answer on this topic)

MTIA

Darrin

<div>
<div class="content wysiwyg-content">
Hi all<br />
<br />
I need to get fieldnames and values into an array so I can cycle through them - I know I can get the recordset values into an array using GetRows<br />
<br />
dim arr()<br />
arr = rs.getrows(rs.recordcount)<wbr /><br />
<br />
But that doesnt get the field names. &nbsp;What I would like to do is get the fieldname, and the fieldvalue, and place it into an array which I can reference in a for ... next statement getting the fieldname and value at the same time<br />
<br />
I am not very good with arrays so commented coded answers would be appreciated<br />
<br />
MTIA<br />
<br />
Darrin<br />
<br />

</div>
</div>


Hi all

I need to get fieldnames and values into an array so I can cycle through them - I know I can get the recordset values into an array using GetRows

dim arr()
arr = rs.getrows(rs.recordcount)

But that doesnt get the field names.  What I would like to do is get the fieldname, and the fieldvalue, and place it into an array which I can reference in a for ... next statement getting the fieldname and value at the same time

I am not very good with arrays so commented coded answers would be appreciated

MTIA

Darrin



URGENT : Getrows with Fieldnames

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.