Jürgen Welz
jwelz at hotmail.com
Thu Mar 25 09:49:35 CST 2004
I don't believe there is anything inherently incorrect about using the tag property or even storing multiple attributes separated by a delimiter. The difficulty arises when you want to integrate this functionality with existing code developed by someone else. Confilicting usages of the Tag result in the need to resolve code integration issues that arise. There is an excerpt from an O'Reilly Press book by Getz, Litwin and Baron at: http://www.oreilly.com/catalog/accesscook2/chapter/ch07.pdf starting at page 338 (p 47 of the pdf file) that provides a generic routine to set and get built in and user defined properties and create properties that don't exist. Although the code says it doesn't apply to Forms, it looks to me like it should since the code I use is virtually identical. I find the explanations particularly useful for things that learning developers frequently encounter such as the detailed examination of the 'Description' property of various DAO objects. Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com >From: "Developer" <Developer at ultradnt.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "'Access Developers discussion and problem >solving'"<accessd at databaseadvisors.com> >Subject: RE: [AccessD] Framework Discussion - set up question >Date: Thu, 25 Mar 2004 09:45:08 -0500 >MIME-Version: 1.0 >Received: from mc12-f10.hotmail.com ([65.54.167.146]) by >mc12-s6.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Thu, 25 Mar 2004 >06:44:47 -0800 >Received: from databaseadvisors.com ([209.135.140.44]) by >mc12-f10.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Thu, 25 Mar >2004 06:44:47 -0800 >Received: from databaseadvisors.com (databaseadvisors.com >[209.135.140.44])by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id >i2PEgpM13141;Thu, 25 Mar 2004 08:42:51 -0600 >Received: from >mail5.atl.registeredsite.com(nobody at mail5.atl.registeredsite.com >[64.224.219.79])by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id >i2PEg6M12589for <accessd at databaseadvisors.com>; Thu, 25 Mar 2004 08:42:06 >-0600 >Received: from ultradnt.com ([66.223.127.28])by >mail5.atl.registeredsite.com (8.12.8/8.12.8) with ESMTP idi2PFgAZI025498for ><accessd at databaseadvisors.com>; Thu, 25 Mar 2004 10:42:10 -0500 >Received: from COA3 (24-90-29-110.nyc.rr.com [24.90.29.110])by ultradnt.com >(8.11.6/8.11.0) with ESMTP id i2PEg7W37713for ><accessd at databaseadvisors.com>;Thu, 25 Mar 2004 09:42:08 -0500 >(EST)(envelope-from Developer at UltraDNT.com) >X-Message-Info: NDMZeIBu+so8QwkCcmxHyFr1IWDH39BFYAoeFtQz14Y= >Message-ID: <002201c41277$cb044780$6401a8c0 at COA3> >X-MSMail-Priority: Normal >X-Mailer: Microsoft Outlook, Build 10.0.4024 >In-Reply-To: <DCEFJAOENMNENLAAOFGPKENDHEAA.jwcolby at colbyconsulting.com> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 >X-MIME-Autoconverted: from quoted-printable to 8bit by databaseadvisors.com >idi2PEg6M12589 >X-BeenThere: accessd at databaseadvisors.com >X-Mailman-Version: 2.1.4 >Precedence: list >List-Id: Access Developers discussion and problem >solving<accessd.databaseadvisors.com> >List-Help: <mailto:accessd-request at databaseadvisors.com?subject=help> >List-Post: <mailto:accessd at databaseadvisors.com> >List-Subscribe: ><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=subscribe> >List-Archive: <http://databaseadvisors.com/pipermail/accessd> >List-Unsubscribe: ><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=unsubscribe> >Errors-To: accessd-bounces at databaseadvisors.com >Return-Path: accessd-bounces at databaseadvisors.com >X-OriginalArrivalTime: 25 Mar 2004 14:44:47.0724 (UTC) >FILETIME=[B864D2C0:01C41277] > >Cool, thanks to both of you ... I always thought that using the Tag felt >a bit "hack-y" > >Steve > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby >Sent: Thursday, March 25, 2004 7:15 AM >To: Access Developers discussion and problem solving >Subject: RE: [AccessD] Framework Discussion - set up question > > >This is a great way to store control related stuff that you wish to >remain private since so few people even know that you can do this. Just >don't let Jurgen get a hold of it. ;-) > >John W. Colby >www.ColbyConsulting.com > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jürgen Welz >Sent: Thursday, March 25, 2004 1:15 AM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Framework Discussion - set up question > > >I've posted the following before but perhaps should mention it again: I >too avoid using the tag. One may instead add user defined properties to >the form by appending to the properties collection of the form document. >You may add a property in the name of each control and read and write >these properties. The properties are persistent and apply to all >created instances of forms from the documents collections. Using a >property with the same name as a control or directly derived from the >control name by appending a prefix or suffix makes it as easy to iterate >as the controls collection and provides a simple means to connect >control and property. > >I guess the alternative is a naming convention for the type of combo. > >Ciao >Jürgen Welz >Edmonton, Alberta >jwelz at hotmail.com > > > > > > > >I don't see exactly where to tell the fw that , for example, on 2 > >different > >combo's Not In List, I want combo1 to pop a form for data-entry, but > >combo2 to silently undo and reject the newdata. Should this be set in > >the Tag property? . >. >. > >The bottom line is that the form scanning is difficult to program for > >this kind of stuff directly unless you do use the tag property and I > >have a personal distaste for using the tag so I don't. My good friend > >William started me moving away from using tags. He said "just give me > >a method to directly program behaviors and I'll do it explicitly". Now > > >I do just that. > > > >John W. Colby > >www.ColbyConsulting.com > > > >-----Original Message----- > >From: accessd-bounces at databaseadvisors.com > >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Developer > >Sent: Wednesday, March 24, 2004 9:17 AM > >To: 'Access Developers discussion and problem solving' > >Subject: RE: [AccessD] Framework Discussion - set up question > > > > > >I;ve been not able to read all the mail on the FW closely for the past > >week, so sorry if this is a repeat. I "get" the idea, and the form > >scanning, but I don't see exaclty where to tell the fw that , for > >example, on 2 different combo's Not In List, I want combo1 to pop a > >form for data-entry, but combo2 to silently undo and reject the > >newdata. Should this be set in the Tag property? > > > >Tia, > >Steve > >_________________________________________________________________ >Free yourself from those irritating pop-up ads with MSn Premium. Get >2months >FREE* >http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU >=htt >p://hotmail.com/enca&HL=Market_MSNIS_Taglines > >-- >_______________________________________________ >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 _________________________________________________________________ MSN Premium helps eliminate e-mail viruses. Get 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines