Crystal, Graham and John,
Thanks for you answer! I really appreciate all of you! In the future I will put it in the Error Procedure using your examples.
Connie
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar