John W. Colby
jcolby at colbyconsulting.com
Thu Mar 6 16:15:35 CST 2003
MessageFrom: Myke Myers [mailto:mmmtbig at bellsouth.net]
Sent: Wednesday, March 05, 2003 5:38 PM
To: 'accessd-admin at databaseadvisors.com'
Subject: Class Module Method in Loop
When I use a method of a class module in a loop, where should 'Set=' be? Or
should I be using a standard module for this kind of method?
Dim obj as clsTest
This:
Set obj = new clsTest
Do
obj.Method...
Loop
Set obj = nothing
or This:
Do
Set obj = new clsTest
obj.Method...
Set obj = nothing
Loop
TIA.
Myke
----------------------------------------------------------------------------
----
Is email taking over your day? Manage your time with eMailBoss. Try it free!
http://www.eMailBoss.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030306/c9e3b312/attachment.html>