Hi just follow this link & download the file....
http://www.access-programmers.co.uk/forums/showthread.php?t=121400
I think this will be very helpful; thanks to the freind who gave me this.....
Hi, I tried that but didn't worked. Pls find the post with follwing discription.
Restarting Custom # Each Year Using Dmax function
This is what I want. Can you help me?
Hi Can you tell me the changes you made to the code?
I would also like to use the same logic for my database.
If possible can you give the database file as you attached previously.....
Awaiting your reply......
Regards
Rahul
Thanks for that, but it only gives you how to generate a autonumber. What should I do to get the number starting again from "1" at the start of every new year.
How to create or reset a autonumber at the start of new Year
Hi I am trying to make a database, In which I have a table linked with the form.
There are two fields in the table 1.Serial Number & 2. Current Year
I want the serial No. field to be incremented after every record is added & Also the...