John Colby
jwcolby at ColbyConsulting.com
Tue Nov 15 13:04:40 CST 2005
Sure, of course except that the "information of the record" is pretty structured and a PITA to have to do every time. The "records in the table" is more specific to the application, and so less can be done with a wizard. 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: Tuesday, November 15, 2005 1:57 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Building classes for tables Ya, I meant field, not table. Shouldn't be too hard, but I think you would want it to make 2 classes. One class to hold the information of the record, and one class to hold the 'records' in a collection. Drew -----Original Message----- From: John Colby [SMTP:jwcolby at colbyconsulting.com] Sent: Monday, November 14, 2005 8: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com