Look for "not-closed" SETs in the code

  • Thread starter Thread starter Miha Abrahamsberg
  • Start date Start date
M

Miha Abrahamsberg

Hello!

Is there any way (without reading thru all the code) to check, if I have any
"sets" (SET recordset, form or any other object ...) open?

By open I mean that there is no ".close" and " = nothing" in the VBA code
after setting the object.

I often get an error when opening a form (ms access error: 2004 not enough
memory) and maybe it's because of the above...

Thank you in advance!

Miha Abrahamsberg
 
I don't believe there's any way other than going through your code
line-by-line.
 
Back
Top