A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

2007 Forms - Quick Filters not working



 
 
Thread Tools Display Modes
  #1  
Old May 6th, 2010, 05:02 AM posted to microsoft.public.access.forms
Andre[_5_]
external usenet poster
 
Posts: 6
Default 2007 Forms - Quick Filters not working

I created a split form that is based on a query and was hoping that I could
use the Quick Filter option, but it does not display any values with the
respective check boxes, just Sort and Text or Number filters.

There aren't that many records, and some of the fields contain the 2 letter
state codes, surely that should work.

Quick filter do however work just fine if I open the table.

What am I missing here ?

Thanks

  #2  
Old May 6th, 2010, 09:55 AM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default 2007 Forms - Quick Filters not working

I just created a split form to test.
The quick filters worked just the same as in the table.

Perhaps you could create a test split form based on a different query - one
that has more records.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Andre" wrote in message
...
I created a split form that is based on a query and was hoping that I could
use the Quick Filter option, but it does not display any values with the
respective check boxes, just Sort and Text or Number filters.

There aren't that many records, and some of the fields contain the 2
letter state codes, surely that should work.

Quick filter do however work just fine if I open the table.

What am I missing here ?

Thanks



  #3  
Old May 7th, 2010, 06:13 AM posted to microsoft.public.access.forms
Andre[_5_]
external usenet poster
 
Posts: 6
Default 2007 Forms - Quick Filters not working

Jeanette,
Thanks you for your advise.

I built a new split form on the same query and the quick filters worked. I
am assuming that somehow the first form got corrupted.

Now I just have to port all my fields, code and logic to the new form....

André

"Jeanette Cunningham" wrote in message
...
I just created a split form to test.
The quick filters worked just the same as in the table.

Perhaps you could create a test split form based on a different query -
one that has more records.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Andre" wrote in message
...
I created a split form that is based on a query and was hoping that I
could use the Quick Filter option, but it does not display any values with
the respective check boxes, just Sort and Text or Number filters.

There aren't that many records, and some of the fields contain the 2
letter state codes, surely that should work.

Quick filter do however work just fine if I open the table.

What am I missing here ?

Thanks



  #4  
Old May 7th, 2010, 06:23 AM posted to microsoft.public.access.forms
Andre[_5_]
external usenet poster
 
Posts: 6
Default 2007 Forms - Quick Filters not working

Magically the Quick Filter Stopped working !

I set the form Allow Edits, Deletes and Adds to No and the filters stopped
working, I also applied a few other changes to some fields (Tab stops etc)

I am going to have to do some testing but so far I have tried to undo all
the changes I made since it worked but can not get working again !

This is frustrating

André

"Andre" wrote in message
...
Jeanette,
Thanks you for your advise.

I built a new split form on the same query and the quick filters worked. I
am assuming that somehow the first form got corrupted.

Now I just have to port all my fields, code and logic to the new form....

André

"Jeanette Cunningham" wrote in message
...
I just created a split form to test.
The quick filters worked just the same as in the table.

Perhaps you could create a test split form based on a different query -
one that has more records.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Andre" wrote in message
...
I created a split form that is based on a query and was hoping that I
could use the Quick Filter option, but it does not display any values
with the respective check boxes, just Sort and Text or Number filters.

There aren't that many records, and some of the fields contain the 2
letter state codes, surely that should work.

Quick filter do however work just fine if I open the table.

What am I missing here ?

Thanks



  #5  
Old May 8th, 2010, 03:44 AM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default 2007 Forms - Quick Filters not working

I just tested this and here is what I found.

If you set Allow Filters to No, the quick filter is not available.
When you set AlloowFilters back to Yes, the quick filter is available again.

The following settings had no effect on the quick filter:
Setting Allow Additions to No
Setting Allow Edits to No
Setting Allow Deletes to No

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Andre" wrote in message
...
Magically the Quick Filter Stopped working !

I set the form Allow Edits, Deletes and Adds to No and the filters stopped
working, I also applied a few other changes to some fields (Tab stops etc)

I am going to have to do some testing but so far I have tried to undo all
the changes I made since it worked but can not get working again !

This is frustrating

André

"Andre" wrote in message
...
Jeanette,
Thanks you for your advise.

I built a new split form on the same query and the quick filters worked.
I am assuming that somehow the first form got corrupted.

Now I just have to port all my fields, code and logic to the new form....

André

"Jeanette Cunningham" wrote in message
...
I just created a split form to test.
The quick filters worked just the same as in the table.

Perhaps you could create a test split form based on a different query -
one that has more records.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Andre" wrote in message
...
I created a split form that is based on a query and was hoping that I
could use the Quick Filter option, but it does not display any values
with the respective check boxes, just Sort and Text or Number filters.

There aren't that many records, and some of the fields contain the 2
letter state codes, surely that should work.

Quick filter do however work just fine if I open the table.

What am I missing here ?

Thanks





  #6  
Old May 17th, 2010, 12:44 AM posted to microsoft.public.access.forms
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default 2007 Forms - Quick Filters not working

I have found a few occasions where the quick filters do not work properly if
the control name is not the same as the underlying
field name (particularly combo boxes). Otherwise I agree with Jeanette on
everything she says.

I use split forms and quick filters in everything.

If you just don't see the checkboxes (but still see the filtering options)
that could be due to the number of unique values and the general setting in
Access options. I agree with you that states should work for showing the
checkboxes even with default settings in access options.

Hope some of this helps,

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Andre" wrote in message
...
I created a split form that is based on a query and was hoping that I
could use the Quick Filter option, but it does not display any values with
the respective check boxes, just Sort and Text or Number filters.

There aren't that many records, and some of the fields contain the 2
letter state codes, surely that should work.

Quick filter do however work just fine if I open the table.

What am I missing here ?

Thanks


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.