Automatic Numbering of Rows. Renumber on Add, Delete.

Learn how to have Access automatically number your records sequentially, starting at 1 and counting up. This is handy if you want to show a count of records. Renumber them when you add, edit, or delete records too.

Julian from the UK (a Learning Connection Member) asks: Is there any way to number records in order, starting with 1 and counting up? I need the list to renumber itself when I add or delete records. AutoNumbers don't work, obviously. 

Members

We'll modify the form so you can add a custom sort order that YOU can control, instead of relying on Access to number the records for us. We'll add a delete button, a renumber button, and buttons to move items up and down in the sort order.

•  Extended Cut Video - Silver
• Database Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Sequential Numbering DMAX: https://599cd.com/counter
• Alex's Tip on Row Number: https://599cd.com/6NMW
• DCount: https://599cd.com/DCount
• DLookup: https://599cd.com/DLookup
• Me.Refresh: https://599cd.com/Refresh
• GoToControl: https://599cd.com/GoToControl
• GoToRecord: https://599cd.com/GoToRecord
• Intro to VBA: https://599cd.com/IntroVBA
• Initial Sort Order: https://599cd.com/InitialSortOrder

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.