Algorithm based on time and date ( =Now() )
"Phillip Torna" wrote...
I'll be able to construct something using your below example and some
existing code.
....
----- Brad Yundt wrote: -----
....
UniqueID="Q1234567" & Format(Date,"yyyymmdd") & Format(Time,"hhmmss")
If only one person would be using this, this would be OK. If multiple users
could be using this at the same time, there's a nonnegligible chance your
code could generate multiple instances of the exact same 'unique' key.
There's only one reliable way to generate unique serial numbers: request
them from a single, central source that keeps track of the last such value
provided. No other approach is robust.
|