Drew Wutka
DWUTKA at Marlow.com
Tue May 27 15:26:54 CDT 2008
It can. Honestly, if I were doing this, I would do two things. One, I'd build a data class, with a collection class. (and I have a VB Addin that does this for me for any table/query that I want). I would then use another addin I created called the Properties Property Add-in, which takes all the properties of a class and puts them in a collection (of sorts), so that you can call the 'properties' of a class. I don't do this personally, because I can't think of a project lately that I EVER go back and check data in the tables before saving it....(and that is because 99% of what I build never alters data, only adds (and RARELY deletes) data.) But with those two utilities I built, I would have a class that I could pull the data up with, and also refer to it pretty quickly. And the properties collection would let me loop through the field names comparing them to a recordset. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, May 27, 2008 3:05 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] VBA Unbound data entry / update form LOL, I do want to do a lot with an unbound form. It should open a record, display that record, allow it to be edited, and save the record back again once edited, all without corrupting data, honoring data saves before it saves etc. Bound forms do all of that, and the unholy alliance of unbounders have always indicated that they could also do all of this stuff. Now I need to do all that stuff and just thought those UAU members would have their expertise to share. 8-0 John W. Colby www.ColbyConsulting.com Drew Wutka wrote: > LOL. Sorry, JC wants to do a lot with an unbound form. I don't have a > preset class to handle that. Also, I tend to make web or VB interfaces, > so I don't use unbound Access forms very often. > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow > Sent: Tuesday, May 27, 2008 12:13 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] VBA Unbound data entry / update form > > OK, sorry for the diversion, back to the topic. > > Drew, help my poor fellow bounder out, eh? > ;o) > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com 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.