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
|
|||
|
|||
Filter by Form
I have a table within a database that I want to filter. However, when I
choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
#2
|
|||
|
|||
I believe its a default action, simply do not use drop down menu, enter the
filter text directly. "Donna" wrote in message ... I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
#3
|
|||
|
|||
Well, you should not be using the tables as an end-user tool. If you want
to filter data from a table, build a query. That is what they are for. Rick B "Donna" wrote in message ... I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
#4
|
|||
|
|||
I know that I can enter the text directly so as for the other posting about
my problem, that didn't help. As for this response, I am not trying to use it as a tool only in that there is another table that I access that allows me to pull-down the menus, so why isn't this one allowing me to do that as well? Just trying to duplicate so that 50 people don't scream at me why they can't do something they've been doing for months and months now. Any other help greatly appreciated. If a query is better than I understand that. BUT if I can understand how the pull-down lists get set up, then I can explain why its better to use a query. "Rick B" wrote: Well, you should not be using the tables as an end-user tool. If you want to filter data from a table, build a query. That is what they are for. Rick B "Donna" wrote in message ... I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
#5
|
|||
|
|||
Perhaps we are not understanding your terminology... what do you mean by
"pull-down list" in a table? -- Ken Snell MS ACCESS MVP "Donna" wrote in message ... I know that I can enter the text directly so as for the other posting about my problem, that didn't help. As for this response, I am not trying to use it as a tool only in that there is another table that I access that allows me to pull-down the menus, so why isn't this one allowing me to do that as well? Just trying to duplicate so that 50 people don't scream at me why they can't do something they've been doing for months and months now. Any other help greatly appreciated. If a query is better than I understand that. BUT if I can understand how the pull-down lists get set up, then I can explain why its better to use a query. "Rick B" wrote: Well, you should not be using the tables as an end-user tool. If you want to filter data from a table, build a query. That is what they are for. Rick B "Donna" wrote in message ... I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
#6
|
|||
|
|||
Donna wrote:
I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? Tools - Options - Filter By Form Defaults "Don't display lists where more than this number of records exists" -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#7
|
|||
|
|||
If you click Filter by Form, and then click into any of the fields, there is
a drop down arrow allowing you to view the values as options with which to filter the data. However, the new table I created only shows IS NULL, IS NOT NULL as the two options in the drop down list. The values within that field are not showing. "Ken Snell [MVP]" wrote: Perhaps we are not understanding your terminology... what do you mean by "pull-down list" in a table? -- Ken Snell MS ACCESS MVP "Donna" wrote in message ... I know that I can enter the text directly so as for the other posting about my problem, that didn't help. As for this response, I am not trying to use it as a tool only in that there is another table that I access that allows me to pull-down the menus, so why isn't this one allowing me to do that as well? Just trying to duplicate so that 50 people don't scream at me why they can't do something they've been doing for months and months now. Any other help greatly appreciated. If a query is better than I understand that. BUT if I can understand how the pull-down lists get set up, then I can explain why its better to use a query. "Rick B" wrote: Well, you should not be using the tables as an end-user tool. If you want to filter data from a table, build a query. That is what they are for. Rick B "Donna" wrote in message ... I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
#8
|
|||
|
|||
The "Is Null" / "Is Not Null" are the only choices for a memo field. To get
the actual values to show in the dropdown list, the field must be a number or text (= 255 characters long) or date or other field type (just cannot be memo). -- Ken Snell MS ACCESS MVP "Donna" wrote in message ... If you click Filter by Form, and then click into any of the fields, there is a drop down arrow allowing you to view the values as options with which to filter the data. However, the new table I created only shows IS NULL, IS NOT NULL as the two options in the drop down list. The values within that field are not showing. "Ken Snell [MVP]" wrote: Perhaps we are not understanding your terminology... what do you mean by "pull-down list" in a table? -- Ken Snell MS ACCESS MVP "Donna" wrote in message ... I know that I can enter the text directly so as for the other posting about my problem, that didn't help. As for this response, I am not trying to use it as a tool only in that there is another table that I access that allows me to pull-down the menus, so why isn't this one allowing me to do that as well? Just trying to duplicate so that 50 people don't scream at me why they can't do something they've been doing for months and months now. Any other help greatly appreciated. If a query is better than I understand that. BUT if I can understand how the pull-down lists get set up, then I can explain why its better to use a query. "Rick B" wrote: Well, you should not be using the tables as an end-user tool. If you want to filter data from a table, build a query. That is what they are for. Rick B "Donna" wrote in message ... I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
#9
|
|||
|
|||
And, as Rick Brandt notes in a separate thread, the table must be a local
table. If it's a linked table, then you'll see just the "Is Null" / "Is Not Null" choices, no matter what type the field is. -- Ken Snell MS ACCESS MVP "Ken Snell [MVP]" wrote in message ... The "Is Null" / "Is Not Null" are the only choices for a memo field. To get the actual values to show in the dropdown list, the field must be a number or text (= 255 characters long) or date or other field type (just cannot be memo). -- Ken Snell MS ACCESS MVP "Donna" wrote in message ... If you click Filter by Form, and then click into any of the fields, there is a drop down arrow allowing you to view the values as options with which to filter the data. However, the new table I created only shows IS NULL, IS NOT NULL as the two options in the drop down list. The values within that field are not showing. "Ken Snell [MVP]" wrote: Perhaps we are not understanding your terminology... what do you mean by "pull-down list" in a table? -- Ken Snell MS ACCESS MVP "Donna" wrote in message ... I know that I can enter the text directly so as for the other posting about my problem, that didn't help. As for this response, I am not trying to use it as a tool only in that there is another table that I access that allows me to pull-down the menus, so why isn't this one allowing me to do that as well? Just trying to duplicate so that 50 people don't scream at me why they can't do something they've been doing for months and months now. Any other help greatly appreciated. If a query is better than I understand that. BUT if I can understand how the pull-down lists get set up, then I can explain why its better to use a query. "Rick B" wrote: Well, you should not be using the tables as an end-user tool. If you want to filter data from a table, build a query. That is what they are for. Rick B "Donna" wrote in message ... I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
#10
|
|||
|
|||
The fields are all text fields, so not sure why this is happening. According
to your reply it should be. This is what is frustrating the daylights out of me! "Donna" wrote: If you click Filter by Form, and then click into any of the fields, there is a drop down arrow allowing you to view the values as options with which to filter the data. However, the new table I created only shows IS NULL, IS NOT NULL as the two options in the drop down list. The values within that field are not showing. "Ken Snell [MVP]" wrote: Perhaps we are not understanding your terminology... what do you mean by "pull-down list" in a table? -- Ken Snell MS ACCESS MVP "Donna" wrote in message ... I know that I can enter the text directly so as for the other posting about my problem, that didn't help. As for this response, I am not trying to use it as a tool only in that there is another table that I access that allows me to pull-down the menus, so why isn't this one allowing me to do that as well? Just trying to duplicate so that 50 people don't scream at me why they can't do something they've been doing for months and months now. Any other help greatly appreciated. If a query is better than I understand that. BUT if I can understand how the pull-down lists get set up, then I can explain why its better to use a query. "Rick B" wrote: Well, you should not be using the tables as an end-user tool. If you want to filter data from a table, build a query. That is what they are for. Rick B "Donna" wrote in message ... I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing Report on Recordset Using "Filter by Form" - Error Messag | Stepney_Clint | Setting Up & Running Reports | 0 | January 7th, 2005 08:17 PM |
Filter By Form using LIKE clause | SirPoonga | General Discussion | 6 | December 9th, 2004 11:22 PM |
Rut Roh Filter by Form | LMB | New Users | 15 | November 19th, 2004 01:04 PM |
Stop saving the filter entered by the user | ConnieA | Using Forms | 13 | July 30th, 2004 06:07 PM |
Filter Problems on Main form & Subform | Jeff | Using Forms | 2 | July 7th, 2004 03:13 PM |