ACCESS FEED: RE: [MS_AccessPros] Closing rst's and setting = Nothing etc.

Selasa, 25 Oktober 2011

RE: [MS_AccessPros] Closing rst's and setting = Nothing etc.

Connie-

You can set = Nothing (which will also close them if open), but if you try to
.Close a recordset that is not open, you will get an error.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Tuesday, October 25, 2011 7:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Closing rst's and setting = Nothing etc.

In an event several recordsets are created. Some of them are not used in
certain instances where the sub exits because of conditions. In the Exit
Procedure Can I close and set = Nothing all the recordsets that were created at
the beginning even though they were not set to anything?

Thanks!
Connie

------------------------------------

Yahoo! Groups Links