Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ACCESS (OFFICE 2000)

    <img src=/S/help.gif border=0 alt=help width=23 height=15> <img src=/S/help.gif border=0 alt=help width=23 height=15> - I am creating a simple Purchase Order program for my company - it will strickly track to PO#'s - the Vendors and Dates - that type of thing - I would like to know can I get Access to create a autonumber - to create the PO#'s for me - say starting with 1000

    This would be other than the auto ID number

    Thanks Robin

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: ACCESS (OFFICE 2000)

    One way I get an ever increasing number is to define a number in a table, and just update that table to increase the number by one and use that number. This way you won't get the holes that autonumbers give when you compact the database.
    HTH
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ACCESS (OFFICE 2000)

    Thank you I will give it a try - and WOW what a quick respone - I Thank you for that

    Robin <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ACCESS (OFFICE 2000)

    Another way to do this is to use just the simple autonumber field as your primary key and not worry about the holes from people deleting records when they need to, and create a second PO Number field that is user friendly - say YYDDDNNN where YY is the last two digits of the year, DDD is the julian date, and NNN is an autoincrementing number that gets reset each day, or a random number between 0 and 999 depending on your preferences. Just a different way of solving the same problem.
    Wendell

Posting Permissions

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