Results 1 to 5 of 5

Thread: Append autonum

  1. #1
    Join Date
    Apr 2004
    Posts
    182

    Unanswered: Append autonum

    Can you append data to an autonum ?
    I want an autonum and then I want to append the first three letterf of the Co name to it ??

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    No, you would need to create a new field. If the first 3 letters of the comapany name are constant, you can format the autonumber field to display them.

  3. #3
    Join Date
    Apr 2004
    Posts
    182
    Pity that, thought I could just append them on afterwards.

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Again ... Nope. Autonumbers are readonly. You cannot assign a value to that column.
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Why are autonumbers such a pain in the rear? Wouldnt it be easier to just have them update like an Excel number?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •