Customer Order Template in Access

  • Thread starter Thread starter ChristinaHarris
  • Start date Start date
C

ChristinaHarris

I am trying to see if someone can help me out. In the customer order template
on the Product ID, I do not want automated numbers...I want to input the
number myself. Is there an easy way to change this? I tried but then it
said that I would need to delete relationships. I am still so new at
access...learning, but wondering if anyone can assist me. Thanks in advance
for your help.
 
That field currently is an Autonumber data type. Open the table in Design
view, and then you can change that field to Number and set the Field Size to
Long Integer and delete the 0 from the Default Value property. Then save the
table.

Note that you cannot go backwards once you make this change and save the
table. Also note that duplicate values no longer will be trapped by ACCESS
unless you change the Indexed property for that field to "Yes (No
Duplicates)". If the field is set as the Primary Key of the table, then the
Indexed property already will be set to "Yes (No Duplicates)".

Values already saved in that field will be retained, but ACCESS no longer
will automatically assign numbers for you. You will have to do this by
manual data entry when you add a new record (and trap for duplication of
values -- see above), or by using macro/VBA code to identify and assign a
value for that field.
 
ChristinaHarris said:
I am trying to see if someone can help me out. In the customer order
template
on the Product ID, I do not want automated numbers...I want to input the
number myself. Is there an easy way to change this? I tried but then it
said that I would need to delete relationships. I am still so new at
access...learning, but wondering if anyone can assist me. Thanks in
advance
for your help.
Click to expand...
 
Back
Top