Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

Thread Tools Rate Thread Display Modes
Old 12-11-2007, 07:12 AM   #1
Registered User
Join Date: Jun 2007
Location: Colorado, U.S.A.
Posts: 1,931
Thanks: 0
Thanked 7 Times in 5 Posts
Alisa will become famous soon enough
Runtime error 3709 The search key was not found in any record

I am getting this error in my import routine:
            DoCmd.TransferDatabase acImport, "Paradox 5.x", ImportDir, , oFile.Name, Left(oFile.Name, Len(oFile.Name) - 3)
Since it is happening when I am importing, the solutions previously suggested like the Microsoft kb fix won't work - I haven't even imported the table yet so how can I delete an index or delete corrupt records? Does anyone have any ideas about fixing this? My only idea is to rewrite my routine to link instead of import, but I'm not sure that would even help.

Alisa is offline   Reply With Quote
Old 01-09-2008, 09:35 AM   #2
Registered User
Join Date: Jan 2008
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
ctolkamp is on a distinguished road
I had the same message when importing an Excel spreadsheet. The problem was that one of the field/column names in Excel started with a space. Removing the space fixed the problem.
ctolkamp is offline   Reply With Quote
The Following User Says Thank You to ctolkamp For This Useful Post:
VBA (06-07-2011)
Old 06-08-2009, 11:01 AM   #3
Johnny Redneck
Registered User
Join Date: Apr 2009
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Johnny Redneck is on a distinguished road
Re: Runtime error 3709 The search key was not found in any record

A bit late I know... But I just bumped into this error in an Access 2007 application. I'm adding records via a very simple form and have no indexes at all on the table that gives the error seemingly at random when adding new records. Also, there are no memo fields or field names with spaces as have been implicated in other instances of this problem on the net.

In my case, I realised when re-examining the form (which I had copied from another) that I had accidentally left the "Filter on load" property set to True with no filter specified. I switched off "Filter on load" and the error went away.

Hope this helps

Johnny Redneck is offline   Reply With Quote
Old 03-23-2017, 11:56 PM   #4
Newly Registered User
Join Date: May 2008
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
wasim_sono is on a distinguished road
Re: Runtime error 3709 The search key was not found in any record

I'm getting same error and applied all solutions posted in this thread but still in veins. I am using a text file to import in access. When I use wizard through "saved Imports" specified in ribbon, it works fine and import all records from text file to table. but when I use following
Private Sub Form_Open(Cancel As Integer)
Dim strBatchName As String
strBatchName = "h:\Akmal Imtiaz\test.bat"
Shell strBatchName
    '==== delet all ====
     SQL = "DELETE * FROM mas1"
     CurrentDb.Execute "" & SQL
DoCmd.RunSavedImportExport "Import-DataFile"
End Sub
then I get run time error 3709 the search key was not found in any record.

wasim_sono is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
combo box used for record search - results dependent on 2 key fields jim84 Forms 2 08-23-2007 04:05 AM
Record Search Form by options axsnub Forms 2 05-17-2006 02:56 AM
The search key was not found in any record danielc Tables 1 08-10-2005 06:12 AM

All times are GMT -8. The time now is 05:38 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World