Run-time error when closing the Notes field - Revision history

Ttenbergen: Text replacement - "cross checks" to "cross checks"

2025-06-20T19:25:44Z

Text replacement - "cross checks" to "cross checks"

← Older revision		Revision as of 14:25, 20 June 2025
Line 16:		Line 16:
	*2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery		*2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery
	*2018-10-30 - took out the requery because it was "causing other issues" (there is no record of what issues); after that this is still a problem, but Tina forgot to change this error report for it		*2018-10-30 - took out the requery because it was "causing other issues" (there is no record of what issues); after that this is still a problem, but Tina forgot to change this error report for it
	*2017 sometime - Added a .requery before the code that runs cross ~~checks~~ against the new contents of the notes field.		*2017 sometime - Added a .requery before the code that runs [[cross check]]s against the new contents of the notes field.

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

Ttenbergen: /* Fix */

2022-05-31T18:37:41Z

Fix

← Older revision		Revision as of 13:37, 31 May 2022
Line 12:		Line 12:

	== Fix ==		== Fix ==
			* 2022-05-31 - updated Private Sub Command1_Click() that closes the Notes form to requery the notes field
	*2019-09-16 - The requery meant that collectors would be booted out of the record and into a blank one each time leaving the notes field - worse than the original bug. So, reverted that change, and bug persists.		*2019-09-16 - The requery meant that collectors would be booted out of the record and into a blank one each time leaving the notes field - worse than the original bug. So, reverted that change, and bug persists.
	*2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery		*2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery

Ttenbergen at 15:31, 16 September 2019

2019-09-16T15:31:14Z

← Older revision		Revision as of 10:31, 16 September 2019
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 (ie the form that opens when you double-click the [[Notes field]]):		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]]):

Line 12:		Line 12:

	== Fix ==		== Fix ==
			*2019-09-16 - The requery meant that collectors would be booted out of the record and into a blank one each time leaving the notes field - worse than the original bug. So, reverted that change, and bug persists.
	*2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery		*2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery
	*2018-10-30 - took out the requery because it was "causing other issues" (there is no record of what issues); after that this is still a problem, but Tina forgot to change this error report for it		*2018-10-30 - took out the requery because it was "causing other issues" (there is no record of what issues); after that this is still a problem, but Tina forgot to change this error report for it

Ttenbergen at 15:56, 12 September 2019

2019-09-12T15:56:06Z

← Older revision		Revision as of 10:56, 12 September 2019
Line 1:		Line 1:
	{{~~Bug~~}}		{{Fixed bug}}
	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]]):		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]]):

Ttenbergen: /* Fix */

2019-09-12T15:55:19Z

Fix

← Older revision		Revision as of 10:55, 12 September 2019
Line 12:		Line 12:

	== Fix ==		== Fix ==
	*2019-09-11 - Joyce demonstrated this is still a problem.		*2019-09-12 - Joyce demonstrated this is still a problem. Restored the requery, but as a form_view.requery rather than a docmd.requery
	*2018-10-30 - took out the requery because it was causing other issues; after that this is still a problem, but Tina forgot to change this error report for it		*2018-10-30 - took out the requery because it was "causing other issues" (there is no record of what issues); after that this is still a problem, but Tina forgot to change this error report for it
	*2017 sometime - Added a .requery before the code that runs cross checks against the new contents of the notes field.		*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}}

Ttenbergen: /* Fix */

2019-09-12T15:52:16Z

Fix

← Older revision		Revision as of 10:52, 12 September 2019
Line 13:		Line 13:
	== Fix ==		== Fix ==
	*2019-09-11 - Joyce demonstrated this is still a problem.		*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.		*2018-10-30 - took out the requery because it was causing other issues; after that this is still a problem, but Tina forgot to change this error report for it
			*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}}

Ttenbergen at 15:51, 12 September 2019

2019-09-12T15:51:03Z

← Older revision		Revision as of 10:51, 12 September 2019
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}}

Ttenbergen at 15:53, 7 March 2019

2019-03-07T15:53:59Z

← Older revision		Revision as of 10:53, 7 March 2019
Line 1:		Line 1:
	{{~~Bug needing input~~}}		{{Fixed 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:

Line 7:		Line 7:
	*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)		*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)
	*I get it whenever I close the notes field --[[User:Jvelasco\|Jvelasco]] 07:39, 2017 November 6 (CST)		*I get it whenever I close the notes field --[[User:Jvelasco\|Jvelasco]] 07:39, 2017 November 6 (CST)

			=== Fix ===
			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}}

Ttenbergen at 15:47, 7 March 2019

2019-03-07T15:47:06Z

← Older revision		Revision as of 10:47, 7 March 2019
Line 1:		Line 1:
	{{Bug needing input}}		{{Bug needing input}}
	The following error intermittently shows up for some collectors when using the '''Close Form''' button to exit out of the [[Notes field]]:		The following error intermittently shows up for some collectors when using the '''Close Form''' button to exit out of the [[Notes field]] form:

	[[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. ]]

Ttenbergen: links

2019-03-07T15:45:47Z

links

← Older revision		Revision as of 10:45, 7 March 2019
Line 1:		Line 1:
	{{Bug needing input}}		{{Bug needing input}}
	The following error intermittently shows up for some collectors when using the '''Close Form''' button to exit out of the Notes field:		The following error intermittently shows up for some collectors when using the '''Close Form''' button to exit out of 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. ]]

	I can't replicate this in my test version. Who all gets this, and does anyone know how to make it happen consistently?		I can't replicate this in my test version. Who all gets this, and does anyone know how to make it happen consistently?
	*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)		*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)
	*I get it whenever I close the notes field --[[User:Jvelasco\|Jvelasco]] 07:39, 2017 November 6 (CST)		*I get it whenever I close the notes field --[[User:Jvelasco\|Jvelasco]] 07:39, 2017 November 6 (CST)

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