Results 1 to 2 of 2
  1. #1
    DICKBUTTONS is offline Novice
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Location
    NJ
    Posts
    3

    DB will not give Unique ID's

    When I open the form I only get 1 to 201 and when I add a new entry it starts numbering at 200, so eventually you will duplicate a number since there are actually 371 file entries...I uploaded a screen shot of the table view...when I add a new file look at the number it gives it!!!

    I CAN SEND YOU A ZIPPED DATABASE IF YOU THINK YOU CAN HELP!!!!




  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    What are the properties for the ID field set to in your table?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unique queries - Unique Count
    By bigfish in forum Queries
    Replies: 7
    Last Post: 03-14-2012, 01:28 PM
  2. Should I give Up on This Form?
    By Palomino33 in forum Forms
    Replies: 25
    Last Post: 11-09-2011, 05:37 AM
  3. Replies: 3
    Last Post: 10-13-2011, 08:40 AM
  4. Replies: 5
    Last Post: 04-05-2011, 08:41 AM
  5. Sum results give me negative values !
    By Costa in forum Reports
    Replies: 4
    Last Post: 03-03-2010, 12:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums