part date help

[Gallico]

in a form i need to get a unique number,
the first two need to be the curreny year, the second two the current month then the third three need to automaticly go from 001 to 002 to 003 etc.
so i end up with 1301001.
any help please

 

[pr2-eugin]

Hi Gallico.. Welcome to AWF..

What you want is not impossible.. Few things to be considered, do you want to store this information? Or just display in the Form? Have you thought what will happen when the number hits 999, will it carry on to 1000 or go back to 1?

There should be a working sample DMax Plus One, by RainLover in this forum. Which should get you started..

 

[Gallico]

thank you paul for the quick reply
the number will be stored on the form for future reference.
the number wont hiy 999 as when the new month starts the second set of numbers change then the third set of numbers should return back to 001 and start all over.
i did look at the link provided but this is more for a multi person use not quite what i wanted.

 

[pr2-eugin]

the number will be stored on the form for future reference.

Not quiet.. Forms are not capable of storing any information they will be storing in the table.. Forms only display what table has..

the number wont hiy 999 as when the new month starts the second set of numbers change then the third set of numbers should return back to 001 and start all over.

So in February the ID would be 1302001? Thats fine.. How is this going to be achieved? Do you have a working module?

i did look at the link provided but this is more for a multi person use not quite what i wanted.

Not really, it can be implemented on a single user environment as well.. Please look into it again..

 

[Gallico]

Q1 ok thank you i didnt know that. so when i put information in it has to be put in on the table?
Q2 yes thats right but no i have no idea how to do this.
Q3 ok i will look into it again
thank you