How do I set default Sort settings Microsoft Access 2007

Is there a way we can create a consistent pre sorted environment in Microsoft Access 2007. We have a Windows 2008 Server with an ACCDE and ACCDB file stored there. Users from 5 different clients connect. It seems that several different areas in the forms we have seem to get changed either by the last user that touched the form or by the application (Microsoft Access 2007) itself. We need the data to always start with newest to oldest instead of oldest to newest.

Users launch the application and are used to clicking the Go To Last Record button at the bottom. There they can Go Back One record at a time and see the nights records from the earlier shift. What happens is they cannot find the records consistently. What happens is the current sort makes users think they have lost the records and they are confused as to how to retrieve them. Is there any way to make this consistent.

So users start with the last (or most recent records) and can then simply go back one record at a time. ( Also if there are subforms involved here can you set that for individual forms or can it be set for all forms globally.) Thank you.
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
Order by clause default to Ascending order, so no need to place Asc

select * from tableName Order By [Record Date]    '<< this will be in Ascending order, Oldest first


select * from tableName Order By [Record Date] Desc   '<< this will be in descending order, Newest fir
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
use a query with an Order By clause for all the record Source of your form

select * from tableName Order By [Record Date]    '<< this will be in Ascending order, Oldest first


select * from tableName Order By [Record Date] Desc   '<< this will be in descending order, Newest first
0
 
mbizupConnect With a Mentor Commented:
<<
It seems that several different areas in the forms we have seem to get changed either by the last user that touched the form
>>

Are you using a "Split" database setup (you should be...)?

All users should have their own copy of the front end (user interface) on their individual computers linked to the back-end (which contains the data) in a shared network location.

With that setup, sort settings made by one user should not affect sort settings seen by other users.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
mbizup
When you say Split Setup do you mean ACCDE and ACCDB files. Because that is what we have.

Each user has a shortcut to their desktop from the ACCDE file.

Cap1
When you say this:
select * from tableName Order By [Record Date]    '<<
Did you mean that the ...... '<< sets the Ascending or Decending?
 I thought it was ASC or DSC after or before the record Date.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
That worked thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.