-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Access 2002 & 2003. Windows XP Professional O/S.
According to the Access Help article "ApplyFilte r Event" the
"...ApplyFi lter event occurs when the user does one of the following:"
"Filter menu in the Filter window, or clicks Apply Filter on the
toolbar...." Yes, the event fires when this happens.
"Clicks Remove Filter/Sort on the Records menu in Form view, or clicks
Remove Filter on the toolbar...." No, the event doesn't fire when this
happens.
I've tested this in both Access 2002 & 2003 .mdb files. The same
results occurred in both versions.
Does anybody know if there is a fix or workaround that will allow the
code to "know" when the "Remove Filter/Sort" has occurred? An API
function, perhaps?
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQtgBVIechKq OuFEgEQKeUwCfSF g3nziebojN5m6iF RDTmR3TztkAn1n9
TptFgwolKAjklD/PDH7hv3Pb
=nE0G
-----END PGP SIGNATURE----- 7 2566
On Fri, 15 Jul 2005 18:32:45 GMT, MGFoster <me@privacy.com > wrote:
That's not my experience. I added a debug.print to the OnApplyFilter
event in a form in the Northwind sample application, and it fires both
when filtering, and when unfiltering.
This is Access 2003 SP1 (build 6360) on Windows XP SP2
-Tom. -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Access 2002 & 2003. Windows XP Professional O/S.
According to the Access Help article "ApplyFilte r Event" the "...ApplyFilte r event occurs when the user does one of the following:"
"Filter menu in the Filter window, or clicks Apply Filter on the toolbar...." Yes, the event fires when this happens.
"Clicks Remove Filter/Sort on the Records menu in Form view, or clicks Remove Filter on the toolbar...." No, the event doesn't fire when this happens.
I've tested this in both Access 2002 & 2003 .mdb files. The same results occurred in both versions.
Does anybody know if there is a fix or workaround that will allow the code to "know" when the "Remove Filter/Sort" has occurred? An API function, perhaps?
On Fri, 15 Jul 2005 18:32:45 GMT, MGFoster <me@privacy.com > wrote:
That's not my experience. I added a debug.print to the OnApplyFilter
event in a form in the Northwind sample application, and it fires both
when filtering, and when unfiltering.
This is Access 2003 SP1 (build 6360) on Windows XP SP2
-Tom. -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Access 2002 & 2003. Windows XP Professional O/S.
According to the Access Help article "ApplyFilte r Event" the "...ApplyFilte r event occurs when the user does one of the following:"
"Filter menu in the Filter window, or clicks Apply Filter on the toolbar...." Yes, the event fires when this happens.
"Clicks Remove Filter/Sort on the Records menu in Form view, or clicks Remove Filter on the toolbar...." No, the event doesn't fire when this happens.
I've tested this in both Access 2002 & 2003 .mdb files. The same results occurred in both versions.
Does anybody know if there is a fix or workaround that will allow the code to "know" when the "Remove Filter/Sort" has occurred? An API function, perhaps?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Thanks for the response.
Access 2002 SP3.
I found that when the form is a datasheet and it is used as a subform,
the OnApplyFilter event fires when the filter is applied, but, when the
filter is removed the OnApplyFilter event doesn't fire. If the
datasheet is NOT a subform, the OnApplyFilter fires both when the filter
is applied & when it is removed. I used the same form both as a subform
and as a free-standing form to test the above. Looks like an
undocumented gotcha.
This still begs the question: How to get the Remove Filter part of the
OnApplyFilter event to be recognized by subforms? Since Access doesn't
do it, is there an API I can use?
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQtiUZoechKq OuFEgEQKv3wCgti +cQbfxuisSflm2p PY9kQIrE/AAnjmA
TLVjKc9ADTYzBHp Ijo9F1vHL
=I/jx
-----END PGP SIGNATURE-----
Tom van Stiphout wrote: On Fri, 15 Jul 2005 18:32:45 GMT, MGFoster <me@privacy.com > wrote:
That's not my experience. I added a debug.print to the OnApplyFilter event in a form in the Northwind sample application, and it fires both when filtering, and when unfiltering. This is Access 2003 SP1 (build 6360) on Windows XP SP2
-Tom.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Access 2002 & 2003. Windows XP Professional O/S.
According to the Access Help article "ApplyFilte r Event" the "...ApplyFilt er event occurs when the user does one of the following:"
"Filter menu in the Filter window, or clicks Apply Filter on the toolbar.... " Yes, the event fires when this happens.
"Clicks Remove Filter/Sort on the Records menu in Form view, or clicks Remove Filter on the toolbar...." No, the event doesn't fire when this happens.
I've tested this in both Access 2002 & 2003 .mdb files. The same results occurred in both versions.
Does anybody know if there is a fix or workaround that will allow the code to "know" when the "Remove Filter/Sort" has occurred? An API function, perhaps?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Thanks for the response.
Access 2002 SP3.
I found that when the form is a datasheet and it is used as a subform,
the OnApplyFilter event fires when the filter is applied, but, when the
filter is removed the OnApplyFilter event doesn't fire. If the
datasheet is NOT a subform, the OnApplyFilter fires both when the filter
is applied & when it is removed. I used the same form both as a subform
and as a free-standing form to test the above. Looks like an
undocumented gotcha.
This still begs the question: How to get the Remove Filter part of the
OnApplyFilter event to be recognized by subforms? Since Access doesn't
do it, is there an API I can use?
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQtiUZoechKq OuFEgEQKv3wCgti +cQbfxuisSflm2p PY9kQIrE/AAnjmA
TLVjKc9ADTYzBHp Ijo9F1vHL
=I/jx
-----END PGP SIGNATURE-----
Tom van Stiphout wrote: On Fri, 15 Jul 2005 18:32:45 GMT, MGFoster <me@privacy.com > wrote:
That's not my experience. I added a debug.print to the OnApplyFilter event in a form in the Northwind sample application, and it fires both when filtering, and when unfiltering. This is Access 2003 SP1 (build 6360) on Windows XP SP2
-Tom.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Access 2002 & 2003. Windows XP Professional O/S.
According to the Access Help article "ApplyFilte r Event" the "...ApplyFilt er event occurs when the user does one of the following:"
"Filter menu in the Filter window, or clicks Apply Filter on the toolbar.... " Yes, the event fires when this happens.
"Clicks Remove Filter/Sort on the Records menu in Form view, or clicks Remove Filter on the toolbar...." No, the event doesn't fire when this happens.
I've tested this in both Access 2002 & 2003 .mdb files. The same results occurred in both versions.
Does anybody know if there is a fix or workaround that will allow the code to "know" when the "Remove Filter/Sort" has occurred? An API function, perhaps?
MGFoster wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Thanks for the response.
Access 2002 SP3.
I found that when the form is a datasheet and it is used as a subform, the OnApplyFilter event fires when the filter is applied, but, when the filter is removed the OnApplyFilter event doesn't fire. If the datasheet is NOT a subform, the OnApplyFilter fires both when the filter is applied & when it is removed. I used the same form both as a subform and as a free-standing form to test the above. Looks like an undocumented gotcha.
This still begs the question: How to get the Remove Filter part of the OnApplyFilter event to be recognized by subforms? Since Access doesn't do it, is there an API I can use?
Does the the subform have focus when it is pressed.
One suggestion is to create your own menu item and add it to the
menu/toolbar so it does what you want.
MGFoster wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Thanks for the response.
Access 2002 SP3.
I found that when the form is a datasheet and it is used as a subform, the OnApplyFilter event fires when the filter is applied, but, when the filter is removed the OnApplyFilter event doesn't fire. If the datasheet is NOT a subform, the OnApplyFilter fires both when the filter is applied & when it is removed. I used the same form both as a subform and as a free-standing form to test the above. Looks like an undocumented gotcha.
This still begs the question: How to get the Remove Filter part of the OnApplyFilter event to be recognized by subforms? Since Access doesn't do it, is there an API I can use?
Does the the subform have focus when it is pressed.
One suggestion is to create your own menu item and add it to the
menu/toolbar so it does what you want.
Salad wrote: MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Thanks for the response.
Access 2002 SP3.
I found that when the form is a datasheet and it is used as a subform, the OnApplyFilter event fires when the filter is applied, but, when the filter is removed the OnApplyFilter event doesn't fire. If the datasheet is NOT a subform, the OnApplyFilter fires both when the filter is applied & when it is removed. I used the same form both as a subform and as a free-standing form to test the above. Looks like an undocumented gotcha.
This still begs the question: How to get the Remove Filter part of the OnApplyFilter event to be recognized by subforms? Since Access doesn't do it, is there an API I can use?
Does the the subform have focus when it is pressed.
One suggestion is to create your own menu item and add it to the menu/toolbar so it does what you want.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Salad,
Do you mean create my own function for a toolbar? I had created a popup
menu to do the filter/remove filter, but used the built-in functions.
Seems a shame I can't use the built-in functions as documented - why re
invent the wheel when it supposed to already be there? It's a PITA.
Your suggestion is probably the way to go. Doesn't me I have to like it
;-).
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQtwKz4echKq OuFEgEQJeqwCfVZ RgDz+zP/LowJq0/d7gYZ6Nv4UAoKfV
QVrJvvzCiN5IO5v +Ct1ac1uo
=1u3Q
-----END PGP SIGNATURE----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Vegard Bakke |
last post by:
From whet I can see, Python documentation is lacking a very important
piece of information. Very few functions have documented what
exceptions they raise, and under what cicumstances. Is this a task on
the schedule?
In my opinion, every function that might raise an exception should
state so explicitly in the documentation, even uncaught exceptions
from a subfunction.
|
by: Daniel Bickett |
last post by:
Hello,
I am writing an application using two event-driven libraries:
wxPython, and twisted. The first problem I encountered in the program
is the confliction between the two all-consuming methods of the two
libraries: app.MainLoop, and reactor.run. Additionally, the fact that
wxPython was to receive requests from the twisted framework as well as
the end user seemed to be simply asking for trouble.
My initial solution was, naturally,...
|
by: Helmut Gardner |
last post by:
Hi folks
is it possible to let VB.NET call a specific handler, when a socket gets closed (either as a server, or as a client)
Thank
Helmut
|
by: mp |
last post by:
Hi.
I know I can use "window.print()" to print a page, but is there a way to
catch a print event when someone prints a document from the browser?
Thanks.
mp
|
by: Lachlan Hunt |
last post by:
Hi,
I've been looking up lots of documentation and trying to work out a
cross-platform method of capturing a keyboard event and working out
which key was pressed. From what I can find, there doesn't appear to be
any standardised keyboard event interface other than this DOM 3 Events
W3C Working Group Note . However, it is only a note and doesn't
appear to be implemented in any browser. Is there another standard that
I've missed?
The...
| |
by: bissatch |
last post by:
Hi,
I am trying to validate my website against XHTML 1.0 transitional.
Unfortunetely it throws up an error because I have used javascript
event onMouseOver
<span onMouseOver="Swap_Image(...
.... and it gives me an error saying that there is no onMouseOver
attribute.
|
by: Dave Hammond |
last post by:
You'd think this was an occasionally asked question, but a search for
previous related posts only turned up one from 1999, and that one was
never anwered. So...
When handling a keypress event, the terminal bell always rings (at
least with Internet Explorer). While it's not a show-stopper, it can
become annoying. Anyone have any tricks to silence the bell?
Thanks in advance!
|
by: MGFoster |
last post by:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Access 2002 & 2003. Windows XP Professional O/S.
According to the Access Help article "ApplyFilter Event" the
"...ApplyFilter event occurs when the user does one of the following:"
"Filter menu in the Filter window, or clicks Apply Filter on the
toolbar...." Yes, the event fires when this happens.
|
by: HillBilly |
last post by:
One question I have not figured out is how to learn which event parameter
list is supported by a control? EventArgs, CommandEventArgs, what?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |