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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice