VB with Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jayachandra
    New Member
    • Mar 2007
    • 49

    #1

    VB with Access

    Hi to all,

    I am new to the VB. I am trying to get the serial no based on date. i.e. like 70600001. In this 7 is the Year from 07 by using round function, 06 is the month form the date & 00001 is the serial no. but by using code I am getting 7061. But I want in the 70600001 format. Please help me in this concept.
    It should continue for further incrementing.

    Thank you,
    Jayachandra
  • Schwanitz
    New Member
    • Jul 2007
    • 3

    #2
    Originally posted by Jayachandra
    Hi to all,

    I am new to the VB. I am trying to get the serial no based on date. i.e. like 70600001. In this 7 is the Year from 07 by using round function, 06 is the month form the date & 00001 is the serial no. but by using code I am getting 7061. But I want in the 70600001 format. Please help me in this concept.
    It should continue for further incrementing.

    Thank you,
    Jayachandra
    Hi,
    you can use the format function: format(serial_n o,"00000") and I think your problem is solved. Please try it.
    Regards

    Comment

    • Jayachandra
      New Member
      • Mar 2007
      • 49

      #3
      Thank you for ur information. I will tr it

      Comment

      • manoj bhatt
        New Member
        • Jul 2007
        • 3

        #4
        Originally posted by Jayachandra
        Hi to all,

        I am new to the VB. I am trying to get the serial no based on date. i.e. like 70600001. In this 7 is the Year from 07 by using round function, 06 is the month form the date & 00001 is the serial no. but by using code I am getting 7061. But I want in the 70600001 format. Please help me in this concept.
        It should continue for further incrementing.

        Thank you,
        Jayachandra
        Can't get ur problem properly, whether a prob. with creating a coded s.no. or having a prob. at retrieval.
        Seems simple at first site.

        manoj bhatt

        Comment

        Working...