Results 1 to 2 of 2

Thread: Need Help : MS Access Autonumber (in custom format)

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    May 2013
    Posts
    328

    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

  2. #2
    Addicted Member
    Join Date
    Jul 2014
    Posts
    176

    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
  •  



Click Here to Expand Forum to Full Width