restart auto numbering in an access database

G

Guest

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.
 
R

Rick Brandt

Andriana said:
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.
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access problem 0
How do you add auto number system to existing form in access? 2
Form needs to update two tables then ... 1
How to Intilize Auto Number Field 2
Reset Auto number 4
Line Numbers in subform 1
Unwanted Numbers Rounding 6
This seems like an easy lookup...what am I missing? 4

Top