Forum Discussion
tfhancockbtinternet
Jun 14, 2022Copper Contributor
Office 365 - Access
I have a very large Access file consisting of 30 fields and some 80 entries in each field. Whenever I add a new entry and save it the program changes the order of the fields. This means that when I r...
CARKIS51
Jun 14, 2022Copper Contributor
tfhancockbtinternet an access file or database consists of tables of records and queries, forms and other objects to manage, view and report the records. An entry is normally done through a form connected to a table but it can be done directly on the table. An entry consists of a new record and will consist of entries into various fields for example membername, datebirth, address, phone. If you open a table access lets you sort the records and when closing will ask if you want to save "the changes to its design". If you click yes it will keep the sorting and the next time you open the table you will see this sorting. Let's say you want to sort your "member" table by membername ascending, open the table, click inside the membername field, in the Home tab under Sort and Filter click on Ascending, then save, or if you forget to save Access will ask as I said before.
George_Hepworth
Jun 14, 2022Silver Contributor
Actually, even this type of saved property is not really appropriate for tables. Access alone offers this as a "feature" for newer, less experienced users.
In reality, if we are right in assuming that we are talking about sort order of records, then the proper way to do that is a query with an ORDER BY clause.
In reality, if we are right in assuming that we are talking about sort order of records, then the proper way to do that is a query with an ORDER BY clause.
- CARKIS51Jun 14, 2022Copper Contributor
George_Hepworth and open the query instead of the table or use the query as record source for a Form. But we don't know how object "rich" his project is. Judging from the explanation, it seems to be simple.