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 using multiple criteria
hi
I have created a db in Access 2007 that is actually designed for children. I want to select multiple values using Filter By Form and have records matching those criteria be displayed in the results. This has always worked in the past versions of Access. Now after I perform the filter, results matching ONLY the first criteria selected are being displayed. When I open the Form in Design View and check for the current filter this is what is displayed "((crooks.[Blonde Hair]=-1) AND (crooks.[Blonde Hair]=-1))" instead of "((crooks.[Blonde Hair]=-1) AND (crooks.[Blue Eyes]=-1))" is this a flaw in the program or something in my design? Is it a setting somewhere? I have checked to make sure that the correct control source on each of the check boxes in the form is correct. Laurie |
#2
|
|||
|
|||
filter by form using multiple criteria
Try opening the form in design mode, clearing the filter, and then saving the
form. Can you make a quick form and confirm this behavior on it? Or does this only happen on the one form? Do you have any code attached to the form? laurie_g wrote: hi I have created a db in Access 2007 that is actually designed for children. I want to select multiple values using Filter By Form and have records matching those criteria be displayed in the results. This has always worked in the past versions of Access. Now after I perform the filter, results matching ONLY the first criteria selected are being displayed. When I open the Form in Design View and check for the current filter this is what is displayed "((crooks.[Blonde Hair]=-1) AND (crooks.[Blonde Hair]=-1))" instead of "((crooks.[Blonde Hair]=-1) AND (crooks.[Blue Eyes]=-1))" is this a flaw in the program or something in my design? Is it a setting somewhere? I have checked to make sure that the correct control source on each of the check boxes in the form is correct. Laurie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#3
|
|||
|
|||
filter by form using multiple criteria
i've tried opening in Design Mode and clearing the filter, saving, exiting.
when i start up i've gone back in to Design Mode to make sure there is nothing in the filter. but as soon as i make my first Filter By Form it is taking whatever the first selected field is on the form and applying it repeatedly for other selections. if i pick 3 items to search for it picks them all up the same as the first item. i just made another form and it does the same thing. unfortunately, i do not have a lot of other databases made in this version of Access to test it out on. I don't know if there is any code attached to the form. (still new to access - can you be more specific?). "kingston via AccessMonster.com" wrote: Try opening the form in design mode, clearing the filter, and then saving the form. Can you make a quick form and confirm this behavior on it? Or does this only happen on the one form? Do you have any code attached to the form? laurie_g wrote: hi I have created a db in Access 2007 that is actually designed for children. I want to select multiple values using Filter By Form and have records matching those criteria be displayed in the results. This has always worked in the past versions of Access. Now after I perform the filter, results matching ONLY the first criteria selected are being displayed. When I open the Form in Design View and check for the current filter this is what is displayed "((crooks.[Blonde Hair]=-1) AND (crooks.[Blonde Hair]=-1))" instead of "((crooks.[Blonde Hair]=-1) AND (crooks.[Blue Eyes]=-1))" is this a flaw in the program or something in my design? Is it a setting somewhere? I have checked to make sure that the correct control source on each of the check boxes in the form is correct. Laurie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#4
|
|||
|
|||
filter by form using multiple criteria
I doubt that there is any code attached to the form since you created the
form and you would know if you wrote some code for it. So unfortunately, it appears that there is a problem with your installation of MS Access. To make sure of this, create a blank database, import the data table from the old database, and create a form based on the table (use the form wizard to create a tabular form). Try the Filter By Form function on this new form. Does it behave the same way? laurie_g wrote: i've tried opening in Design Mode and clearing the filter, saving, exiting. when i start up i've gone back in to Design Mode to make sure there is nothing in the filter. but as soon as i make my first Filter By Form it is taking whatever the first selected field is on the form and applying it repeatedly for other selections. if i pick 3 items to search for it picks them all up the same as the first item. i just made another form and it does the same thing. unfortunately, i do not have a lot of other databases made in this version of Access to test it out on. I don't know if there is any code attached to the form. (still new to access - can you be more specific?). Try opening the form in design mode, clearing the filter, and then saving the form. Can you make a quick form and confirm this behavior on it? Or does [quoted text clipped - 18 lines] Laurie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#5
|
|||
|
|||
filter by form using multiple criteria
Hi
i created a new database, imported the tables from the old one and then created a new form using the wizard. i then tried the filter by form selecting 2 criteria from the form, but the filtered results are the same as the old database. opening the form in design view, the filter property shows multiple entries of the same selection. ((crooks.[Grey Hair]=-1) AND (crooks.[Grey Hair]=-1)) instead of ((crooks.[Grey Hair]=-1) AND (crooks.[Blue Eyes]=-1)) this is Access 2007 Beta with the Technical Refresh. I hear that a 'final' version will be available in a few weeks. perhaps this is a bug that was missed?? Will try another one entirely from scratch on Monday and see if I get the same results. Thanks for your suggestions. Laurie "kingston via AccessMonster.com" wrote: I doubt that there is any code attached to the form since you created the form and you would know if you wrote some code for it. So unfortunately, it appears that there is a problem with your installation of MS Access. To make sure of this, create a blank database, import the data table from the old database, and create a form based on the table (use the form wizard to create a tabular form). Try the Filter By Form function on this new form. Does it behave the same way? laurie_g wrote: i've tried opening in Design Mode and clearing the filter, saving, exiting. when i start up i've gone back in to Design Mode to make sure there is nothing in the filter. but as soon as i make my first Filter By Form it is taking whatever the first selected field is on the form and applying it repeatedly for other selections. if i pick 3 items to search for it picks them all up the same as the first item. i just made another form and it does the same thing. unfortunately, i do not have a lot of other databases made in this version of Access to test it out on. I don't know if there is any code attached to the form. (still new to access - can you be more specific?). Try opening the form in design mode, clearing the filter, and then saving the form. Can you make a quick form and confirm this behavior on it? Or does [quoted text clipped - 18 lines] Laurie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#6
|
|||
|
|||
filter by form using multiple criteria
update:
I've created a new database entirely from scratch but found i got the same results using Filter By Form with multiple criteria. (where only the first criteria was met) However, I did discover that if I use the Advanced Filter option, and choose multiple fields and type "yes" in the criteria box, the filter will work. On the downside, this database is designed for Grade 2 Curriculum and using Advanced Filter options is too advanced for these little users. Filter By Form in older versions of Access worked beautifully to complete this task. I am sad to see that it is either not going to be available this time around, or no one has realized yet that this feature is not working properly. I hope that with the pre-release coming in December that I will find it has in fact been fixed. Laurie "laurie_g" wrote: Hi i created a new database, imported the tables from the old one and then created a new form using the wizard. i then tried the filter by form selecting 2 criteria from the form, but the filtered results are the same as the old database. opening the form in design view, the filter property shows multiple entries of the same selection. ((crooks.[Grey Hair]=-1) AND (crooks.[Grey Hair]=-1)) instead of ((crooks.[Grey Hair]=-1) AND (crooks.[Blue Eyes]=-1)) this is Access 2007 Beta with the Technical Refresh. I hear that a 'final' version will be available in a few weeks. perhaps this is a bug that was missed?? Will try another one entirely from scratch on Monday and see if I get the same results. Thanks for your suggestions. Laurie "kingston via AccessMonster.com" wrote: I doubt that there is any code attached to the form since you created the form and you would know if you wrote some code for it. So unfortunately, it appears that there is a problem with your installation of MS Access. To make sure of this, create a blank database, import the data table from the old database, and create a form based on the table (use the form wizard to create a tabular form). Try the Filter By Form function on this new form. Does it behave the same way? laurie_g wrote: i've tried opening in Design Mode and clearing the filter, saving, exiting. when i start up i've gone back in to Design Mode to make sure there is nothing in the filter. but as soon as i make my first Filter By Form it is taking whatever the first selected field is on the form and applying it repeatedly for other selections. if i pick 3 items to search for it picks them all up the same as the first item. i just made another form and it does the same thing. unfortunately, i do not have a lot of other databases made in this version of Access to test it out on. I don't know if there is any code attached to the form. (still new to access - can you be more specific?). Try opening the form in design mode, clearing the filter, and then saving the form. Can you make a quick form and confirm this behavior on it? Or does [quoted text clipped - 18 lines] Laurie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#7
|
|||
|
|||
filter by form using multiple criteria
Don't underestimate your 2nd graders! I'm amazed that they know how to use
Access form filters at all. A lot of the adults at my work place have a hard time doing anything in Access (can't get past why it looks so much like Excel but doesn't work the same way), and if there isn't a custom button for them to do a specific function - well aye caramba! laurie_g wrote: update: I've created a new database entirely from scratch but found i got the same results using Filter By Form with multiple criteria. (where only the first criteria was met) However, I did discover that if I use the Advanced Filter option, and choose multiple fields and type "yes" in the criteria box, the filter will work. On the downside, this database is designed for Grade 2 Curriculum and using Advanced Filter options is too advanced for these little users. Filter By Form in older versions of Access worked beautifully to complete this task. I am sad to see that it is either not going to be available this time around, or no one has realized yet that this feature is not working properly. I hope that with the pre-release coming in December that I will find it has in fact been fixed. Laurie Hi [quoted text clipped - 49 lines] Laurie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
Thread Tools | |
Display Modes | |
|
|