Please help with Access issue

[Acc4me]

Example 1:



2011-1
.......

2011-3893 etc.

Currently I have an Access form which produces a new unique number to identify each new record created. To do this I use the unique ID autonumber from a table to identify the new records. I would like to change from this simple number to the the above format per example 1. The four digits to the left of the hyphen would always be the current year and digits to the right of the hyphen would be the unique auto incrementing numbers such as from my table. I need the year to auto increment by 1 each September 30th (new business year) and I need the numbers to the right to auto reset to 1 to start uniquely identifying records again for the new incremented year. As each record is closed I need the number to be written as a single entity in the new format to my database.

Any help will be much appreciated.

Example 2: After September 30th.

2012-1
.......

2012-447 etc.

[June7]

Here is how I do it http://forums.aspfree.com/microsoft-...ta-403208.html

You will have to modify for the sequence to reinitiate October 1 instead of January. That will definitely be more complicated.

To enable proper sorting/filtering of the ID, should use placeholder 0's, like 2011-0001. Construct the ID to allow for maximum value. 9999 is more than enough for our needs. We haven't yet hit 4000 in one year.

[Acc4me]

June7,

Thanks for taking the time to address my issue. I am new at VB programming but, I am working hard to learn. I will have to figure out how to change to September 30th.

Treypick

[June7]

The string manipulation techniques I show will be much the same. It is date criteria that can be tricky. All an exercise in logic and this should be a good one to learn from. Post your attempt for analysis.