Results 1 to 2 of 2

Sequential numbering help

  1. #1
    mtmtfranz is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2019
    Posts
    1

    Sequential numbering help


    I'm very new to Access and I am trying to create a sequential numbering system. The first three digits are 0 followed by the last two digits of the current year. Following that is a dash and then a 5 digit sequential number, so the overall format looks like 019-00001. I have the following so far but I can not figure out how to get the sequential numbering code.

    Private Sub Access_button_Click()


    Me.Access_Log_Number = Format("0") + Format(Date, "yy-")

    The table is named Access_Number_Assignment.

    Please help!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,665
    somethin like:

    Code:
    vNum = Dmax("[ID]","table")
    vNum =val( right(vNum,5))
    vNum  = vNum +1
    vNewID = right(Year(),3) & "-" & format(vNum, "00000")

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sequential Numbering
    By thegrimmerdiscovery in forum Access
    Replies: 3
    Last Post: 07-16-2019, 06:15 AM
  2. Sequential Numbering using a query
    By Gina Maylone in forum Access
    Replies: 3
    Last Post: 06-19-2019, 11:33 AM
  3. sequential numbering with criteria
    By Harmoesh in forum Queries
    Replies: 1
    Last Post: 07-04-2018, 05:16 PM
  4. Sequential Numbering in a Form
    By Falafa in forum Forms
    Replies: 6
    Last Post: 10-05-2012, 08:20 AM
  5. Help with Sequential Numbering
    By orion in forum Programming
    Replies: 3
    Last Post: 07-06-2009, 01:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums