-
Dec 1st, 2014, 04:07 AM
#1
Thread Starter
Hyperactive Member
Need Help : MS Access Autonumber (in custom format)
is it possible to have a custom autoincrement number that resets every year?
example :
20140001
20140002
20140003
20140004
20150001
20150002
-
Dec 2nd, 2014, 01:09 AM
#2
Addicted Member
Re: Need Help : MS Access Autonumber (in custom format)
MS Access or any RDBMS (for now) in my experience, cannot handle that kind of auto-numbering.
You need to have that kind of formatting using a Program (mine I use VB6 or VB.Net)
If I had helped you...
Don't forget to mark your Inquiry as RESOLVED...
I will be glad if you can also give me some Reputation points in helping you (by Clicking Rate This Post)...
Happy VB Coding Everyone!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|