Access 2000 AutoNumbering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stacie - 31 Mar 2004 23:16 GMT

Can I set how the sequence of AutoNumbering to change with
the year example: 04-001, 04-002, 04-003 etc.?

Also is there a way to have the database alert me to when
there are monthly duties due like in Outlook with the
calendar?

Reply to this Message

Douglas J. Steele - 31 Mar 2004 23:59 GMT

You can't. Autonumbers don't work that way. They exist for one purpose only:
to provide a (practically guaranteed) unique value that can be used as a
primary key. You can't change how they behave.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> Can I set how the sequence of AutoNumbering to change with
> the year example: 04-001, 04-002, 04-003 etc.?
>
> Also is there a way to have the database alert me to when
> there are monthly duties due like in Outlook with the
> calendar?

Reply to this Message