auto increment Id no
|
Light Poster
|
|
| 21Mar2011,15:27 | #1 |
|
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.!!
|
|
Go4Expert Founder
|
 |
| 21Mar2011,16:00 | #2 |
|
Get the last id and increment it by one or store the last id in some settings file.
|
|
Light Poster
|
|
| 22Mar2011,10:56 | #3 |
|
|
ah, then whats the data type for the ID number? was it Text?
|
|
Light Poster
|
|
| 22Mar2011,11:01 | #4 |
|
|
the format is (Year-month-ID#) and how am i going to increment that?
|