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,922
    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.

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