Run-time error when closing the Notes field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Fixed bug}}  
{{Bug}}
The following error intermittently shows up for some collectors when using the '''Close Form''' button to exit out of the [[Notes field]] form:  
The following error intermittently shows up for some collectors when using the '''Close Form''' button to exit out of the [[Notes field]] form (ie the form that opens when you double-click the [[Notes field]]):  


[[File:Close notes run time error.gif|alt=Microsoft Visual Basic Run-time error '-2147352567 (80020009)': The data has been changed. ]]
[[File:Close notes run time error.gif|alt=Microsoft Visual Basic Run-time error '-2147352567 (80020009)': The data has been changed. ]]
:: Run-time error '-2147352567 (8020009)':
:: The data has been changed


I can't replicate this in my test version. Who all gets this, and does anyone know how to make it happen consistently?
== When does this happen? ==
*I get it whenever I enter something on the notes field and then exit it but do not have a [[WBC]] entered.--[[User:CMarks|CMarks]] 07:23, 2017 November 1 (CDT)
The error seems to happen if the Notes form is closed when certain Apache fields are not filled out yet.  
*I get it whenever I close the notes field  --[[User:Jvelasco|Jvelasco]] 07:39, 2017 November 6 (CST)


=== Fix ===
Some Apache fields are subject to [[Check APACHE physiological variable high low]] (if they are in an unlikely range, an entry in Notes is required). For Medicine collectors thisis often the [[WBC]] field. It appears that this somehow triggers the error, but I don't understand how and have not been able to fix it. Ttenbergen 10:44, 2019 September 12 (CDT)
Added a .requery before the code that runs cross checks against the new contents of the notes field.  
 
== Fix ==
*2019-09-11 - Joyce demonstrated this is still a problem.
*2017 sometime - Added a .requery before the code that runs cross checks against the new contents of the notes field.  


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}

Revision as of 09:51, 12 September 2019

The following error intermittently shows up for some collectors when using the Close Form button to exit out of the Notes field form (ie the form that opens when you double-click the Notes field):

Microsoft Visual Basic Run-time error '-2147352567 (80020009)': The data has been changed.

Run-time error '-2147352567 (8020009)':
The data has been changed

When does this happen?

The error seems to happen if the Notes form is closed when certain Apache fields are not filled out yet.

Some Apache fields are subject to Check APACHE physiological variable high low (if they are in an unlikely range, an entry in Notes is required). For Medicine collectors thisis often the WBC field. It appears that this somehow triggers the error, but I don't understand how and have not been able to fix it. Ttenbergen 10:44, 2019 September 12 (CDT)

Fix

  • 2019-09-11 - Joyce demonstrated this is still a problem.
  • 2017 sometime - Added a .requery before the code that runs cross checks against the new contents of the notes field.

Related articles

Related articles: