Seek?

Aug 1, 2005

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.

View Replies


ADVERTISEMENT

ISAM Seek Error 3709

Oct 13, 2006

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?

View 1 Replies View Related

Modules & VBA :: DAO Seek Linked Tables From SharePoint

Dec 18, 2013

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?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved