Prev: data entry in subform before mainform causes huge hassle, HELP
Next: Help With SQL
From: Andre on 6 May 2010 00:02
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

From: Jeanette Cunningham on 6 May 2010 04:55
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" <no(a)email.com> wrote in message
news:%232ZikDN7KHA.4804(a)TK2MSFTNGP02.phx.gbl...
>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


From: Andre on 7 May 2010 01:13
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" <nnn(a)discussions.microsoft.com> wrote in message
news:#ppGXnP7KHA.3504(a)TK2MSFTNGP05.phx.gbl...
> 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" <no(a)email.com> wrote in message
> news:%232ZikDN7KHA.4804(a)TK2MSFTNGP02.phx.gbl...
>>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
>
>
From: Andre on 7 May 2010 01:23
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" <no(a)email.com> wrote in message
news:eMzAaQa7KHA.5112(a)TK2MSFTNGP02.phx.gbl...
> 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" <nnn(a)discussions.microsoft.com> wrote in message
> news:#ppGXnP7KHA.3504(a)TK2MSFTNGP05.phx.gbl...
>> 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" <no(a)email.com> wrote in message
>> news:%232ZikDN7KHA.4804(a)TK2MSFTNGP02.phx.gbl...
>>>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
>>
>>
From: Jeanette Cunningham on 7 May 2010 22:44
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" <no(a)email.com> wrote in message
news:Op1I5Va7KHA.356(a)TK2MSFTNGP05.phx.gbl...
> 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" <no(a)email.com> wrote in message
> news:eMzAaQa7KHA.5112(a)TK2MSFTNGP02.phx.gbl...
>> 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" <nnn(a)discussions.microsoft.com> wrote in message
>> news:#ppGXnP7KHA.3504(a)TK2MSFTNGP05.phx.gbl...
>>> 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" <no(a)email.com> wrote in message
>>> news:%232ZikDN7KHA.4804(a)TK2MSFTNGP02.phx.gbl...
>>>>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
>>>
>>>



 |  Next  |  Last
Pages: 1 2
Prev: data entry in subform before mainform causes huge hassle, HELP
Next: Help With SQL