Class Modules in Microsoft Access
(aka.emulating Object-Oriented programming)
Starting with Access '97, Access now gives you the opportunity to create
your own objects in your programs using Class Modules.
If you use VBA to make your Access programs more intelligent, and especially
if you use unbound forms, you will almost certainly find the convenience
of class modules to be well worth the extra initial effort.
The following tips are a simple introduction in how to use the Class
Modules and making a start in doing your own object-oriented programming.
A simple example
Read only properties
Making it do something
Linking to a database table
Saving to the database
Editing and deleting objects
The tutorials assume you are reasonably familiar with using VBA in an Access
application. This code has been tested on Access 97, but should work fine
with Access 2000 if converted from DAO to ADO.
Download the sample
database file (184 KB) (if it won't download, right-click and
select Save Target As...)
Feedback or questions: david@spcsonline.com
|
