insert a new record in table body

[fritz]

this is a question of a non-professional: I have a large table in which
groups of records differ only in one field, or only in the last digit of a
larger number:
111123567 -- ccc -- zzz -- vvv -- name5
123453434 -- aaa --zxc -- abc -- name1 --
123453435 -- aaa --zxc -- abc -- name2 --
123453440 -- aaa --zxc -- abc -- name3 --
987635355 -- qxr -- srt -- xyz -- name 10 --
I have to add record
123453438 -- aaa - zxc -- abc -- name7 --
I would like to add the record in the proper place so I can easily copy the
unchanged fields from the preceding record. Adding this new record at the
table end is so unpractical for me, that I have still been using PARADOX
(DOS) - which allows me to do this very easily - for data entry into the
master table; which I then import into ACCESS for all other operations. -
Can I turn off the "end of table " ->* command?

fritzM

 

[Jerry Whittle]

In a word: No. Tables just hold records and in no real order. You could add
a record to the end of the table; close the table; reopen it only to find
that record isn't at the end anymore.

What you could do is create a form that is linked to the table. Then you
would have more control over what records to see. In fact with some effort
you could have the new record populated from the previous record that you
just entered. The code is out there.

Also working at table level is usually a bad thing. You can do a lot of
damage by accident such as delete an entire column or many records at once.

 

[Arvin Meyer [MVP]]

There is no "end of table" command. Access is an ISAM database (Indexed
Sequential Access) which means that all records are added at the end. That
said, you can easily use queries to order the data any way you want.

 

[fritz]

I know I can order, or not order, the table every way I choose. - How do I
data entry not working on "table level"? - If tables hold records in no real
order, which is true, why should a new record always and only be placed at
the end? - Looks like I have to stick - at least for my purposes - with the
infinitely more user friendly Paradox data entry. Despite possible mishaps (I
make backup tables).

Or I can manipulate the form somehow; you say "the code is out there" -
where can I find it?
Thank you,
fritzM