Is this one query in a multi-query Macro? If so on the first line of the Macro you can use the Setwarnings command and set it to NO
At the end of the Macro again add the Setwarnings command and set it to YES
This change will effectively skip interactive user messages/warnings.
Basically the error is thrown by the mail_proc_beta stored procedure below which is a package of stored procedures. Any subsequent procedures are then obivously not run because of the error.
The error CAN be safely ignored I just need to know how.
Private Sub Command49_Click()
On Error GoTo Err_Command49_Click
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSql As String
Set db = CurrentDb()
Set qdf = db.QueryDefs("qryStoredProcNoRecReturn")
Select Case Frame24.Value
Case 1
strSql = "exec mail_proc_beta " & Me.Combo10
Case 2
strSql = "exec mail_email_beta " & Me.Combo10
Case 3
strSql = "exec mail_sms_beta " & Me.Combo10
End Select
qdf.SQL = strSql
DoCmd.OpenQuery "qryStoredProcNoRecReturn"
Set db = Nothing
Set qdf = Nothing
Exit_Command49_Click:
Exit Sub
Err_Command49_Click:
MsgBox Err.Description
Resume Exit_Command49_Click
End Sub
