How to generate a custom UID in Access Database?
How do I create a custom Unique Identifier Number (UID) in Access Database?
I have a database that track all the final inspection lot and each lot# is a UID for that record. The problem I have is that I don't want the user entering the number manuly because they keep miss typing that created many problem. The format of my UID is like this: 63MYDDNN.
It must start with 63 then
the Month (A for January, B for Febuary ...)
then Y for Year (A for 2001, D for 2004 ...)
then DD for Today Date, and
NN for the sequence number of the entry. The NN can only go from 01 to 99.
I need to create a command buttom to pull the number follow this format and assigned it to the "Final Lot #" text box. This number is a UID and it Index. It can not be duplicated or blank. When the number have already assigned it can not be use again.
Can some please help.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL