Jim DeMarco
Jdemarco at hudsonhealthplan.org
Tue Dec 6 12:17:09 CST 2005
Just a thought but I seem to recall a similar situation where an event was not firing. It turned out to be some bad code that wouldn't compile but the syntax checker didn't catch. You could try choosing the compile all loaded modules menu item and see what happens. Just a WAG really. HTH, Jim DeMarco -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Robert Gracie Sent: Tuesday, December 06, 2005 12:17 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Form_Error event will NOTalways fire Hello Bobby, Thanks for the reply. Yes I realize trapping errors before they escalate to the form_error event is best. However I make use of a fairly extensive error handler in the forms error event so I don't have to trap common errors at each control. Works perfectly, that is when the event fires... :-) I "Think" I found the cause of the problem, but I won't know for sure until it happens again. (Very Intermittent) Thanks Again! Robert Gracie www.servicexp.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Tuesday, December 06, 2005 8:01 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form_Error event will NOTalways fire Are you saying that you handle all errors at the form level? Could it be that an error is happening in code and is caught and processed so that the form error event is not fired? I never use the Form_Error event. I perform validation/error handling in code tied to the individual control itself or in a module. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Gracie Sent: Monday, December 05, 2005 9:40 PM To: Access Developers discussion and problem solving Subject: [AccessD] Form_Error event will NOTalways fire What would cause the Form_Error event NOT to fire.. I have been having a problem with this, and can't get a handle on it.. Example, The user enters an invalid item in a combo (limit to list = Yes) the user goes to move from that control and is unable to, the problem is the Form_Error event VERY intermittently does not fire notify the user of the problem. So the user thinks the system is locked up... This is system wide and not just one or two forms.. SetWarning is NOT the problem... Any Ideals Robert Gracie www.gbsysnow.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************