Access Question - Please HELP!

A

Anthony

I use access for a building file and as I type in records in the form it
would go January would be record 1 then at as the months continue then we
would go 2, 3, and 4 now the problem is when you are typing one record 90 and
it thros it in the middle of my database so record 90 becomes record 15, then
it keeps going that for every record I type in and I cannot have this, if you
can offer any help I would appreciate it. Thank you for your time.
 
D

DevalilaJohn

Can you provide some more information, like what is the basic structure of
your table, is the field you are entering an index, is it a numeric or alpha
field, etc.
 
J

John Vinson

I use access for a building file and as I type in records in the form it
would go January would be record 1 then at as the months continue then we
would go 2, 3, and 4 now the problem is when you are typing one record 90 and
it thros it in the middle of my database so record 90 becomes record 15, then
it keeps going that for every record I type in and I cannot have this, if you
can offer any help I would appreciate it. Thank you for your time.
Click to expand...

Access tables don't have "record" numbers. Are you using a table with
an Autonumber field, and it's jumping out of sequence? If so, this is
a known bug with some versions of Access. Be sure you use Office
Update to get the latest service packs for your version of JET, the
Access database engine, and see

http://support.microsoft.com/default.aspx?scid=kb;en-us;291162

for more details.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top