auto increment Id no

Discussion in 'Visual Basic ( VB )' started by CrossVampire, Mar 21, 2011.

  1. CrossVampire

    CrossVampire New Member

    Joined:
    Feb 5, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Philippines
    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.!!
     
    CrossVampire, Mar 21, 2011
    SHARE #1
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Get the last id and increment it by one or store the last id in some settings file.
     
    shabbir, Mar 21, 2011
    SHARE #2
  3. CrossVampire

    CrossVampire New Member

    Joined:
    Feb 5, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Philippines
    ah, then whats the data type for the ID number? was it Text?
     
    CrossVampire, Mar 22, 2011
    SHARE #3
  4. CrossVampire

    CrossVampire New Member

    Joined:
    Feb 5, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Philippines
    the format is (Year-month-ID#) and how am i going to increment that?
     
    CrossVampire, Mar 22, 2011
    SHARE #4

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice