Results 1 to 2 of 2
  1. #1
    genyya is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    1

    Personnalized autonumber

    Good day !



    The access database Id primary key needs to be 20 000 and up.
    exemple : record one : 20001, record two : 20002, record three : 20003, etc.

    I just spend more than one hour reading the site and trying things; but no
    good results.

    The most tangible result I had again was the : /20000, in the format field
    properties.
    But msAccess 12 actually only creates a mask. The actual value is still 001.
    Witch is bad for us.

    Any solution ?
    Thanks so much.

    Marc-Genya

    I'm volunteering in a streetkid reintegration center, helping to configure
    the database.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

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

Similar Threads

  1. Autonumber SQL INSERT INTO
    By eww in forum Programming
    Replies: 16
    Last Post: 03-04-2011, 03:29 PM
  2. Help with autonumber
    By GDubbs780 in forum Programming
    Replies: 15
    Last Post: 02-27-2011, 02:27 PM
  3. Autonumber gone crazy
    By asearle in forum Access
    Replies: 1
    Last Post: 07-27-2010, 05:41 AM
  4. Add prefix to AutoNumber
    By sirmilt in forum Database Design
    Replies: 3
    Last Post: 07-09-2010, 01:41 PM
  5. AUTONUMBER
    By J A F F A in forum Database Design
    Replies: 1
    Last Post: 10-03-2007, 10:30 AM

Tags for this Thread

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