L
lj
Here's something odd that happened:
I'm in the process of testing out my application, trying to make sure that
I've trapped for all the errors the end user could make. I tried to close a
form without having entered information in a field that is required.
Sure enough, an error popped up, with MyAppName in the title bar, telling me
that:
Microsoft Jet engine could not find a record in the table tblTableName with
key matching field(s) 'FieldName'.
Since it had no number, I hit the help button to see if Help would give me
an error number. It did (Error 3101). Great. So I tried to close Help.
It would not close. I escaped out of the offending record, closed the form,
closed the database (which closes Access). Help still wouldn't close.
Finally, I used the End Process button on the Task Manager.
What would cause that behavior?
And a related question:
I have a custom error message (in the BeforeUpdate event of this field) if
the user tries to move to the next field without filling it in; that works
fine. But if he just decides to close the form, I get the generic message
listed above, even though I put code in the FormClose event with that
specific error number and my custom message.
Any suggestions? For further info, it is Access 2003; and the field in
question is on a datasheet subform.
lj
I'm in the process of testing out my application, trying to make sure that
I've trapped for all the errors the end user could make. I tried to close a
form without having entered information in a field that is required.
Sure enough, an error popped up, with MyAppName in the title bar, telling me
that:
Microsoft Jet engine could not find a record in the table tblTableName with
key matching field(s) 'FieldName'.
Since it had no number, I hit the help button to see if Help would give me
an error number. It did (Error 3101). Great. So I tried to close Help.
It would not close. I escaped out of the offending record, closed the form,
closed the database (which closes Access). Help still wouldn't close.
Finally, I used the End Process button on the Task Manager.
What would cause that behavior?
And a related question:
I have a custom error message (in the BeforeUpdate event of this field) if
the user tries to move to the next field without filling it in; that works
fine. But if he just decides to close the form, I get the generic message
listed above, even though I put code in the FormClose event with that
specific error number and my custom message.
Any suggestions? For further info, it is Access 2003; and the field in
question is on a datasheet subform.
lj