[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 937
  • Last Modified:

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.
0
ruavol2
Asked:
ruavol2
  • 2
  • 2
3 Solutions
 
Rey Obrero (Capricorn1)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
 
mbizupCommented:
<<
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
 
ruavol2Author 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
 
Rey Obrero (Capricorn1)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
 
ruavol2Author Commented:
That worked thank you.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now