Hi ive got an access database that has been working for ages but today
it has stopped working.
On a form i have a button that when clicked should print a report.
However, i get an error ODBC -- Call Failed.
The code for the button is
Private Sub AcceptPrintbtn_Click()
On Error GoTo Err_AcceptPrintbtn_Click
Dim stDocName As String
stDocName = "RPTAcceptanceLetter"
DoCmd.OpenReport stDocName, acPreview
Exit_AcceptPrintbtn_Click:
Exit Sub
Err_AcceptPrintbtn_Click:
MsgBox Err.Description
Resume Exit_AcceptPrintbtn_Click
End Sub
Any ideas??