If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with Autonumber
Hi,
I work in a small organisation and we have had a small database designed for us by a NOW defuncted company. Within the database we use a screen for invoicing on this screen it uses the "autonumber" facility however, the system crashed many months ago and a IT cons. worked on it to get it working however, he has now left the country (what is it with us and IT professionals leaving). Because of this our numbering system has gone to pot. We wish to restart the autonumbering system on a new number (we use a 5 digit number XXXXX, and we want to begin the renumbering at 130000 is there a way i can go into design view of the invoicing screen and change the numbers to begin a new renumbering scheme.????? Thanks for any help provided |
#3
|
|||
|
|||
Frankly, if you care what the value is, you are using the autonumber
incorrectly. The ONLY thing an autonumber field should be used for is to create a unique primary key value for a record that will relate to records in another table. If you are using the value in any sort of real-world sense, you should create the number programmatically yourself. There are various ways to do this. The simplest is to use the DMax function as illustrated in a small sample database called "AutonumberProblem.mdb" that you can find on my website (www.rogersaccesslibrary.com). -- --Roger Carlson Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Gary Scott" Gary wrote in message news Hi, I work in a small organisation and we have had a small database designed for us by a NOW defuncted company. Within the database we use a screen for invoicing on this screen it uses the "autonumber" facility however, the system crashed many months ago and a IT cons. worked on it to get it working however, he has now left the country (what is it with us and IT professionals leaving). Because of this our numbering system has gone to pot. We wish to restart the autonumbering system on a new number (we use a 5 digit number XXXXX, and we want to begin the renumbering at 130000 is there a way i can go into design view of the invoicing screen and change the numbers to begin a new renumbering scheme.????? Thanks for any help provided |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with AutoNumber | accessmonk | Database Design | 2 | September 30th, 2004 08:57 PM |
keeping track of "Escaped" Autonumber records | Paul James | Using Forms | 7 | September 28th, 2004 12:06 AM |
autonumber column | BG | Database Design | 2 | September 13th, 2004 07:45 PM |
Data Access Page Autonumber | General Discussion | 0 | June 30th, 2004 12:36 AM | |
autonumber | Deepak | General Discussion | 3 | June 18th, 2004 09:07 PM |