Generating a form number

[New2vba]

I am currently creating a form, for which I want to generate an automatic number reference.

The number will be based on the current month/year, followed by a 3 digit sequential number, e.g. 0905-001. I want this sequential number to start at 001 then every time the form is opened it will read previous forms that have been saved in a particular location and take the next number. If there is no previous form for that month, I want the number to start again at 001.

Another problem I must consider is if 2 or more people open the form at the same time because, until the form is saved the number will not be reserved. How can I prevent the same number being allocated twice?

I am new to vba and, although I have several books, I can't seem to find anything that will provide a solution.

Any help, even a pointer on what topic to research, will be much appreciated.

[RobDog888]

Welcome to the Forums.

You may want to not create the numbering until the user clicks save. Then you can check what is the correct numbering. If by chance some two users save at the same time it will still only be a second or so during the actual save process until the other one wil detect it and increment the other forms numbering. Probably safe tosay its ok in a multiuser environment.

You can use Date and Format to generate your date format.

How are these forms saved as? Which office app are you using and version?

[New2vba]

Soryy, I forgot to mention - the forms are created in Word 2003 and will be saved as .doc.