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. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|