hi., I'm using MS Access for the Database and visual basic 6.0 for programming. I was just wondering how to auto increment ID number with a format of (Year-Month-Id#).. Please i need some help... Can you help me..? Please... Thanks in Advance.!!
auto increment Id no
Get the last id and increment it by one or store the last id in some settings file.
ah, then whats the data type for the ID number? was it Text?
the format is (Year-month-ID#) and how am i going to increment that?