Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Appl/Remove Filter/Sort

Posted on 1998-04-22
4
Medium Priority
?
215 Views
Last Modified: 2012-05-04
Using the FilterOn property of a form, I can tell if a form displays filtered data or not. How can I tell if the user has sorted the data or not; for example how can I tell if the user has clicked on one of the toolbar sort buttons?

Thanks
0
Comment
Question by:rmk
  • 2
  • 2
4 Comments
 
LVL 17

Expert Comment

by:ramrom
ID: 1955872
Examine the form's OrderBy property.
0
 

Author Comment

by:rmk
ID: 1955873
My tests indicate that your suggestion won't do the trick. For example: 1) open a form with a blank order by property, 2) use the tool bar sort button and the order by property gets a value, 3) remove the filter / sort using the menu bar or shortcut menu for the form to restore the form to its recordsource sort and the order by property does NOT get cleared; so at this point I can't tell if the form is in some user specified sort or not.
0
 
LVL 17

Accepted Solution

by:
ramrom earned 400 total points
ID: 1955874
Sorry; you should examine OrderBy and OrderByOn. The most recent filter/sort is saved in OrderBy. It is in effect only when OrderByOn is true. If the user removes filter/sort OrderByOn goes false.
0
 

Author Comment

by:rmk
ID: 1955875
Thanks! I wasn't aware of the OrderByOn property.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question