473,748 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help with Run-time Error '-2147352567 (80020009)'

12 New Member
When I try and run a code, I get:

Run-time Error '-2147352567 (80020009)':
The data has been changed.

My code is:
Expand|Select|Wrap|Line Numbers
  1. Dim rsSF12 As DAO.Recordset
  2.  
  3. Dim SF12Score As Double
  4.  
  5. SF12Score = 0
  6.  
  7. SF12Score = SF12Score + Me.Q1Score
  8. SF12Score = SF12Score + Me.Q2Score
  9. SF12Score = SF12Score + Me.Q3Score
  10. SF12Score = SF12Score + Me.Q4Score
  11. SF12Score = SF12Score + Me.Q5Score
  12. SF12Score = SF12Score + Me.Q6Score
  13. SF12Score = SF12Score + Me.Q7Score
  14. SF12Score = SF12Score + Me.Q8Score
  15. SF12Score = SF12Score + Me.Q9Score
  16. SF12Score = SF12Score + Me.Q10Score
  17. SF12Score = SF12Score + Me.Q11Score
  18. SF12Score = SF12Score + Me.Q12Score
  19.  
  20. Me.TotalSF12Score = Format(SF12Score, "Fixed")
  21.  
it also highlights "Me.TotalSF12Sc ore = Format(SF12Scor e, "Fixed")" when I press debug.

Please help. Thanks a bunch.
Feb 5 '08 #1
1 7985
sierra7
446 Recognized Expert Contributor
Hi

Is 'The data has been changed' part of the error message?

Googling this error number returned; -
"Run time error '-2147352567(8002 0009)' : Method '~' of object '~' failed"

You are trying to created a DAO.Recordset object... do you have a reference to Microsoft DAO 3.6 Object Library ??

and why are you creating it if you are not using it ??

What version of Access are you using ??

Approx what value do you expect in Me.TotalSF12Sco re ??

S7
Feb 5 '08 #2

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

Similar topics

1
75017
by: Peter | last post by:
I have a program which was working fine. In it a function works out the number of .jpg files in a specified folder. I then realised that I needed to make sure the folder exists first & added the code for this. After this I get the Runtime Error 91 - Object variable not set. I've rem'd out my added code to no avail. Tried rebooting to. The earlier exe version of the program continues to work OK. The code in question is shown below. I'd...
1
1529
by: Robert McGregor | last post by:
Hey everyone, I'm trying to email from access and i want email the contents of one field with a subject of another to the owner of a final field. I think i've referred to everything correctly in the ocde below but I get an error message: Run-time error '-2147352567 (800200009)':
4
1558
by: VB Programmer | last post by:
If I try ANY aspx pages on my server, even INVALID, bogus pages, I get a "Runtime Error". Any idea why? Here is the full message: Server Error in '/' Application. ---------------------------------------------------------------------------- ----
12
26813
by: Kevin Farless | last post by:
Hi all, I'm having trouble viewing any .aspx pages on my hosting company's server. The server is a new box running Windows Server 2003 default installation. I'm the first client to try using ASP.NET on this box and the administrator of the server has never setup an ASP.NET site before, so most likely the problem I'm experiencing is server settings related. Note in the Web.config below that the <customErrors mode="Off"/> is present,...
2
2131
by: Massimo Soricetti | last post by:
Hello, I'm trying to fix this little class: <code> #include <ifstream> #include <iostream> #include <iomanip> using namespace std;
0
1813
by: Terry Tang | last post by:
Hi There, We are extending Python interpreter to support special functions of our tools. What we did is to compile Python's source code (which is got from the an installation on a Linux environment for Python 2.3.3) and our extensions (C++ code) on Windows with Microsoft Visual C++ 6.0 compiler to generate the extended Python interpreter. It works well on Linux and for the basic Python modules and our special modules on Windows. But...
4
5240
by: news.citenet.net | last post by:
I keep getting the following error message after my web site running 2 or 3 days I share one folder with about 200 domain names Any one can help? --------------------------------------------------------------------------------
8
13102
by: g_man | last post by:
I am trying trap Runtime error 3022 (duplicates) in the click event of a command button that closes the form. I have code in the Form_Error event that does a good job of providing a more meaningful error message than the default. It works in every situation except when the user clicks the close button. I am using Me.Dirty=False to force a save but if there are duplicates I just get the standard Runtime 3022 error message. I am wondering...
1
4400
by: eneyardi | last post by:
Update or CancelUpdate without AddNew or Edit How to subtract date and the result will be number of days? Coz i have a table name tblDate, fieldname subject, date received, date release and no. of days elapsed,. I have a form name DTS Entry, textbox name subject, date received, date released and no. of days released. the data type of subject is text, the date received and date released are date/time, and the no. of days elapsed is text. the...
0
8991
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9544
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9372
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9324
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8243
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6796
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
3313
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2783
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2215
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.