Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Appl/Remove Filter/Sort

Posted on 1998-04-22
4
Medium Priority
?
214 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

971 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