Solved

How do I Resolve the "Data has Been Changed" Error

Posted on 2013-05-30
6
358 Views
Last Modified: 2013-06-03
I have created a form (see attached) where the user can input data from a spreadsheet into the appropriate table based on the option button selected.

The problem I am facing is that when the user selects any of the option buttons and does the import for the first time, it works fine. However, when they try to do it again with a different button, the error, "The Data Has Been Changed, Another User Edited This Record...".

It still works, but I do not want this message to keep popping up and am not sure how to resolve it.
Form-Error.jpg
0
Comment
Question by:geeta_m9
  • 3
  • 2
6 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 39208539
Without seeing your code it's hard to provide suggestions, but in general it's a good idea to do this before those types of operation:

If Me.Dirty Then Me.Dirty = False

This forces Access to save any changes, which can sometimes avoid that error.

You'll also get this error if you're trying to manipulate data in the records that are on the form, if those are dirty. In general you should either (a) perform all data manipulations in code or (b) perform all data manipulations through the form.

But again, without seeing the code it's hard to advise ....
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 39208545
You use the forms OnError event to check the errors and respond.

Two variables are passed in by Access; ErrNum and response.

Errnum is the error that the form encountered.

You set Response to tell Access what to do, which is either act normally (pop up a error message) or just continue (you will put up your own message).

Jim.
0
 

Author Comment

by:geeta_m9
ID: 39208554
Where would I put the code?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:geeta_m9
ID: 39208564
I am attaching two files. One is the form that has the option buttons and the other is the code in the module that it calls.
Form--Code.txt
Module-Code.txt
0
 
LVL 57
ID: 39208682
Hard to say.  Open the form and in the OnError event, place a STOP.

Then give it a go.   If you hit the stop, then the error is occuring in the form.

 If not, then it's in either one of your GetData... procedures or GetDataFromSpreadsheet().   Without any error handling (which you should add), there's no way to tell.

Jim.
0
 

Author Comment

by:geeta_m9
ID: 39216486
With your help, I managed to stop the error from popping up. On the "On Error" event of the form, I inserted the following code:

If DataErr = 7878 Then
        Me.Dirty = False
        Response = acDataErrContinue
End If
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question