filter by form using multiple criteria

[laurie_g]

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

 

[kingston via AccessMonster.com]

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?

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

 

[laurie_g]

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
this only happen on the one form? Do you have any code attached to the form?

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

 

[kingston via AccessMonster.com]

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?

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_g]

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

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?

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

 

[laurie_g]

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

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

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?

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

 

[kingston via AccessMonster.com]

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!

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]