<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Do your forms inherit from some master, or do you
have to implant this logic? I.e. can we create form classes and inherit from
them? And with them, their constituent control logic/instances?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Obviously I haven't investigated this stuff much or
I would know the answer :-)</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=jcolby@colbyconsulting.com
href="mailto:jcolby@colbyconsulting.com">John W. Colby</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, February 03, 2003 7:04
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Standard vs. Class
Module</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff size=2>A
module is simply a container for code, nothing more. A module can
contain global variables, local variables, functions, subs etc. In the
end however, it is just a container full of code.</FONT></SPAN></DIV>
<DIV><SPAN class=025175323-03022003></SPAN><SPAN
class=025175323-03022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff size=2>A
class module defines a class, and holds code and variables that implement the
methods and properties of that class. A class is a template for an
object and an instance of that object (class) will be loaded when you set a
variable = to that class. in other words.</FONT></SPAN></DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff size=2>dim
lMyClass as MyClass</FONT></SPAN></DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff
size=2> set lMyClass = new MyClass</FONT></SPAN></DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff size=2>You
use classes to create an object which will load into memory and do
something. </FONT></SPAN></DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff size=2>In
my framework I have classes for each type of control that Access
provides. One of my classes is for text boxes. Whenever a text box
is opened on my forms, I load a class and pass a pointer to the text box that
just opened. The text box class can now implement behaviors for that
specific text box that "belongs to it" (or v.v.). For example whenever
the text box gets the focus, I can cause the background to change
colors. Or I could compute a value based on the value it already
contains * the value of some other control. </FONT></SPAN></DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=025175323-03022003><FONT face=Arial color=#0000ff size=2>So a
class contains the code for an object. When you dimension a variable of
type (whatever your class name is) and then set the variable, you load an
instance of the class. You can have just one, or a hundred instances of
your class. When my forms load, I have an instance of my text box class
for every text box on my forms. </FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>On Behalf Of </B>Myke
Myers<BR><B>Sent:</B> Monday, February 03, 2003 6:44 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Standard vs. Class
Module<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=859564123-03022003>Can anyone
describe how to determine when to use a standard module and when to use a
class module in Access?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=859564123-03022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=859564123-03022003>TIA Myke</SPAN></FONT></DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>