Results 1 to 4 of 4
  1. #1
    Seeletse is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    11

    AutoNumber reset


    I would like to know, how do i reset the count of my auto number fields after testing? is it also possible to specify which number the auto number should start counting from?

  2. #2
    sireesha is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    50
    Check this link, you get how to set autonumber. if it solved give solved.
    http://www.youtube.com/watch?v=hiWqqlT0G2E

  3. #3
    Seeletse is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    11
    yes it helped. Is it also possible to change the increment from one to 3 for example?

  4. #4
    sireesha is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    50
    yes, possible.
    in the table feeder. id is given 2. create query append the table. the autonumber starts from 3.
    if it is solved give * mark or solved for the thread

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

Similar Threads

  1. Reset autonumber in a concatenate field
    By Fish218 in forum Forms
    Replies: 6
    Last Post: 03-13-2012, 11:58 AM
  2. Reset Filter On Close
    By Power in forum Forms
    Replies: 1
    Last Post: 07-26-2011, 02:41 PM
  3. Query to Reset AutoNumber to 1 after full delete
    By saigovind in forum Queries
    Replies: 1
    Last Post: 02-04-2011, 03:43 AM
  4. How to Reset Comboboxes
    By bbarrene in forum Programming
    Replies: 5
    Last Post: 01-23-2010, 11:11 PM
  5. reset primary key
    By emilylu3 in forum Access
    Replies: 1
    Last Post: 12-09-2005, 03:27 PM

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