<div>
yes i took that from the watch so five fields from 0 to 4, the field count wont change
</div>


yes i took that from the watch so five fields from 0 to 4, the field count wont change

<div>
<div class="content wysiwyg-content">
I changed some code to use the getrows method and my array is populated<br />
<br />
I am not sure how to traverse the array.<br />
<br />
Watch : - : arrTmp : &nbsp;: Variant/Variant(0 to 4, 0 to 0) <br />
<br />
ive historically used <br />
For index = LBound(arrTmp) To UBound(arrTmp)<br />
<br />
but the array has four fields now from the recordset of which there was only one row I am not sure how to set the indexing to only traverse the rows and not the fields
</div>
</div>


I changed some code to use the getrows method and my array is populated

I am not sure how to traverse the array.

Watch : - : arrTmp :  : Variant/Variant(0 to 4, 0 to 0) 

ive historically used 
For index = LBound(arrTmp) To UBound(arrTmp)

but the array has four fields now from the recordset of which there was only one row I am not sure how to set the indexing to only traverse the rows and not the fields

how to move through recordset in vba

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.