Hey folks,
You will all have to forgive my newbie status and possibly silly questions but I was hoping somebody out there can help me with a database that I need to create for work.
I need to create a form that will generate reference numbers for incoming and outgoing corresponndence for the projects that my department works on.
When the form is opened I want the form to check what the last reference number used was and generate the next one in sequence.
The format for the reference numbers will be;
PROJECT/Month-Year/0100 eg: ACC/0409/0123
When the form is used I want it to update the month-year part automatically and use a drop down menu for the project part. The four digit number at the end will as I said increment with each piece of correspondence entered per each project.
Any tips and ideas/suggestions would be massively appreciated. I am a complete noob when it comes to access and am using 2003 and 2007 versions.
Thanks in advance!
Dave