Tags: access, auto, contact, customer, database, default, entered, microsoft, mysql, number, oracle, own, sql, syste, system

HOW CAN I CHANGE THE CONTACT ID AUTO NUMBER TO MY OWN NUMBER SYSTE

On Database » Microsoft Access

1,004 words with 1 Comments; publish: Fri, 30 May 2008 11:31:00 GMT; (250250.00, « »)

THE CONTACT ID USES AUTO NUMBER BY DEFAULT.

I WANT TO USE MY OWN CUSTOMER NUMBER OR LETTER SYSTEM.

HOW CAN I CHANGE THIS? OR CAN I AFTER I HAVE ENTERED IN MY CUSTOMERS?

All Comments

Leave a comment...

  • 1 Comments
    • (Please use proper case when you post. It hard to read when everything is

      in CAPS. Capital letters are considered as "shouting" in newsgroup

      posting.)

      You cannot change the values of the AutoNumber Field!

      Create your own "CustCode" Field (of Text type or Long type depending on

      your requirement) and set this Field as the Primary Key of the Table. You

      can then enter unique CostCode as required.

      HTH

      Van T. Dinh

      MVP (Access)

      "PC" <PC.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:AF84147E-DA5A-4519-847C-C95B843D20CF.ms-access.questionfor.info.microsoft.com...

      > THE CONTACT ID USES AUTO NUMBER BY DEFAULT.

      > I WANT TO USE MY OWN CUSTOMER NUMBER OR LETTER SYSTEM.

      > HOW CAN I CHANGE THIS? OR CAN I AFTER I HAVE ENTERED IN MY CUSTOMERS?

      #1; Fri, 30 May 2008 11:32:00 GMT