1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Sequential numbering help

Discussion in 'MS Access' started by gear, Apr 9, 2007.

  1. gear

    gear New Member

    Apr 9, 2007
    Likes Received:
    Trophy Points:
    My database has a date field, year field and numberfield. The number field is set with DMax which will reset to No.1 when the year changes. I want help on the following:

    For current year's records - The DB should use the current year's records only for actual working i.e. data entry, edit, search, print etc.

    For previous year's records - The DB should allow only search and print and NOT for data entry and edit.

    How can I achieve this. Please help.

Share This Page