Seek?
Aug 1, 2005In vba what function would be the best to find a record in a coloum not index and move the cursor to that record to be able to manipulate.
The only methods i know are seek and find but both are not working in my code properly.
In vba what function would be the best to find a record in a coloum not index and move the cursor to that record to be able to manipulate.
The only methods i know are seek and find but both are not working in my code properly.
A couple of us were doing data entry when one of the record converted its characters to chinese one. When trying to delete this record,I got the error message that the key wasn't found in any record. And clicking the help this is what it said "The search key was not found in any record. (Error 3709)
This error occurs when an ISAM SEEK is being executed and there are no matching values in the index." I was only trying to delete.
A suggestion I found on Google was to remove the indexing of memo fields, but there aren't any.
Any suggestions?
I have two tables linked from SharePoint in Access 2007.
I need to update one table based on the data in another
My questions are
What is the best way to open linked tables - dynaset? Recordset?
are can I use the seek method?