how to Generate a unique ID based on input
I want to generate a unique ID based on the input in Windows form...Something like this COM244100...where 1st 3 characters are the Event Name , next 2 digit is the date , next digit is the month , and the remaining are the Id...!!
I am using Ms access as a database....Please Help