Error 3709 - Microsoft Access / VBA

ladybug via AccessMonster.com

I am trying to change the data in a text field in a table. I can change this
field in other entries, but one specific one I receive this error:

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 do not understand. What does this mean?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200804/1

Apr 3 '08 #1

Subscribe Post Reply

2889

Tom van Stiphout

On Thu, 03 Apr 2008 13:10:15 GMT, "ladybug via AccessMonster.com"
<u21071@uwewrote:

What happened when you put:
"ISAM SEEK" 3709
in a search engine?

-Tom.

>I am trying to change the data in a text field in a table. I can change this
field in other entries, but one specific one I receive this error:

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 do not understand. What does this mean?

Apr 3 '08 #2

Similar topics

Update problem get error message 3709

by: MFS 43 | last post by:

Have two tables with identical fields (access 2002). Trying to combine DATA. I created two recordsets based on these two tables. then I used code that looks like this.: with rstmain

Microsoft Access / VBA

Error Handler best practices

by: deko | last post by:

I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next

Microsoft Access / VBA

query problem - recordset not opening

by: JB | last post by:

Hello, I am trying to write a query that selects a row from another table with a field that matches the Me!RecordingID that's on the form. For some reason my query is not working and the recordset...

Microsoft Access / VBA

query problem - recordset not opening / runtime error 3709

by: JB | last post by:

Thanks to both of you for responding. To Pieter: The second asterisk actually isn't there. The original code reads just as you suggested it should. To Phil: I tried changing the 'And' to 'and'...

Microsoft Access / VBA

Error crystal websetup 9 install

by: p | last post by:

WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....

ASP.NET

Access 2002 3709 Import Error

by: SarahK | last post by:

All, I am trying to import a table from Excel, but I get the 3709 error, search key not found. Any ideas? My TransferSpreadsheet method statement is: DoCmd.TransferSpreadsheet acImport, ,...

Microsoft Access / VBA

3709 error in ADO when using persistant conenction

by: =?Utf-8?B?U3VuaWwgUGFuZGl0YQ==?= | last post by:

Hi All, I have created a VB.Net application that used classic ADO to access the oracle database. I have mentained a persistant connection in it. When i start the application and it works fine....

Visual Basic .NET

Search Key Cannot Be Found (Error 3709)

by: mandanarchi | last post by:

Access 2003; PC with Windows XP; SBS 2003 I tried searching the forums but it came up with a blank page. I searched Google and found an answer; but the 'problem' doesn't relate to our situation!...

Microsoft Access / VBA

3709 Runtime Error

by: repath | last post by:

I tried the code with automation: For Each sheet In objWorkBook.sheets 'for each sheet in excel loop Debug.Print "Imported sheet is :"; sheet.Name DoCmd.TransferSpreadsheet acImport,...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice