-----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.
"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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQtgBVIechKqOuFEgEQKeUwCfSFg3nziebojN5m6iFRDTmR 3TztkAn1n9
TptFgwolKAjklD/PDH7hv3Pb
=nE0G
-----END PGP SIGNATURE----- 7 2559
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 "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.
"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 "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.
"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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQtiUZoechKqOuFEgEQKv3wCgti+cQbfxuisSflm2pPY9kQ IrE/AAnjmA
TLVjKc9ADTYzBHpIjo9F1vHL
=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 "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.
"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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQtiUZoechKqOuFEgEQKv3wCgti+cQbfxuisSflm2pPY9kQ IrE/AAnjmA
TLVjKc9ADTYzBHpIjo9F1vHL
=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 "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.
"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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQtwKz4echKqOuFEgEQJeqwCfVZRgDz+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...
|
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...
|
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...
| |
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(...
...
|
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,...
|
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...
|
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: 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...
|
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,...
| |
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
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 ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |