It seems that there are occasions when users of my EXEs get the gray "Program Error" box with a message like:
Target Table is already engaged in a relation
along with choices to Cancel, Ignore, etc.
Now, I have an "ON ERROR" which is supposed to shield the users from such programmer-nonsense, either by attempting to correct the problem, or, more likely, to save some relevant information for me to fix.
First question: Why in the world does the user get this message? In my EXEs, I
never want my users to see such balderdash.
Second question: When I run this in my development environment, I get the same message box, with the option to Suspend -- but suspending does
not leave at the offending line of code (which, so far, I am unable to discover).
Third (related question): There seem to be a slew of related program errors which give error messages without providing any debugging assistance ... my favorite has to do with a failed DynamicBackColor ... I learn that it has failed, but there is no indication for which column. Is there any hope of getting error messages that provide enough information as to actually learn where the error is occurring?
Thanks.
Jim Nelson
Newbury Park, CA