Eric58132
09-22-2009, 06:35 AM
Hi All,
I'm having trouble figuring out if it is possible to limit the access search function to only one field in a table.
I am working on a database that with one main table, and several form which have record sets using this table (bound). The people using it would like to be able to search through records, but there is one rather large problem: The table of records they want to search through has over 130 fields (I know, wasn't my idea, the DB itself was built before I began trying to improve it) When searching for a record, the only applicable field used is [Address], though the preconstructed Access search feature looks through the whole table...which takes a long time with 130 fields X 50,000 records. Can I build a function that searches through only the Address field in the bound table? Thank you for your help.
I'm having trouble figuring out if it is possible to limit the access search function to only one field in a table.
I am working on a database that with one main table, and several form which have record sets using this table (bound). The people using it would like to be able to search through records, but there is one rather large problem: The table of records they want to search through has over 130 fields (I know, wasn't my idea, the DB itself was built before I began trying to improve it) When searching for a record, the only applicable field used is [Address], though the preconstructed Access search feature looks through the whole table...which takes a long time with 130 fields X 50,000 records. Can I build a function that searches through only the Address field in the bound table? Thank you for your help.