John W. Colby
jcolby at ColbyConsulting.com
Thu Apr 17 07:32:00 CDT 2003
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 -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 3424 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030417/8eb1ad16/attachment-0001.bin>