In Access 2000, how do i insert a new row in the middle of my tab.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

we use Access 2000 and have in the past had no problems adding a row in the
middle (anywhere but the end, not adding a new record) to a table by
highlighting a row and then right clicking and selecting add row or going up
to the insert key at top but for some reason we now cannot do it. has anyone
else had this problem and do you know how to get around it? thanks.
 
The order of records in a table is irrelevant. The table is simple a
storage place (a "bucket") used by Access. Your users should NEVER even see
the tables.

If you care about the order, then you should be working in a form, query, or
report and then sorting on some field.

Hope that helps,

Rick B
 
You shouldn't be mucking about in the tables directly so it's a
non-problem. Use forms and queries to enter and massage data!

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I add a blank record row in to the middle of an existing ta 2
VBA - retrieve data on last create named range from previous inserted named range 0
Insert a blank row into the middle of a table rather than the end 3
How to insert a new record in a middle ? 2
INSERT to excel file 4
How can I get the last row that was inserted in a table 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Access insert a new record 7

Back
Top