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.