Results 1 to 2 of 2
  1. #1
    ildanach is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2008
    Posts
    3

    Cool Correspondence Reference Number Generation

    Hey folks,

    You will all have to forgive my newbie status and possibly silly questions but I was hoping somebody out there can help me with a database that I need to create for work.

    I need to create a form that will generate reference numbers for incoming and outgoing corresponndence for the projects that my department works on.

    When the form is opened I want the form to check what the last reference number used was and generate the next one in sequence.

    The format for the reference numbers will be;


    PROJECT/Month-Year/0100 eg: ACC/0409/0123

    When the form is used I want it to update the month-year part automatically and use a drop down menu for the project part. The four digit number at the end will as I said increment with each piece of correspondence entered per each project.

    Any tips and ideas/suggestions would be massively appreciated. I am a complete noob when it comes to access and am using 2003 and 2007 versions.

    Thanks in advance!
    Dave

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Intelligent numbers are a pain but I would sugges you keep the elements of the number in separate fields and use DMax()+1 to get the next sequential number from the SsequentialNumber field.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Sum Of Positive Number and Negative Number
    By maysamab in forum Reports
    Replies: 1
    Last Post: 10-20-2008, 04:06 PM
  2. Form Name Reference in VBA
    By Simon Sweet in forum Programming
    Replies: 0
    Last Post: 05-22-2008, 01:55 PM
  3. Ms Access Reference Books
    By dbman in forum Access
    Replies: 2
    Last Post: 01-27-2008, 06:06 PM
  4. Can't reference control in subform
    By evanscamman in forum Forms
    Replies: 0
    Last Post: 12-25-2007, 06:47 PM
  5. How to add Opensource reference???
    By loui in forum Access
    Replies: 0
    Last Post: 10-04-2007, 04:24 AM

Posting Permissions

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