Results 1 to 3 of 3
  1. #1
    rkski is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Jan 2010
    Posts
    1

    Auto-number





    Hi All,

    I am relatively new at programming access but am familiar with most things. I am having a problem with a field I need. I have to have a field that contains the year (4 digits) and an auto number (000) that needs to be "zero" ed out at the beginning of the new year i.e. (2009-015 to 1010-001). Can this be done and How. I am using Access 2003 not 2010.


    rkski
    Last edited by rkski; 01-11-2010 at 11:41 AM. Reason: Wrong version of Access

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    You will need to create your own Function that you call from the BeforeUpdate event of your form. Your Function will probably use the DMax() function.
    (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"

  3. #3
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Hope this helps

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

Similar Threads

  1. Custom & Auto Incrementing Job Number
    By mastromb in forum Programming
    Replies: 1
    Last Post: 01-05-2010, 02:58 PM
  2. Auto Sequence String Serial Number
    By eddyc99 in forum Programming
    Replies: 2
    Last Post: 10-02-2009, 08:11 AM
  3. Auto Number in Query
    By Alex Motilal in forum Programming
    Replies: 1
    Last Post: 09-21-2009, 07:17 AM
  4. Restart auto number after deleting records
    By P5C768 in forum Database Design
    Replies: 1
    Last Post: 09-11-2009, 02:07 PM
  5. Need help with an auto number
    By Wrangler in forum Database Design
    Replies: 1
    Last Post: 02-10-2006, 03:21 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
  •  
Other Forums: Microsoft Office Forums - Senior Forums