Create and store unique record number.

I've been searching through the threads trying to find a post that
matches my question but I can't seem to locate one. I need to have the
form automatically generate a unique number in a specific format, and I
need that number to be stored in the database so it would be searchable.
What I'm trying to do is generate a number that is based upon the year,
month, then a 3 digit number on the end such as 05.04.001 for 2005, April,
001. I also need this number to change based upon the month and year. I
have field for the record number to be displayed at the top of the form and
I'd like for this number to show in that field.
In my data table I have 2 fields that I can use to generate this number.
RecordID field and RecordDate field. I just don't know how to get it to
generate and display the number. I tried using some previous post
suggestions to figure this out, but I either get compiler errors or it
simply doesn't work. Please, if anyone can help I would greatly appreciate
it.

Thanks

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Create and store unique record number.
    ... > I've been searching through the threads trying to find a post that ... RecordID field and RecordDate field. ... You can just store the date and format it to give the value you ... It would be better to have to fields and use a calculated field to display ...
    (microsoft.public.access.forms)
  • Re: Can I mimic a btn_Click() ?
    ... In the sample code instead of searching an event with type of ... Other remote UDP command are> OK as long as the display is not affected. ... Once I'm in the> CalibrateLCD_Clickevent handler my sender and "this" look OK in my> "Autos" window in both cases. ...
    (microsoft.public.dotnet.framework.compactframework)
  • For readers
    ... I keep searching for the perfect gadget to take ... Around a 6" x 9" display ... The purpose of the operating is *mainly* to retrieve (from ... I know there have been some ebook-type reader marketing failures, ...
    (microsoft.public.pocketpc)
  • Re: Create a button to save/update record OR add new record
    ... automatic in ms-access anyway). ... So, you need some caution if you are use the SAME form for searching, as any ... ' invoice exist...lets display the invoice form ... invoice form to ONE record,then you can hide/disable the record navigation ...
    (microsoft.public.access.forms)
  • Re: how to deal with multiple result sets in D6 ADO?
    ... >> Thanks, but after further studying, I find I need more info. Can you ... I've been searching the ... Or do you need to extract data and stuff it into a TStrinGrid ... >> if you want to display it? ...
    (borland.public.delphi.database.ado)
Loading