Results 1 to 2 of 2
  1. 08-05-2014, 03:18 AM #1
    Keith Maxwell
    Keith Maxwell is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2014
    Location
    Birregurra, Vic, Australia
    Posts
    1

    Autonumber field jumps on creating new record

    I've noticed that sometimes my auto number field jumps more than one digit on creating a new record eg, jumps from 00010 to 00013 instead of 00011.Is there any way I can recreate the missing auto number(s) to fill the gaps?I was using Access 2003, but am now using Access 2007

    Cheers



    Keith
    Last edited by Keith Maxwell; 08-05-2014 at 03:22 AM. Reason: Didn't state version upgrade in original post
    Reply With Quote Reply With Quote
  2. 08-05-2014, 07:42 AM #2
    orange's Avatar
    orange
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Please read this regarding autonumbers.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Bound field with autonumber ID, how to create new record ?
    By ann06 in forum Access
    Replies: 4
    Last Post: 05-26-2014, 11:28 PM
  2. Controlling Autonumber field - Start autonumber from 1 everyday (Composite Key)
    By imran688 in forum Access
    Replies: 4
    Last Post: 11-21-2013, 05:06 PM
  3. When opening form, it automatically jumps to a field
    By Mik2045 in forum Forms
    Replies: 4
    Last Post: 08-05-2013, 06:41 PM
  4. Creating an incremental field not an "autonumber field"
    By A kinason in forum Forms
    Replies: 7
    Last Post: 05-12-2013, 05:15 AM
  5. Creating an autonumber field with a with a Make Table Query
    By orcinus in forum Access
    Replies: 7
    Last Post: 01-06-2011, 12:34 PM

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
  •  

Forum Rules

Other Forums: Microsoft Office Forums