Generate a unique form number
? cdbl(Now*10^10)
385823491435185
It would be highly unlikely that this number would be duplicated. You could
prepend a unique letter combination for each user to insure uniquensss
? "ABC" & cdbl(Now*10^10)
ABC385823512615741
--
Regards,
Tom Ogilvy
"quartz" wrote in message
...
I am using Office 2003 on Windows XP.
I have a form built in Excel that will be placed in an Outlook folder
making
it accessible to all users within our organization.
Each time a user opens this form a unique number must be generated on the
form.
Suppose I convert the Excel date to a value: e.g. Aug 17, 2005 becomes
38363
and for time I use 5:34:15 pm = 173415. Now suppose I add these two
numbers
together and also add the user's computer ID to this (each user must have
a
unique computer ID) for example: 83177.
This would then be 38363 + 173415 + 83177 = 294955
Question: Since this value is date and time based and combines a unique
computer ID, would this ALWAYS generate a unique six digit form number?
The form number does need to be unique, but not necessarily in sequence
Any
one have any other suggestions?
|