I'm using EXCEL 2003 writing VBA code and using Access database
In DAO, the Seek method for recordset, is used as a filter to search specific records within the current recordset. (Instead of running another SQL query in a database, I wrould rather do a search within the recordset)
In ADO, Seek method cannot be used with ADO. Is there a similar method to Seek that allows to search records within the ADO recordset??