Insert records

[SURGEON1971]

How do I insert records in a completed table to allow for new info to be
added below previous records halfway up the table?

 

[RonaldoOneNil]

Yopu don't. Tables are used to hold data only. Any sorting or ordering is
done where the table info is used e.g queries, forms, reports, combo boxes
etc.

 

[SURGEON1971]

Thanks. So which one of your list should i create to enable new data to be
added? and how would i then renumber each record?

 

[RonaldoOneNil]

A form should be used to enter/edit data in tables. By renumbering, I assume
you have an autonumber field in your table. You should have some other ID or
field in your table that you can control so that you determine the sort
order. This means that the order in which you enter them into the table
becomes irrelevant.

 

[SURGEON1971]

Yes autonumbering is in the table but in the past when i have deleted
occasional records it appearsnot to renumber automatically. I am very new to
Access so not sure of what you mean re ID/field. I am entering the data by
order of date of event.

 

[RonaldoOneNil]

Autonumbers do not automatically renumber. They increment for each new record
added. Even if you delete some records, the autonumbers in those records will
not be re-used.
This 'date of event' field is what I refer to as some other ID or field. You
can use this field to sort your records in a query, form or report so it does
not matter in what order you enter them into your table or what autonumber
they are assigned.

 

[SURGEON1971]

I have been playing around to try to make practical hands on sense of your
previous messages. Combined with your last one i think i start to
understand!!!! Although i shall have to go to Amazon and buy an idiots guide
just for the basics!! Thanks for your help.

 

[BruceM]

One example of sorting in order is that you could insert the current date
and time into each record, and sort based on that. You would use the Now
function to do that. One way is to set the Default Value of a text box
bound to a date field to:
=Now()

You can sort by other fields, as you wish. How you do so depends on the
details. A query is one way; a report's Sorting and Grouping is another.

You can number records on a report by inserting a text box with its Control
Source set to =1 and its Running Sum property set to Over All. Numbering on
a form is rather more complex, but it can be done.

 

[John W. Vinson]

I have been playing around to try to make practical hands on sense of your
previous messages. Combined with your last one i think i start to
understand!!!! Although i shall have to go to Amazon and buy an idiots guide
just for the basics!! Thanks for your help.

A table should be viewed as an unordered "heap" of records. If you want to see
records in some particular order, you must - no option! - use a Query sorting
the records in that order; the table's records will be stored in whatever
order Access finds convenient. At times it might be in the order that the
records were entered - but if you then Compact the database they'll be
reordered in Primary Key order. The order can even change depending on how you
display the data in the table.

There are some good introductory tutorials at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials