1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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.!!
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    Get the last id and increment it by one or store the last id in some settings file.
     
  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?
     
  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?
     

Share This Page