M
M_Hood
Hi,
I have created a DB (WinXPsp2 / MS Access 2003) but I am getting errors when
clicking on a simple Command. It is supposed to take me back to the Home Page
but presents me with a length error message :
"The expression On Click you entered as the event property setting produced
the following error: A problem occurred while MS Access was communicating
with the OLE Server or ActiveX Control"
I have checked the coding for this button and it matches all of the others,
which work fine. The coding is as below when viewing with Visual Basic:
Private Sub Command13_Click()
On Error GoTo Err_Command13_Click
DoCmd.Close
Exit_Command13_Click:
Exit Sub
Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click
End Sub
I have tried deleting and recreating the button without success. The PC is
up to date with Windows updates etc.
Can anyone give me an insight into this ?
Thanks in advance.
I have created a DB (WinXPsp2 / MS Access 2003) but I am getting errors when
clicking on a simple Command. It is supposed to take me back to the Home Page
but presents me with a length error message :
"The expression On Click you entered as the event property setting produced
the following error: A problem occurred while MS Access was communicating
with the OLE Server or ActiveX Control"
I have checked the coding for this button and it matches all of the others,
which work fine. The coding is as below when viewing with Visual Basic:
Private Sub Command13_Click()
On Error GoTo Err_Command13_Click
DoCmd.Close
Exit_Command13_Click:
Exit Sub
Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click
End Sub
I have tried deleting and recreating the button without success. The PC is
up to date with Windows updates etc.
Can anyone give me an insight into this ?
Thanks in advance.