[AccessD] Building classes for tables

So you're trying to build the VBA equivalent of the dot net wizard that
generates a typed dataset, right?  You could use a typed dataset class
as a model for the result and back into the code to build it.

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Monday, November 14, 2005 6:34 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Building classes for tables


I am discussing building a CLASS, inserted into the modules collection
in Access, where a table is specified.  Once the table is specified, a
PRIVATE variable for is created each field in the table in the header of
the class, and a property get/let is created for each private variable.

In other words, specify the table name and press the button.  Look in
the modules tab and find a new class with private variables and public
property get/let methods for each field in the table.

A Class builder.

I can then take that class "template" and start adding init code, and
custom methods etc.  This is doable, but it is a long time since I tried
mucking with the VBA editor object.

John W. Colby
www.ColbyConsulting.com