Search results

Sorry Rural Guy, I think I got what you mean, not auto number but Dmax where it simply +1 to the prev records. Thanx! I did a search but on the issue of current date? I am a 0 @ coding + VB. If I am not wrong =date() gives current date, but what if I only want the month & year? Came out...

But that is for finding the highest auto number right? But what should be used for the Current MM-YYYY?

Sorry to hijack this thread but I have another question to add on. If I have a Database where it contains the sales / client records of the 10 sales people. When there is a new client the manager will randomly assign the client to one of this sales people to follow up. How can I "secure" the...

Hi all, First post and hope that someone can help. I need to create an auto generated key with this format. [Auto Number]+[(Current)MM-YYYY] [Auto Number] = 0000 [(Current)MM-YYYY] = Current Month + Year Pls help.:(