Creating a unique ID number in a form

G

Guest

I am creating a form that will pass the data to an Access database. I want
the form to have a unique ID number field that is automatically created when
I submit the form. I would like the number to be of the format
200512141,where the first 8 numbers are the current date, and the last number
starts at 1 and each new entry increments by 1. Any ideas on how to
accomplish this?

Thanks in advance.
 
C

clintonG

What platform is your web server?
Why in the form? Depending on your page and form submittals using the form
for this type of identifier could lead to end-user modification. It may be
better to do this on the server. I've done a lot of this type of task for
various projects. Its not a "here's how its done" code snippet. If you want
to talk turkey to hire it out I'm all ears...

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Auto Submit? 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Concatenate Date and Number field for Append Query 0
Creating a unique number 4
Data Entry Form and Auto Number ID 2
Creating a Confirmation Number 3
Access Automatically Send a notification email once a record is added 0
Creating Form 1

Top