C
Cory
In an effort to cut down on the insane amount of time it is taking to conduct
a large number of queries on an approxiamately 6000-8000 record database, I
have created a recordset that represents some common criteria between a
number of the queries so that I can requery from it in a loop and expect
faster results.
What I want to do is run a For Loop that executes a DCount that uses the
recordset as a domain. What happens however is that it always returns "Type
Mismatch". I have tried puting the recordset in quotes (in a vain attempt to
make peace with the offending method) which only resulted in "Jet Database
cannot find a Table named rcFacilityRecSet."
I need a way to get a record count of the records matching a subset of the
Recordset. I am...getting a little frustrated.
Cory
a large number of queries on an approxiamately 6000-8000 record database, I
have created a recordset that represents some common criteria between a
number of the queries so that I can requery from it in a loop and expect
faster results.
What I want to do is run a For Loop that executes a DCount that uses the
recordset as a domain. What happens however is that it always returns "Type
Mismatch". I have tried puting the recordset in quotes (in a vain attempt to
make peace with the offending method) which only resulted in "Jet Database
cannot find a Table named rcFacilityRecSet."
I need a way to get a record count of the records matching a subset of the
Recordset. I am...getting a little frustrated.
Cory