Hi Guys,
As most of you have seen, Access 2007 is quite different in regards to the searching and filtering capabilities.
Searching is very fast now, but it only finds the fist instance of a string within the master records, starting at the beginning of the recordset. There is no "find next" or nav button(s) available to continue searching. Searching is useless unless you are 100% sure that the string only exists in one record.
Filtering now assumes you intend to "And" each filtering criteria on to the last one until you reset the filtering. If your recordset doesn't have anything that matches the filter, the form just goes blank and appears to lock up. I've made workarounds to this (got rid of the "And" logic and trapped the No Records issue) but it's still really clumsy for the users to use.
I'm looking for suggestions/solutions that others have created to improve the searching and/or filtering so that users can find records quickly and confidently.
Thanks!
As most of you have seen, Access 2007 is quite different in regards to the searching and filtering capabilities.
Searching is very fast now, but it only finds the fist instance of a string within the master records, starting at the beginning of the recordset. There is no "find next" or nav button(s) available to continue searching. Searching is useless unless you are 100% sure that the string only exists in one record.
Filtering now assumes you intend to "And" each filtering criteria on to the last one until you reset the filtering. If your recordset doesn't have anything that matches the filter, the form just goes blank and appears to lock up. I've made workarounds to this (got rid of the "And" logic and trapped the No Records issue) but it's still really clumsy for the users to use.
I'm looking for suggestions/solutions that others have created to improve the searching and/or filtering so that users can find records quickly and confidently.
Thanks!