Drew Wutka
DWUTKA at Marlow.com
Thu May 29 09:44:55 CDT 2008
Actually JC, I did explain. I explained how to make it 10 times better then your bound solution, both in stability and capability. You mumbled something about the customer dictating table design (which is garbage, they want specific functionality, if they can design their own tables, what do they need you for?). I just didn't post a sample application, because I don't have the time to add in the other fluff to make it a working demo. But what you are really missing is that building an unbound form is not just simply form design, it is system design. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, May 29, 2008 6:19 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] VBA Unbound data entry / update form Gustav, There is another saying... all other things being equal, simpler is always better. Your solution is an hour to implement. The Gift Horse is not. I am not looking for a Ferrari, I am looking to fix one single lonely little problem with my VW. Your solution and a lock field certainly appears to do so. And yes, How much "unbound is soooo much better" crap did I endure during the great bound / unbound debate. Given all of that I expected a host of angels to descend on me telling me all of the cool and wonderful things that you could do unbound and how you would go about it. Seems strangely quiet, don't you agree? Tons of "bad design", virtually no "here's how to do unbound". John W. Colby www.ColbyConsulting.com Gustav Brock wrote: > Hi William > > You are a man of great humour. As a foreigner I had to look this up: > > http://www.goenglish.com/DontLookAGiftHorseInTheMouth.asp > > Makes perfectly sense. > > However, have you ever had a gift which you expected to be something quite different? It may cause great disappointment. So let us forgive JC; he was wishing for the superior and sparkling unbound solution - the jacket from the top store in town he could flash on his bike - but was left with a ground level mostly bound modification - a military coloured not very sexy pullover though equipped with a smart zipper. > > /gustav > > >>>> wdhindman at dejpolsystems.com 29-05-2008 04:46 >>> > ...hate to say this JC but I think you're looking a gift horse in the mouth > ...this is almost exactly the way I handle customer contact records ...it > works without any lock conflicts, its much more flexible and user friendly > than a single huge memo field, and indexed search functions are much faster > than text searches ...and the user can't tell the difference from the single > memo field approach except for speed and lack of problems. > > ...its your problem of course but it looks like you've gotten locked into > looking at it a certain way and thus dismissing out of hand solutions that > really do address each of your stated issues. > > William > > -------------------------------------------------- > From: "jwcolby" <jwcolby at colbyconsulting.com> > Sent: Wednesday, May 28, 2008 9:00 PM > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] VBA Unbound data entry / update form > >>> If you REALLY must have a demo for this, let me know, >> maybe I can do that tomorrow.... >> >> LOL, no really, not needed. >> >> John W. Colby >> www.ColbyConsulting.com > > > -- 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.