Looking for a tutorial on MS Access Class Objects

[Fred Wilson]

Hello,

I might be asking the question wrong, but I read a short article on the
net about how Class Objects can make a complex task extremely easy.
However, I can not seem to find any tutorials on making class object.
Can anyone point me in the right direction? Even if it is a book I
should get.

Thanks,
Fred

 

[Douglas J. Steele]

While a little dated,
http://msdn.microsoft.com/library/e...eatingyourowncollectionclasses.asp?frame=true
should apply equally to Access.

If you need more information, post back with more details of what you're
looking for.

 

[Albert D. Kallal]

here one that might help:

mine:
http://www.members.shaw.ca/AlbertKallal/Articles/WhyClass.html

The above also has a link to:

http://www.microsoft.com/technet/prodtechnol/office/office2000/proddocs/opg/part2/ch09.mspx

 

[Fred Wilson]

Doug,
Thank you. I will take a look at this link. I appreciate you offer of
help. I really don't know what I am going to do with this if anything. I
just want to study up on class objects to see if they can make my life
easier or make what few apps I design any better.

Thanks again,
Fred

 

[Fred Wilson]

Thank you Albert, I will have a look at these.

 

[Klatuu]

Albert,
I read your article on classes. I certainly agree with your thoughts on
when to use them. I would also add that a class is very useful when it will
avoid extensive coding throughout the application and you want consistency.
Your first reaction would be "Isn't that what Functions are for?"

Yes. However, here is my scenerio. I have a project billing application
where everything is related to some date withing the accounting period.
These periods are not calendar oriented. Imported data is How many weeks in
the period, all the week ending dates, the period ending date, what period is
it? How may working yours in a week and in the period.

My solution for this was to use a class object. One initiation, it reads the
accounting calender table and loads all the pertinent data. The practice is
to instansiate the object when loading a form or opening a report, and
destroying it on close. It is,then, a simple reference to a class property
to retrieve the imformation.

Me.txtReportDate = cisDates.MonthEndDate