chronological order

Question

The database has started putting the records we’ve just entered at the beginning of the list of records or even in the middle, rather than at the end.  Can anybody think of any reason for that happening? – or even better, a solution if it happens again? (It only last for about 4 hours, now it's working properly again)

Thank you

Answer 1

The order of records in a table is totally arbitrary. Remember that an electronic file is just a bunch of ones and zeros stored somewhere on a disk. When Access retrieves those ones and zeros it converts them to a readable format. So the order of the records may seem odd depending on how the data is stored on disk. Generally, however, when Access displays the records, it applies a sort using the Order By property of the table, for, report or query. So, as Daniel noted, if records are appearing in a different order, you need to look at the Order By or default sort.

---

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Answer 2

Someone has obviously applied a filter.

No big deal, this is easy to fix!  All you need to do is open your form in design view and edit the Record Source to add a Sort on the appropriate field (Primary Key, Date, whatever field you want it ordered by). Then close and save the form.

I hope this helps,

Daniel Pineault

http://www.cardaconsultants.com

Free MS Access Tips and Code Samples: http://www.devhut.net