Using class modules to create your own objects
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 and later if you convert it and keep the references to DAO.
Download the sample database file (zipped 47 KB) (if it won't download, right-click and select Save Target As...)
See also our page on Upgrading from Access 97 to 2003.
|Copyright © 2000-5 DI Management Services Pty Limited ABN 78 083 210 584 Sydney, Australia. www.di-mgt.com.au. All rights reserved.|
Home | What We Do | Services | Our Approach | About Us | Projects | Tips | Links | Cryptography | About This Site | Contact | Email Us