I got an access application running, the users are redirected to the different forms through a menu...
When a user opens a form and closes it again, the form is simply made invisible but is not 'closed' so to speak, when the user clicks the specific menu item again, the menu is shown again...
Now sometimes after some time a user gets "Action cannot be performed" each time he clicks one of the menu items, no matter which one, and access needs to be closed with ctrl-alt-del and reopenend before he can continue to use the application
The onClick procedure has the following code:
What causes this and how can I solve it?
Is it the fact that the forms aren't closed (but made invisible) and reopened with DoCmd.OpenForm ? (I doubt it as most of the time opening & reopening all works fine) ...
Plz help
TIA
When a user opens a form and closes it again, the form is simply made invisible but is not 'closed' so to speak, when the user clicks the specific menu item again, the menu is shown again...
Now sometimes after some time a user gets "Action cannot be performed" each time he clicks one of the menu items, no matter which one, and access needs to be closed with ctrl-alt-del and reopenend before he can continue to use the application
The onClick procedure has the following code:
Code:
Private Sub CMDOpenBestelbon_Click()
On Error GoTo Err_CMDOpenBestelbon_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Bestelbon"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_CMDOpenBestelbon_Click:
Exit Sub
Err_CMDOpenBestelbon_Click:
MsgBox Err.Description
Resume Exit_CMDOpenBestelbon_Click
End Sub
What causes this and how can I solve it?
Is it the fact that the forms aren't closed (but made invisible) and reopened with DoCmd.OpenForm ? (I doubt it as most of the time opening & reopening all works fine) ...
Plz help
TIA