Combining year field and autonumber

  • Thread starter Thread starter Coni Fields
  • Start date Start date
C

Coni Fields

I need the code for starting the year at 1 October and
resetting autonumber back to 001 so it would read 2004001
up until 30 sept and 1 oct it would change to 2005001.
Thanks
 
I need the code for starting the year at 1 October and
resetting autonumber back to 001 so it would read 2004001
up until 30 sept and 1 oct it would change to 2005001.
Thanks
Click to expand...

You cannot do this with an Autonumber. You'll need to maintain the
number yourself in VBA code. This code can become fairly complex if
it's a multiuser system - I use some copyrighted code from the Access
Developer's Handbook so I can't post it here, but look in Google for
"Access Custom Counter" - there are several examples around.
 
Back
Top