|
||||||
|
Automatic Record Numbering By Richard Rost ![]() ![]() ![]() 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. MembersWe'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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
|
Learn MoreFREE Access Beginner Level 1 Free TemplatesTechHelp Free Templates |
ResourcesMailing List - Get emails when new videos released Questions?Please feel free to post your questions or comments below or post them in the Forums. |
Age | Subject | From | |
4 months | Row Counter on form | Peter van Soest | |
2 years | Delete Button | Michelle Seidelin | |
Check out these other pages that may be of interest to you: |
|
| |||