skylark53 Posted March 27, 2008 Share Posted March 27, 2008 Does anyone know how to insert a new row AT A RANDOM POINT in an access database? I can only insert them at the end. But I want to insert them where they are relevant. Link to comment Share on other sites More sharing options...
Martin L Posted March 27, 2008 Share Posted March 27, 2008 sorting the rows on one field doesnt do the job? for example you have addresses and the postcodes 1111, 5555, 8888 and you want to add 6666 to it then just place it at the bottom and then sort the rows on postcode Link to comment Share on other sites More sharing options...
Team929 Posted March 28, 2008 Share Posted March 28, 2008 I think you may be missing the point of Access... Tables are just to hold the data, not for viewing. Tables should (almost) always be indexed (primary keys).You should always use a query to "view" the data, even if you can just simply open up the table and view it. Also, even if you update the data in a table using a query imbedded in a form, the query should show the correct order of a table with a refresh as long as the tables are indexed properly.With that said, everyone has their own reasons for wanting something a certain way. However, the way you are describing is just not a "best practice" to try to add something in the middle of a table (which is not possible). Insert at the bottom and refresh the form/query/table to view the correct order.Hope this helps. Link to comment Share on other sites More sharing options...
skylark53 Posted April 9, 2008 Author Share Posted April 9, 2008 Thanks, Martin, thanks Team929. Sorry, I was was away on holiday.I don't want to sort the rows because they are (I assume) in arrival date order. (This is a download of the texts from my phone.)I accidentally deleted one of the msgs from my phone so that it wasn't downloaded when I did the dump. I know what it said, so I can type it in. But I DON'T know the time or date.So now I want to insert the missing text in what I think is the correct place, so that the time order is preserved. Any way to do this? Its sounds as if there isn't. If not can I easily get these data into an Excel spreadsheet (where you CAN insert rows)?Thanks again... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now