jwcolby
jwcolby at colbyconsulting.com
Wed Jun 22 20:30:18 CDT 2011
I actually wrote the same thing in Access long ago. Can't find it now.. :( John W. Colby www.ColbyConsulting.com On 6/22/2011 7:40 PM, Drew Wutka wrote: > Actually I have a wizard/Add-on that I built for VB 6. Works like a > charm. You open the 'Data Class Builder', and then you tell that > 'wizard' what database to open (SQL Server or MSAccess), it displays the > tables/queries for that database. You select the table, it displays the > fields of that table/query, and you select the 'primary key' of that > table. You tell it what you want to call the 'single' class, and what > you want to call the 'collection' class, and then press go... and > blammo, a single item class is built with add/modify and delete code is > created in your project, along with a 'collection' class to pull all the > items together into. > > So if I have tblPeople, with my wizard, I can instantly create a Person > class and a People class, that I can now immediately use in my project > to deal with the tblPeople table. > > Next.... > > ;) > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms > Sent: Wednesday, June 22, 2011 6:04 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Refreshing open forms when something changes > > No... that actually makes a lot of sense....and that of course would be > feasible if there were a great demand for VBA work nowadays. Sadly, > there is > not. > > The information contained in this transmission is intended only for the person or entity > to which it is addressed and may contain II-VI Proprietary and/or II-VI Business > Sensitive material. If you are not the intended recipient, please contact the sender > immediately and destroy the material in its entirety, whether electronic or hard copy. > You are notified that any review, retransmission, copying, disclosure, dissemination, > or other use of, or taking of any action in reliance upon this information by persons > or entities other than the intended recipient is prohibited. > >