Peanut

Microsoft Access 2010 sequential numbering

By Peanut, in Microsoft Office

Recommended Posts

Peanut    0

Peanut
Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go To Topic Listing

  • Similar Content

    • texmex
      Microsoft Outlook Search Syntax
      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.
       

    • CHATLZT
      MS WORD flyer Template with pull tags at the bottom
      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?
    • Beyond_Life
      How many emails do I have?
      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?
    • dchatmanbp
      Outlook 2010 Flags No Longer Working
      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?
    • Twitz
      Outlook 2010 - How to transfer shortcuts from favorites to another users inbox?
      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.

  • Who's Online   0 Members, 0 Anonymous, 16 Guests (See full list)

    There are no registered users currently online