[AccessD] Standard vs. Class Module

Thanks for an explanation of how you use class module. I had never
considered having a class for each control.
Do you recommend using class modules for all code?
 
Thanks,
Myke

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Monday, February 03, 2003 7:05 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Standard vs. Class Module


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.
 
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.
 
dim lMyClass as MyClass
   set lMyClass = new MyClass
 
You use classes to create an object which will load into memory and do
something.  
 
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.  
 
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.  

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Myke Myers
Sent: Monday, February 03, 2003 6:44 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Standard vs. Class Module


Can anyone describe how to determine when to use a standard module and
when to use a class module in Access?
 
TIA    Myke
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030204/c7c468fb/attachment-0002.html>