On Sun, 12 Nov 2006 17:19:11 GMT, "rdemyan via AccessMonster.com"
<u6836@uwewrote:
I was hoping you would find the Close method yourself ;-)
While CurrentDb.Recordsets.Count 0
CurrentDb.Recordsets(0).Close
Wend
Note that this code is better than:
For i = 0 to CurrentDb.RecordSets.Count -1
or similar constructs, because the Count will change each time you go
through the loop.
-Tom.
>Tom:
So if I get this collection, I'm not clear how I can loop through the
collection and close any open recordsets. Can you provide some code to get
me started.
Thanks.
Tom van Stiphout wrote:
>>CurrentDB.Recordsets has the collection of open recordsets.
-Tom.
>>>Can someone help me with creating code that will look for DAO recordsets in
modules and then check to see if the recordset is also closed in the module.
[quoted text clipped - 3 lines]
>>>
Thanks.