Microsoft Access - Customizable Autonumbering Field

Channel:
United States Design and Deploy
Subscribers:
33,700
Published on ● Video Link: https://www.youtube.com/watch?v=aeZcuwjTWZI


Duration: 28:50
30,033 views
0

This will demonstrate how to make a field that auto generates a combination of numbers and letters to make a unique ID for a row in a table. In this example the value will be based on the date, time and initials of the user entering the new record. By doing so, a case number would not be an arbitrary value but instead contain useful identifying information such as when it was recorded and by who.

There are several real world applications for this such as a case management databases where each case needs a unique identifier. A receiving database would also benefit from such a function, each transaction getting a unique ID.



Other Videos By Design and Deploy


2019-01-13Unity 2018 - Snowfall 04 - Changing Particle Emission Rate Over Time
2019-01-11Unity 2018 - Snowfall 03 - Wind Zone
2019-01-06Unity 2018 - Snowfall 02 - Custom Particle Image and Rotation over Time
2019-01-01Unity 2018 - Snowfall 01 - Particle System Tutorial
2018-12-02Microsoft Access - Update Multiple Tables from a Single Form
2018-11-16Microsoft Access - Notifications Based on Due Date
2018-11-06Microsoft Access - Tracking Collectibles with a Database 04
2018-11-03Microsoft Access - Tracking Collectibles with a Database 03
2018-10-28Microsoft Access - Tracking Collectibles with a Database 02
2018-10-28Microsoft Access - Tracking Collectibles with a Database 01
2018-10-27Microsoft Access - Customizable Autonumbering Field
2018-09-303D Builder - New tool - Custom Shape
2018-08-31Access 2016 - How to Send Emails Based on values in a Table - 03
2018-08-30Access 2016 - How to send email from a Database - 02
2018-08-29Access 2016 - How to Send Emails to Addresses Stored in a Table - 01
2018-06-24Paint 3D - Tankbot Part 2
2018-06-24Paint 3D - Tankbot - Part 1
2018-06-163D Builder - Subtract Tool Tutorial
2018-06-03Access 2016 Inner and Outer Joins and When to Use Them
2018-05-27Paint 3D - Top Hat
2018-05-26What's in the Box?


Tags:
Microsoft Access