Unique Record ID in Access 2003

[wannabe2007]

When a record is first added to this particular database I’m working on, I would like a record to be automatically assigned the current date (e.g. 22-Jul-09) in a separate field. I also would like to be able to automatically assign each record with a unique alphanumeric identifier (e.g. KARL090722) when a record is first created. The first 4 alpha characters are pre-defined in a field of their own and ideally, the 6-digit numeric part is a date identifier as to when the record was created.

I would appreciate any suggestions as to how to go about accomplishing this. I would also settle for some alternative in automatically assigning some kind of unique alphanumeric identifier.

Thanks for the help.

 

[kjv1611]

How is your data being added to the table? Via a Form? If so, you can use VBA to do whatever particular combination(s) you want.

So, where does KARL come from? If it's based on some other field(s), you can grab that piece in VBA, and then grab whatever else for the numbers and put the two together either in a form field which feeds to your table, or else directly into your table.

Post back and let us know more detail.

--

"If to err is human, then I must be some kind of human!" -Me

 

[wannabe2007]

Yes, the data will be entered via a form. KARL is an example of a predefined unique field assigned to each record of the database.

Can you suggest where I might find some sample VBA coding that would enable me to do what you’ve suggested? Thanks so much for your help.

 

[kjv1611]

The help files are actually filled with good examples (the VBA editor help files specifically).

Otherwise, you can ask for specifics on here in the Access VBA forum:
forum705

And Google is always a good source.

--

"If to err is human, then I must be some kind of human!" -Me