Peanut

Microsoft Access 2010 sequential numbering

Recommended Posts

We have Microsoft Access 2010 as a database for our closed files and have just gone from No. 9999 to 10000 (from 4 numbers to 5 numbers) and now instead of continuing on with numbering after 9999, Access has begun the numbers beginning with 10000 at the TOP of our database, so whenever we enter a new number, we now have to go to the very BOTTOM to enter that new number, but when we get out of Access and then get back in it, that new number (and all of the next new numbers) will be located at the TOP of Access, instead of continuing on at the BOTTOM like it always has. Is there any way at all to make Access continue the numbering at the BOTTOM of our Access list like it always has without having to go through and add a "0" before all of our numbers to make the existing numbers have 5 numbers? Thank you for anyone who might have an answer!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By texmex
      Hey Mr Groove! Love the site and really enjoyed your last article!
       
      I have an idea for a new article on groovypost for you! You need to write something on all the different search syntax that can be used in outlook 2007!
       
      I only use a few of the features but would love to get the inside scoop.
       

    • By CHATLZT
      How do you create an MS WORD TEMPLATE to create a flyer (8.5 X 11) with pull tag telephone numbers; also the ability to insert a scanned graphic?
    • By Beyond_Life
      We are using Outlook 2010 here at the office. And several people are getting the message that there inbox is out of space. And those people have over 3500 emails in there inbox. When I started here I made folders for everyone of my subjects so I can archive easely. But now I want to know how many emails I have.
      Q: How do I find out how many emails I have, including all the folders, using Outlook 2010?
    • By Twitz
      How do you save a shortcut in your favorites bar to another users inbox when they have given you delagate rights to their mailbox.
    • By dchatmanbp
      Employer changed e-mail account names after company name change. Approx 1 month later Outlook flags stopped working appropriately. all but one selection flag "today" stopped working. How do I fix this?
      Searched for Outlook settings affecting flags, customized ribbon by setting-up new group to appear in the ribbon (the options I want, display as greyed out and not available still), searched on-line for fixes for the problem (only found fixes for Outlook 2007 OR upgraded systems - 2007 to 2010). Have asked IT to re-install Outlook (not happened yet)..., THEN looked at the 'old' e-mail account with the company's old name and all the flag functions I used are functional there..., but NOT in the new e-mail account! Got any suggestions?
  • Who's Online   0 Members, 0 Anonymous, 13 Guests (See full list)

    There are no registered users currently online