Access insert a new record

[Guest]

How do I insert a new record (or row) in Access 02?

 

[Rick B]

I believe I answered this for you yesterday.

Typically, you would create a form that is bound to your table or a query
and you would add a new record in the form.

The tables are not designed to be used for data entry. Forms are designed
for that purpose.

If you need more details, please post back with a more detailed question.

 

[Rick B]

Note that two of us posted responses to your message from yesterday. We
both gave you pretty much the same advise.

 

[Guest]

I did not receive a posted answer yesterday. I will go back and check.

 

[Guest]

I know I asked about Deleting in Access, then I wrote about Insert, but I did
not receive an answer. I couldn't find your response from yesterday, but I'm
not doubting you. Thanks, anyway.

 

[Guest]

O.k., so maybe I'm not using the correct lingo. I understand creating a new
"form", but I would like to insert it. In a table of 300 entries, I have to
place it in form 134, but "Insert Record" only allows the entry to show up
ont he next line at the bottom.

 

[Guest]

Well, if you really feel you must edit your data in the table, you can. If
"Form 134" is an instance of an attribute called, say, FormNumber, then click
on that last row, add Form 134 and all other data, then sort the table based

 

[Rick B]

The order of records in a table is not relevant. If you want items to print
or display in a particular order, then you need to have a field that can be
used to determine that order. If you really need this item to print in the
134th position, then you need a new field in your records where you can
enter "134". In many cases, when you find yourself doing this, you should
most likely be using a Spreadsheet, not a database. This is not *always*
the case though.