473,320 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem after upgrade

I recently upgraded from Access 2003 to 2013. I have a form with a subform for updating records with additional information. In the header of the subform, I have an unbound control (combo) to navigate to the correct record. This combo is populated with the records that are available for update. When the control receives focus, I get the error: "The Microsoft Access database engine cannot find a record in the table 'tblRetreadOptions' with key matching field(s) 'RetreadOptionsID'." I have the following code in the AfterUpdate event of the control.
Expand|Select|Wrap|Line Numbers
  1. Private Sub cboTag_AfterUpdate()
  2.     'Move to appropriate record
  3.     Dim rs As DAO.Recordset
  4.  
  5.     If Not IsNull(Me.cboTag) Then
  6.         'Save before move.
  7.         If Me.Dirty Then
  8.             Me.Dirty = False
  9.         End If
  10.         'Search in the clone set.
  11.         Set rs = Me.RecordsetClone
  12.         rs.FindFirst "[Tag] = '" & Me.cboTag & "'"
  13.         If rs.NoMatch Then
  14.             MsgBox "Not found: filtered?"
  15.         Else
  16.             'Display the found record in the form.
  17.             Me.Bookmark = rs.Bookmark
  18.         End If
  19.         Set rs = Nothing
  20.     End If
  21.  
  22.     'send focus to correct control
  23.     Me.lstCapped.SetFocus
  24.  
  25. End Sub
Thanks!
Sep 9 '14 #1
3 1064
twinnyfo
3,653 Expert Mod 2GB
Knowlton,

When the control receives focus, I get the error: "The Microsoft Access database engine cannot find a record in the table 'tblRetreadOptions' with key matching field(s) 'RetreadOptionsID'."
It sound more like one of two other things, rather than the After Update event of the Combo Box:

1. Is there an event on the Got Focus Event of the Combo Box?

2. Is there an After Update event on the Control that previously had the focus? I don't see anything in the Combo Box's After Update event that looks like it is referring to tblRetreadOptions.

There could be some other issues, but the error described does not sound like a typical error one gets when upgrading--it still may be related to the upgrade, but we have to find when and where the error is coming from first.

Hope this points in the right direction for troubleshooting. We'll stand by to assist!
Sep 9 '14 #2
I've figured it out. I copied and modified an existing form that had code to go to a new record on load. That's where the reference to the table came from.
Thanks for your help!
Sep 10 '14 #3
twinnyfo
3,653 Expert Mod 2GB
Glad you found the problem. Let us know if you run across anything else.
Sep 10 '14 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

14
by: Ruth | last post by:
Hi All I am not a DBA, but a unix administrator. After our DBA's upgraded from oracle 8.0.5 to oracle 8.1.7.4 on our test server, we have noticed a big slow down in our application...
13
by: Winbatch | last post by:
Hi, If this should be directed to another group, please let me know... I've been working with templates for a few weeks and have been able to develop some nice code on solaris using the Forte C++...
7
by: Abdul-Wahid Paterson | last post by:
Hi, I have had a site working for the last 2 years and have had no problems until at the weekend I replace my database server with a newer one. The database migration went like a dream and I had...
6
by: Terry Bell | last post by:
We've had a very large A97 app running fine for the last seven years. I've just converted to SQL Server backend, which is being tested, but meanwhile the JET based version, running under terminal...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
11
by: Don | last post by:
QUESTIONS: 1. Has anyone figured out how to successfully install the Office 97 Pro Service Release 2 patch in Vista? 2. Has anyone successfully installed an Office 97 Pro CD (SR2 version) in...
1
by: Joel Fireman | last post by:
Help Needed: Upgrade Fedora 4 / Apache 2 to PHP 5.2.x from 5.0.4 I've been testing Joomla as a content manager for the County offices, and it looks pretty good. Unfortunately, I decided to...
0
by: DKn | last post by:
Hi all, I am trying to do Software upgradation using Win32_Product -Upgrade method in C#.Net. Here is the code. using System; using System.Management; using System.Windows.Forms;
3
by: Mark D Powell | last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4)...
1
by: Gordon Padwick | last post by:
I'm getting ready to upgrade from Windows Vista to Windows 7. I downloaded and installed the Windows 7 Upgrade Advisor. When I tried to run it, I received the message "Windows 7 Upgrade Advisor was...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.