<!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><SPAN class=287445213-05022003><FONT face=Arial color=#0000ff size=2>No I
don't know otherwise. It probably doesn't. I do most of my work in
A2K now where it is available.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P>
<BLOCKQUOTE>
<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>Jim
DeMarco<BR><B>Sent:</B> Wednesday, February 05, 2003 8:37 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Standard vs.
Class Module<BR><BR></FONT></DIV>
<DIV><SPAN class=437103613-05022003><FONT face=Arial color=#0000ff
size=2>AFAIK, A97 does not support interfaces (that is, the Implements
keyword). Do you know otherwise?</FONT></SPAN></DIV>
<DIV><SPAN class=437103613-05022003></SPAN> </DIV>
<DIV><SPAN class=437103613-05022003></SPAN><FONT face=Arial
size=2>Thanks,</FONT> </DIV>
<P><FONT face=Arial size=2>Jim DeMarco</FONT> <BR><FONT face=Arial
size=2>Director of Product Development</FONT> <BR><FONT face=Arial
size=2>HealthSource/Hudson Health Plan</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> John W. Colby
[mailto:jcolby@colbyconsulting.com]<BR><B>Sent:</B> Monday, February 03,
2003 9:47 PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
RE: [AccessD] Standard vs. Class Module<BR><BR></FONT></DIV>
<DIV><SPAN class=712424502-04022003><FONT face=Arial color=#0000ff
size=2>Access does not have inheritance. Or rather, it can have
interface inheritance but not behavior inheritance.
</FONT></SPAN></DIV>
<DIV> </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>Arthur
Fuller<BR><B>Sent:</B> Monday, February 03, 2003 8:04 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Standard vs.
Class Module<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BLOCKQUOTE><CODE><FONT
size=3><BR><BR>***********************************************************************************<BR>"This
electronic message is intended to be for the use only of the named recipient,
and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that
is confidential or privileged. If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited. If you have received this
message in error or are not the named recipient, please notify us immediately,
either by contacting the sender at the electronic mail address noted above or
calling HS/HHP at (914) 631-1611. If you are not the intended recipient,
please do not forward this email to anyone, and delete and destroy all copies
of this message. Thank
You".<BR>***********************************************************************************<BR></BLOCKQUOTE></FONT></CODE></BODY></HTML>