<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Tahoma size=2><B>From:</B> Myke Myers
[mailto:mmmtbig@bellsouth.net] <BR><B>Sent:</B> Wednesday, March 05, 2003 5:38
PM<BR><B>To:</B> 'accessd-admin@databaseadvisors.com'<BR><B>Subject:</B> Class
Module Method in Loop<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=384463122-05032003>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?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=384463122-05032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=384463122-05032003>Dim obj as
clsTest</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=384463122-05032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=4><SPAN
class=384463122-05032003><STRONG>This:</STRONG></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=384463122-05032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=384463122-05032003>Set obj = new
clsTest</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=384463122-05032003>Do</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=384463122-05032003>
obj.Method...</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=384463122-05032003>Loop</SPAN></FONT></DIV>
<DIV><SPAN class=384463122-05032003><FONT face=Arial size=2>Set obj =
nothing</FONT></SPAN></DIV>
<DIV><SPAN class=384463122-05032003></SPAN><SPAN class=384463122-05032003><FONT
face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=384463122-05032003><FONT face=Arial size=4><STRONG>or
This:</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=384463122-05032003><FONT size=4><FONT size=2><SPAN
class=384463122-05032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=384463122-05032003>Do</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=384463122-05032003>
<DIV><FONT face=Arial size=2><SPAN class=384463122-05032003>
Set obj = new clsTest</SPAN></FONT></DIV><FONT face=Arial>
obj.Method...</FONT></SPAN></FONT></DIV><SPAN class=384463122-05032003>
<DIV><SPAN class=384463122-05032003><FONT face=Arial size=2>
Set obj = nothing</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2>Loop</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>T<SPAN
class=384463122-05032003>IA.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=384463122-05032003>Myke</SPAN></FONT></FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=384463122-05032003><FONT face=Arial
size=2></FONT></SPAN> </DIV></FONT></SPAN>
<DIV>
<HR>
</DIV>
<DIV>Is email taking over your day? Manage your time with eMailBoss. Try it
free! <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV></BODY></HTML>