Creating a Confirmation Number

A

Audrey P

I am creating a workshop registration form and would like to generate a
unique confirmation number on the confirmation page for each registrant. Can
you assist me in generating a code that will create this number using
possibly the date and/or time multiplied by another number? I did this once
before 5 years ago and forgot how!

Thanks!
 
B

Bob Lehmann

Insert the new user into the DB and then append the new identity value to
the date....

yyyymmddID

Bob Lehmann
 
M

MikeR

If you're storing the registration in a database, add a column, set it to AutoNumber and
no duplicates, then read it back out.
MikeR
 
Top