>Never mind, gang -- I'm backwards. It's .BOF and .EOF I need, not Fields(x).Value. Sorry...it's been a long day. Disregard...
There's some stuff in download #
9840 that might be helpful.
>
>
>
>>Hi folks,
>>
>>Anybody know, right off the top of the noggin, how to count the rows in an ADO recordset returned as the result of a SQL statement sent through the Command object?
>>
>>RecordCount is always -1, so that won't work. Spinning through the RS blows an error as soon as you hit a value of x for Fields(x).Value that doesn't exist.
>>
>>Better yet, can I pass SQL a parameter with the Command object that says "client-side cursor" the same way I can with a Recordset object?
>>
>>I need this one quick, gang...
>>
>>TIA,
Imagination is more important than knowledge