Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

restore sort order after filter cancel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bart - 08 Nov 2007 16:50 GMT
Hello,

I have a question about filtering using the standard toolbar functions. How
can I maintain or restore my orderBy settings when a user chooses Apply
Filter, Remove Filter (or Apply Filter/Sort, Remove Filter/Sort)?

thanks.

Paul
heifler - 09 Nov 2007 21:03 GMT
Bart,
orderBy is a form property that can be set in VBA code by stating me.orderBy
= ["Name of sort field"]
You could put this on the click event of a button and even add the filter =""
to remove current filter.
Or you could set the forms datasource (a sorted query) to a set of records
that the query produces.
Please see signature if this is not clear and you need it done for you.
Bob

>Hello,
>
[quoted text clipped - 5 lines]
>
>Paul

Signature

Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.