Drew Wutka
DWUTKA at marlow.com
Thu Apr 17 17:02:47 CDT 2003
True, in a bound form that's an issue. <evilgrin>. However, if you don't put anything into the db until after the user 'submits' the record, then that is not an issue either. I'm not saying I have ever 'required' an AN to be truly incremented, in fact I would say that half of my AN's are set up to be Random anyways. Drew > -----Original Message----- > From: John W. Colby [mailto:jcolby at colbyconsulting.com] > Sent: Thursday, April 17, 2003 7:32 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] autonumber > > Yea, but the user can "escape out" of a record they don't want to finish. > The autonumber is created when the first piece of info is entered (in > bound forms) and thus that number is used, and then discarded. It's GONNA > happen! > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka > Sent: Thursday, April 17, 2003 5:45 AM > To: 'accessd at databaseadvisors.com' > Subject: RE: [AccessD] autonumber > > > Aha, but if you develop a system that doesn't delete a record, then the AN > will always be incremented. (Thus, the resetting is needed during > development, so that it kicks to 1, on the first 'official' record). > > Drew > > -----Original Message----- > From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] > Sent: Wednesday, April 16, 2003 9:10 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] autonumber > > > Brenda, > > M$ only guarantees that an autonumber will be unique. It does not > guarantee that it will increment by one each time. Users, and > especially auditors, will question you as to why there are gaps in the > numbering scheme. What are you going to say when the auditors ask you > where is the paperwork for the missing numbers? > > Charles Wortz > Software Development Division > Texas Education Agency > 1701 N. Congress Ave > Austin, TX 78701-1494 > 512-463-9493 > CWortz at tea.state.tx.us > > > > -----Original Message----- > From: Reische, Brenda L. [mailto:reische at mdh.org] > Sent: Wednesday 2003 Apr 16 08:12 > To: 'accessd at databaseadvisors.com' > Subject: RE: [AccessD] autonumber > > Charles, > The archives appear to be down right now. Care to enlighten me? I let > the users see the autonumber field. In my ambulance services database, > that is the unique run id number that we use - it prints on the medical > record and > everything... Why is this a cardinal sin? > > Thanks, > Brenda Reische > McDonough District Hospital > > -----Original Message----- > From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] > Sent: Wednesday, April 16, 2003 7:46 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] autonumber > > John, > > I cannot let this pass without asking why do you care? You are not > committing the cardinal sin of allowing you users to see the autonumber > field are you? <grin> If so, check the archives on why this is a > cardinal sin. > > Charles Wortz > Software Development Division > Texas Education Agency > 1701 N. Congress Ave > Austin, TX 78701-1494 > 512-463-9493 > CWortz at tea.state.tx.us > > > > -----Original Message----- > From: Drew Wutka [mailto:DWUTKA at marlow.com] > Sent: Wednesday 2003 Apr 16 05:02 > To: 'AccessD at databaseadvisors.com ' > Subject: RE: [AccessD] autonumber > > A make table query should already 'reset' the AutoNumber, since it is > going to make a new table. An append query can be used to 'set' numbers > within an AutoNumber field, however, it doesn't reset the counter, it > can just 'ignore' it. If you delete the data in a table, to resent the > AutoNumber counter, compact the database. It will reset the counter (on > an incremental > AN) to the highest number plus 1 (or 1, if there are no records > remaining). > > Drew > > -----Original Message----- > From: John Eget > To: AccessD at databaseadvisors.com > Sent: 4/16/03 4:43 AM > Subject: [AccessD] autonumber > > Is there a way to reset the autonumber to 1 of a make table query or an > append or a table I just finished deleting the information from? John > <<ATT46269.txt>> > _______________________________________________ > 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 > > > ----------------------------------------------------- > eMailBoss puts you in command of your email. > Get your copy today at http://www.eMailBoss.com << File: ATT49963.txt >>