|
||||||
|
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 | |
14 months | Delete Button | Michelle Seidelin | |
You may want to read these articles from the 599CD News: |
|