I am about to start a VB6 project for our denominational headquarters. Among other things, it will keep records such as invoices and checks.

One of the requirements is that checks and invoices auto number with the first four digits being the current year, such as 2000-0001, 2000-0002, ect. They also want it to be able to automatically reset when the calendar roles over to a new year so that the first check or invoice of next year would be 2001-0001 and so forth.

A third requested area as an option in this area would be to be able to manually overide a check or invoice number so that if the last invoice was 2000-0139 and you manually overrode the next invoice with 2000-0170, the next automatic invoice would become 2000-0171.

Can anyone help get me started here with a good example with comments or point me in the right direction?

Thanks,
Rev. Michael L. Burns