Creating a Confirmation Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Insert the new user into the DB and then append the new identity value to
the date....

yyyymmddID

Bob Lehmann
 
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
 
Back
Top