Setting Serial numbers back to 1 (automatically) at the beginning of Year.
Posted on 2001-06-04
I developed a few Databases (msaccess) with vb frontends. Every year I manually set the tracking numbers to 001. However, I will be leaving my position in the near future and I want to leave the company with programs that need no user intervention if possible. The serial number is 3 digits long, show the leading 0's (ex:001). Can someone lead me in the right directon. Everytime I think I have the answer, there is a loop hole somewhere.
Your assistance is greatly appreciated.