Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Unanswered: Error 3709 : Cannot find search key

    I checked the MS knowledge base, and all references to this error message in Access world pertain to 'special' characters in a memo field.

    But I get this error when I try to run code that contains a doCmd Transfer spreadsheet command. It's trying to import four worksheets into four access tables. The four spreadsheets are all formatted EXACTLY the same way.

    Is there a way to "Trap," and see what line the code is 'barfing' on ?

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    You can use the On Error statement. See the help file for details.

    Sam

  3. #3
    Join Date
    Nov 2006
    Posts
    2

    Help File

    I'm sorry - I am new to this forum - how do you access the help files.

  4. #4
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Quote Originally Posted by ironwood9
    I'm sorry - I am new to this forum - how do you access the help files.
    Press <F1>, and Microsoft will kindly display context-sensitive help. In other words, if you're in the VBA editor, you will get VBA help, etc.

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •