Jim DeMarco
Jdemarco at hudsonhealthplan.org
Tue Nov 15 09:24:33 CST 2005
I had mentioned a while back that I thought Arthur Fuller gave me such a class and he responded that he hadn't. If you search the archives you might find a reference to a tool he did mention. HTH Jim DeMarco -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby Sent: Monday, November 14, 2005 9: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 Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Monday, November 14, 2005 5:15 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Building classes for tables I had built a 'Properties' property. It was an Add-in to VB. Though I don't think building one to create a property for each table would be too difficult. Drew -----Original Message----- From: John Colby [mailto:jwcolby at colbyconsulting.com] Sent: Monday, November 14, 2005 2:39 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Building classes for tables 8-( I could swear that someone a long time ago mentioned building an automatic class builder. Oh well. Perhaps I should build one. ;-) John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, November 14, 2005 3:29 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Building classes for tables Sounds like a dot net Typed Dataset to me, John. 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 11:33 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Building classes for tables I seem to remember someone saying that they had designed a tool to build a class for a given table, i.e. variables to hold the data in the fields, and property get/let statements for each variable. Has someone done this? Is it available? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************