I'll take a look at it. Thanks, Terry...
Evan
>>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,
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?