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 the one I am going to describe below before the current version of Windows 10.When by mistake a data type different from the one provided for is inserted in a field an error message pops up saying "you must enter a value in the field, with two buttons 'OK' and "Help" at the bottom of the error screen. When OK or cross at the top right of the screen is clicked the error screen should go to enable entry of correct data in the related field. But this does not happen; the screen only blinks when either the OK button below or the cross on the top right is clicked. I tried several times with the same result. I went for the online repair of Office 365 and tried again but the result had been the same. Request a solution as early as possible from anyone in the tech community.

Ajoy Das Which event triggers this error? It could be that you are in a loop where the error is raised over and over because you need to undo a control that has the invalid attempted value in it, but until you remove that invalid value, the same error is raised again. I'm thinking perhaps a Before Update event would be the most likely.

George_HepworthHi George No, this is not a loop event. It occurred when I opened the Access app and was entering the first record of the day while erroneously entered a data of type different from what was set up for that field. No. It was not Before the Update situation. The office 365 and Windows update were both up-to-date when this happened. George_Hepworth

Ajoy Das Sorry, perhaps I was not as clear as I hoped. I'm not talking about an update to the software. I'm talking about an Update event in a control on the form. Like this example, where failing to cancel and undo the attempted invalid entry sends the event into a loop as it tries to update, can't because of the response to the question, but still has the wrong value, so it triggers the before update event again. Private Sub cboTestTimeOfDayID_BeforeUpdate(Cancel As Integer)Dim lngMealItemCount As Long With Me If MsgBox(Prompt:="Click ""Yes"" to confirm you want to change this meal.", _ Buttons:=vbYesNo + vbCritical, _ title:="Change a Saved Meal?") = vbNo Then Cancel = True .cboTestTimeOfDayID.Undo End If End WithExit SubEnd Sub

Hi GeorgeI 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.UndoCancel 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.

Access error screen does not close after Ok button of error message is clicked

14 Replies

BeverlyJMcK
Copper Contributor
Jul 31, 2023
Ajoy Das
I found that if I hold the Esc key for a couple of seconds the error goes away.
Isla37
Copper Contributor
Jun 20, 2023
Hello,

Has a solution been found? I'm going through the exact same thing and ive been all night trying to figure out how to fix it, When i press and hold ESC it would get out of the warning message but would delete some data along. Someone please help!!!!!!
HaNguyen1207
Copper Contributor
May 03, 2023
I also encounter the same issue. Did you find a solution to this? Please tell me if you did!
cclee470
Copper Contributor
Apr 16, 2023
I encountered the same problem. Did you find a fix for it?
George_Hepworth
Silver Contributor
Feb 25, 2021
Ajoy Das
Which event triggers this error? It could be that you are in a loop where the error is raised over and over because you need to undo a control that has the invalid attempted value in it, but until you remove that invalid value, the same error is raised again. I'm thinking perhaps a Before Update event would be the most likely.
- Ajoy Das
  Copper Contributor
  Feb 25, 2021
  George_Hepworth
  Hi George
                  No, this is not a loop event. It occurred when I opened the Access app and was entering the first record of the day while erroneously entered a data of type different from what was set up for that field.
                  No. It was not Before the Update situation. The office 365 and Windows update were both up-to-date when this happened.
  
  
  George_Hepworth
  - George_Hepworth
    Silver Contributor
    Feb 25, 2021
    Ajoy Das
    Sorry, perhaps I was not as clear as I hoped. I'm not talking about an update to the software. I'm talking about an Update event in a control on the form. Like this example, where failing to cancel and undo the attempted invalid entry sends the event into a loop as it tries to update, can't because of the response to the question, but still has the wrong value, so it triggers the before update event again.
    
    Private Sub cboTestTimeOfDayID_BeforeUpdate(Cancel As Integer)
    Dim lngMealItemCount As Long
    
    With Me
    If MsgBox(Prompt:="Click ""Yes"" to confirm you want to change this meal.", _
    Buttons:=vbYesNo + vbCritical, _
    title:="Change a Saved Meal?") = vbNo Then
    Cancel = True
    .cboTestTimeOfDayID.Undo
    End If
    End With
    Exit Sub
    
    End Sub

Forum Discussion

Access error screen does not close after Ok button of error message is clicked

14 Replies

Resources