-
How to generate a custom UID in Access Database?
Greeting!
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.
Thank you
Vandat N.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|