Access numbering

L

Linda

I created a file to create Check Requests. The ID number is the number of
the Check Requests so I want to keep them in the order they are in. I
mistakenly deleted 2 records in the file and this has thrown off the
numbering in that when you look at the report it will have number 1002 but
when you look at what record it is it shows 1000. The reason that this is a
problem is because when we print or look up a particular record it is
inconvenient to hunt around for it.

So basically my question is, is there a way to insert a record into this
file to correct the number inconsistencies. I looked on help but could find
nothing that this lay person could understand to do. Are there any simple
fixes for this problem?
 
C

chriske911

I created a file to create Check Requests. The ID number is the number of
the Check Requests so I want to keep them in the order they are in. I
mistakenly deleted 2 records in the file and this has thrown off the
numbering in that when you look at the report it will have number 1002 but
when you look at what record it is it shows 1000. The reason that this is a
problem is because when we print or look up a particular record it is
inconvenient to hunt around for it.

So basically my question is, is there a way to insert a record into this
file to correct the number inconsistencies. I looked on help but could find
nothing that this lay person could understand to do. Are there any simple
fixes for this problem?
Click to expand...

f you want a consistent numbering you can never use autonumbering
the skipped numbers are unrecoverable

create a module to achieve this kind of numbering
there are numerous examples on the net
just google for "ms access vba sequential numbering"
or something like that

grtz
 
K

KARL DEWEY

Record numbers are just the current display order. If the display uses a
query the order of records can be changed but the record number displayed in
the navigation area will still be sequential no matter what.

You need a field to store your number.
 
R

Roger Carlson

Your best bet at this point is to change the Autonumber field to a Long
Integer. You can then modify your numbers. Unfortunately, you can't change
it back to Autonumber and you shouldn't anyway. Autonumbers, are not really
for sequential numbering. They are for giving every single new record a
unique identifier.

You'll have to maintain your own numbering sequence through code. It's
fairly simple. On my website (www.rogersaccesslibrary.com), there is a
small sample database called "AutonumberProblem.mdb" which illustrates how.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
E

eyal

lior test
KARL DEWEY said:
Record numbers are just the current display order. If the display uses a
query the order of records can be changed but the record number displayed in
the navigation area will still be sequential no matter what.

You need a field to store your number.
Click to expand...
 
Top