Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Sequential numbering help (http://www.go4expert.com/forums/sequential-numbering-help-t3804/)

gear 9Apr2007 09:50

Sequential numbering help
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.

All times are GMT +5.5. The time now is 15:46.