[AccessD] Example of Class Module usage needed

[Jim Dettman]

<<Classes are swiss army knives in Access. >>

 I find there are very few that bother to use them.

 More often then not, it's just straight code.   The real power in using
classes is lost in VBA because it does not have full inheritance.  VBA is
object based, bit not object orientated like you have in a fully compliant
OOP language.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Thursday, September 22, 2016 07:32 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Example of Class Module usage needed

Classes are swiss army knives in Access.  You can use them for all sorts of
things, not just to represent something like a table.  For example a
Customer class might return the customer name information, all the
associated addresses from the Address table, Order history for that
customer, etc.  In a simple Access databases, there isn't much point, but
where relational information is structured properly, they can be a quick
and direct way of returning requested information from multiple tables or
accepting input and writing it to the appropriate table.

One of my favorite uses is to declare a clsForm and pass it the form object
it should work on.  That will allow binding the open form to an instance of
clsForm and putting uniform behavior or procedures you want available in
all forms in the class.

Charlotte Foust
(916) 206-4336

On Thu, Sep 22, 2016 at 1:22 PM, <ewaldt at gdls.com> wrote:

> I've been automating Access and Excel for years, but never got involved in
> creating class modules (except the ones behind forms and reports, of
> course). I'm now in the process of converting one of my Excel projects
> over to using a class module, and I can see where it's going to be useful
> (very quick, too). In this case, the class basically a more capable, more
> flexible array, with some methods built in. I'm having trouble envisioning
> why they would be needed in Access, though. Obviously they ARE needed, but
> I don't see it. Other than the built in methods, it seems like tables and
> arrays would handle everything. Would anyone like to offer an example of
> how you would use them?
>
> Thanks in advance for any help (and patience).
>
> Tom Ewald
> Mass Properties
> General Dynamics Land Systems
>
> ----------------------------------------------------------------------
> This is an e-mail from General Dynamics Land Systems. It is for the
> intended recipient only and may contain confidential and privileged
> information.  No one else may read, print, store, copy, forward or act in
> reliance on it or its attachments.  If you are not the intended recipient,
> please return this message to the sender and delete the message and any
> attachments from your computer. Your cooperation is appreciated.
> &&
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com