Inserting Records!

[Bob]

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

Is it possible to insert a blank record in forms as I deleted some records
and I want to start a new database with all in there at the moment my
records jumps from 22 23 26 27 so I am missing 24 and 25

Thanks in advance.........Bob Vance

 

[tina]

if you're using an Autonumber data type for your table's primary key field,
there's no way to ensure that the numbers are consecutive, so this will be a
recurring issue. if your users will not see the primary key values, then
their actual value is unimportant - except to the system. if your users
*will* see the values, and a "gapless" sequence is important, then you'll
need to assign the value for each record at the form level, either manually
or programmatically.

hth

 

[Ricky Hicks [MVP]]

The number of records or the ID number for the record should have no effect
on your database.
The Record ID should have no meaning to you or your user .. it should only
to identify records within Access.

R. Hicks

 

[Bob]

Well I wanted to give this database programme for my friend to use , just
thought it would be nice if they where in sequence. If I delete all records
from table will it start from 1 and be in sequence?..Thanks Bob

 

[Ricky Hicks [MVP]]

If you delete all records in the table(s) .. then compact the database ..
the Autonumbers will be recovered and restart with the value of 1 ...

R. Hicks

 

[Bob]

Brilliant Ricky Thanks for your help, worked perfect

 

[Ricky Hicks [MVP]]

No problem ..

R. Hicks