Hi,
I have a macro that runs when a button is clicked, this works fine initially. Eventually, over time (days/weeks), something goes wrong and it then causes the Access application to present the dialog box saying that it has stopped responding. I have this on a works networked PC and wonder if that can be the problem. I can fix it by opening the macro and resaving it (no changes required). This works on my version but not on other PC's often. Could this possibly be caused by O.S updates or overwriting the database with design changed version. The design changes not related to this button. I guess it is linked to some sort of verification step which maybe disrupted by something. Your help appreciated as it is becoming a pain to rectify.
Thanks
gadget01
my button code:
Private Sub Command87_Click()
strInput = InputBox("Please note:" & vbCrLf & "Using other than the green Data Entry buttons on this menu page to edit should not be done if your edit requires progressing the waste through one of the waste diposal steps" & vbCrLf & vbCrLf & "If you really must edit a waste item then beware of your actions.... " & vbCrLf & vbCrLf & "Enter Password:")
If strInput = "****" Then
DoCmd.OpenForm "Admin Menu"
Else: MsgBox ("Sorry, you do not have access privilege!"): Exit Sub
End If
End Sub