Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: Key Generating in MS Access

    Hello to all,
    I am basic Designer of MS Access. And to day is my first day at dbforums. I want to create a form that automatically generate a key when I click on New Record button. Kindly direct me how to do so. I shall be very thank full to you.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what do you mean by
    that automatically generate a key
    if all thats needed is a value that is guaranteed to be unique then use an autonumber column. but don't rely on that value as having any meaning other than inside the database. resist any notions that its the same as an order, invoice, GRN or receipt No. an autonumber has worth inside the system alone. if you need sequential numbers then you need to develop your own methodology to retrieve the next available number. there's plenty of posts on that subject in this forum and elsewhere
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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