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
|
|||
|
|||
How do you turn off the auto numbering?
I am using the inventory template in Access 2000, and the product ID field is
auto number and I want to use our product ID numbers. How would I go about doing this? |
#2
|
|||
|
|||
How do you turn off the auto numbering?
Dear SC:
How about adding a new column to the table containing an appropriate datatype for your product ID. I recommend making a unique index on it. You can remove the existing autonumber whenever you have the new column set up. Do you have any existing dependent tables? If you do, you'd need to add the product ID to that table as well, and build a relationship on that. When you remove the autonumber, any existing queries, and possible code or forms, that use the old autonumber will be broken until they are changed. Making a change like this after deployment will be a real challenge! Tom Ellison "scgal" wrote in message ... I am using the inventory template in Access 2000, and the product ID field is auto number and I want to use our product ID numbers. How would I go about doing this? |
#3
|
|||
|
|||
How do you turn off the auto numbering?
Thankfully this is a brand new database that I am setting up. That should do
the trick and I appreciate your help. "Tom Ellison" wrote: Dear SC: How about adding a new column to the table containing an appropriate datatype for your product ID. I recommend making a unique index on it. You can remove the existing autonumber whenever you have the new column set up. Do you have any existing dependent tables? If you do, you'd need to add the product ID to that table as well, and build a relationship on that. When you remove the autonumber, any existing queries, and possible code or forms, that use the old autonumber will be broken until they are changed. Making a change like this after deployment will be a real challenge! Tom Ellison "scgal" wrote in message ... I am using the inventory template in Access 2000, and the product ID field is auto number and I want to use our product ID numbers. How would I go about doing this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
turn off auto numbering in tables | Beatrix | General Discussion | 1 | October 18th, 2005 12:59 PM |
disable auto page numbering | Romar | Page Layout | 2 | August 24th, 2005 04:06 PM |
turn off auto archive for all users | dcournoyer | Installation & Setup | 4 | May 24th, 2005 10:35 PM |
How to turn on to-email address "auto complete" in OE 2003 | GeorgeBU | General Discussion | 2 | May 21st, 2005 03:30 AM |
Auto Numbering revisited | Keith | Worksheet Functions | 2 | April 13th, 2004 07:53 PM |