I have a database that allows the users to filter the records based on criteria entered into an input box.
The code applies filters, stored in queries, that allow for the users to enter text into an Input Box and the filter applies to the form.
This has worked great in MS Access 1997, 2000, and 2003. Now in MS Access 2007, it no longer works. I have done some searching, found some work arounds, none of which worked for me, and also found it is a known issue that has not been fixed by MS. Wonderful.
If I open up the .mde (a 2003 file, not even a 2007 file) with MS Access 2007, and click to apply the filter, the first time the filter applies correctly, limiting my results.
But after this first time, the filter application no longer works at all. The pop-up input boxes appear for the other filters, but the results do not return correctly.
I just want to clear the previous filter value, go back to all the records, and then apply the new filter value.
I have tried...
me.requery
me.refresh
me.filteron = false
me.filteron = true
docmd.showallrecords
The only thing that works is closing the form with the filters, and then re-opening it.
Has anyone run into this issue with MS Access 2007, and if so, is there a work around for it? I am about to pull my hair out fighting with this thing for hours on end, something that should and has worked with no problems at all.
Thank you,
T.J.
The code applies filters, stored in queries, that allow for the users to enter text into an Input Box and the filter applies to the form.
This has worked great in MS Access 1997, 2000, and 2003. Now in MS Access 2007, it no longer works. I have done some searching, found some work arounds, none of which worked for me, and also found it is a known issue that has not been fixed by MS. Wonderful.
If I open up the .mde (a 2003 file, not even a 2007 file) with MS Access 2007, and click to apply the filter, the first time the filter applies correctly, limiting my results.
But after this first time, the filter application no longer works at all. The pop-up input boxes appear for the other filters, but the results do not return correctly.
I just want to clear the previous filter value, go back to all the records, and then apply the new filter value.
I have tried...
me.requery
me.refresh
me.filteron = false
me.filteron = true
docmd.showallrecords
The only thing that works is closing the form with the filters, and then re-opening it.
Has anyone run into this issue with MS Access 2007, and if so, is there a work around for it? I am about to pull my hair out fighting with this thing for hours on end, something that should and has worked with no problems at all.
Thank you,
T.J.