restart auto numbering in an access database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andriana - 13 Mar 2007 00:50 GMT

auto numbering in a form in access 2003 has missed a number. How to restart
numbering from the missed one to coincide with numbers on the task bar.

Reply to this Message

Rick Brandt - 13 Mar 2007 00:56 GMT

> auto numbering in a form in access 2003 has missed a number. How to
> restart numbering from the missed one to coincide with numbers on the
> task bar.

That is not what AutoNumbers are intended to do and if you try to force them you
will only be disappointed. There are numerous, completely normal activities
that will cause gaps in an AutoNumber sequence. If you need a non-broken
seqential set of numbers then don't use AutoNumbers. Use code in your forms to
create your own.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message