By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

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

P: 12
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.TotalSF12Score = Format(SF12Score, "Fixed")" when I press debug.

Please help. Thanks a bunch.
Feb 5 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 446
Hi

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

Googling this error number returned; -
"Run time error '-2147352567(80020009)' : 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.TotalSF12Score ??

S7
Feb 5 '08 #2

Post your reply

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