[AccessD] Example of Class Module usage needed

[Jim Dettman]

You one of the very few that does.

Jim

Sent from my iPhone

> On Sep 24, 2016, at 9:02 PM, John Colby <jwcolby at gmail.com> wrote:
> 
> I would not code in Access without them.  :)
> 
> 
>> On 9/23/2016 9:38 AM, Jim Dettman wrote:
>> <<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
> 
> -- 
> John W. Colby
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com