John W. Colby
jwcolby at colbyconsulting.com
Fri Sep 9 12:33:39 CDT 2005
ROTFLMAOBTC. Except rule #5 should read: Rule #5: If rules 2,3, and 4 are in conflict, refer to Rule #3. 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: Friday, September 09, 2005 1:19 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Autonumber Assigned Immediately Welcome to the AccessD Debate team. Rule #1: A debate must continue until a search of the archives is required to find the original post that started it. Rule #2: Drew is always right. Rule #3: JC is always right. Rule #4: Charlotte is always right. Rule #5: If rules 2,3, and 4 are in conflict, refer to Rule #1. <grin> (Hey, it is Friday!) Drew -----Original Message----- From: Reuben Cummings [mailto:reuben at gfconsultants.com] Sent: Friday, September 09, 2005 10:37 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Autonumber Assigned Immediately I'm here for ya, Drew. I didn't intend to start a big discussion - I just thought it wasn't fair for people to pick on...hell, I can't remember who even asked the original question... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of DWUTKA at marlow.com Sent: Friday, September 09, 2005 12:15 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Autonumber Assigned Immediately Woohoo, I have a sidekick finally! Charlotte and JC have been tag teaming me for YEARS! ;) Drew -----Original Message----- From: Reuben Cummings [SMTP:reuben at gfconsultants.com] Sent: Thursday, September 08, 2005 7:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Autonumber Assigned Immediately It can also be called over-building. I have an app that works perfectly and has done so since 2000. I wrote it with simplicity in mind. I had it ready for use in 6 months with very minor bugs. I sold that app to an engineering firm that thought "building it right, the first time" was the way to go and immediately set out to completely re-write the app. The purchased the app in March of 2003 and in October of 2004 gave up with nothing that worked and gave the whole thing back. They thought they needed to build everything to "the right way" - they were overbuilding the project. The question is "Who decides what the right way is?" Is it mine that works perfectly and is technically fine and has been making me good money since 2000...or the engineers that was written by the book, but never worked and therefore never produced a penny? BTW, I've seen the details of their work records and they have over $300,000 invested in programming time. Getting stuff to the market is sometimes more important than "perfect" code or design. Ask Netscape how writing perfect code worked out for them. I'm not a programmer - at least I don't consider myself one. I have never had any formal programming training and therefore have never been caught up in books and such. I simply build stuff that works. If my clients are happy and I'm making money I have to conclude the design is just fine. Reuben Cummings GFC, LLC 812.523.1017 > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Mcafee > Sent: Thursday, September 08, 2005 5:18 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Autonumber Assigned Immediately > > > So you don't have to go back there and fix things. > > It's called "building it right, the first time" :) > > > --- Susan Harkins <ssharkins at bellsouth.net> wrote: > > > My point would be -- if there are no rules, why > > bother until there are some? > > It might never happen. > > > > Susan H. > > > > Six months later you are told that all the numbers > > have to be padded to 6 > > digits. Ok, either change the field to a text field > > (if it wasn't such > > already), revise the number generator accordingly, > > and run an update query > > on the existing records to include the padding, or > > find all uses of the > > 'number' field everywhere in the database and change > > the formatting of the > > number display. [I know which choice I would make :) > > > > > > Then a year down the line the suits say "You have to > > include an alpha prefix > > that shows which office created the record". Fine > > (As long as you can > > identify the office within the rest of the data). > > You change the 'number' > > generating code to tack on the prefix for new > > records and then run an update > > query to add the prefix to all the existing records. > > > > > > Sit back and wait for the next bright idea about > > what extra information can > > be stuffed into a 'serial number'. All of this is > > just a minor pain in the > > butt because of course you are not using this field > > as a Primary Key, that's > > handled by an autonumber that no one sees, so all > > your relationships are > > intact. > > > > > > -- > > 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