1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

auto increment Id no

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

  1. CrossVampire

    CrossVampire New Member

    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

    Get the last id and increment it by one or store the last id in some settings file.
  3. CrossVampire

    CrossVampire New Member

    ah, then whats the data type for the ID number? was it Text?
  4. CrossVampire

    CrossVampire New Member

    the format is (Year-month-ID#) and how am i going to increment that?

Share This Page