Forum Discussion
Access error screen does not close after Ok button of error message is clicked
Access error screen does not close after the OK button of the error message is clicked I have been using Microsoft Office and Access for decades, But have never before faced a problem like th...
Hi George
I am sorry I am not a technical person and as such not in a position to understand what you have meant to say. I wou[d be thankful if you kindly guide me in layman's language as to how to I can resolve this issue, whatever be the reasons. As I have said, I have been using MS Access for decades but have never before come across such a problem. In the alternative, you may advise if you are aware, of how to contact MS Access Support staff for a chat session for resolving this issue. I had tried through the Access Help option but the lady support staff to whom the chat session was entrusted by MS said I had landed in the Download and installation wing of office 365. As advised by her, I have brought the matter here for a plausible solution
I am sorry I am not a technical person and as such not in a position to understand what you have meant to say. I wou[d be thankful if you kindly guide me in layman's language as to how to I can resolve this issue, whatever be the reasons. As I have said, I have been using MS Access for decades but have never before come across such a problem. In the alternative, you may advise if you are aware, of how to contact MS Access Support staff for a chat session for resolving this issue. I had tried through the Access Help option but the lady support staff to whom the chat session was entrusted by MS said I had landed in the Download and installation wing of office 365. As advised by her, I have brought the matter here for a plausible solution
Again, apologies for the lack of clarity. What I meant is that the error is possibly (probably) caused when the Before Update event of that control runs because the value attempted is not valid. That triggers the error message. In the meantime, however, Access has tried to move focus to a new control, possibly because you clicked or tabbed to it. But it can't move focus because of that error, so the error message is displayed again, and into the loop it goes.
Note that, in my example, I highlighted two lines of code.
Cancel = True
.cboTestTimeOfDayID.Undo
Cancel stops the event from firing. Undo removes the invalid entry from the control. Together, they should forestall the repeated error.
However, I'm really only guessing based on experience. Try it out and see what results you get.
Note that, in my example, I highlighted two lines of code.
Cancel = True
.cboTestTimeOfDayID.Undo
Cancel stops the event from firing. Undo removes the invalid entry from the control. Together, they should forestall the repeated error.
However, I'm really only guessing based on experience. Try it out and see what results you get.
No really. You may try restarting the computer at that stage. It might work.
- restarting didn't work, is there any other ways?
Ajoy Das It seems like that is the only way.. Thank you for your reply!
