DaniBoy
Registered User.
- Local time
- Today, 16:42
- Joined
- Nov 18, 2001
- Messages
- 175
Hello
I dont know what seems to be going on today!!! I am getting realy frustrated!!! Well here it is!!!:
I have a button to send an email and the codes goes like this
Private Sub Command75_Click()
On Error GoTo Err_Command75_Click
Dim stdocname As String
stdocname = "Workorder List"
DoCmd.SendObject acSendQuery, stdocname
Exit_Command75_Click:
Exit Sub
Err_Command75_Click:
MsgBox Err.Description
Resume Exit_Command75_Click
End Sub
When I click on the button I get one of those anoying new error messeges from windows, "the ones that you send the info to them" and it restarts my DB. So I change the code to acSendTable and it works fine.
Any Idea on what am doing wrong?
ohh am sending that query to an Excel File 97-2000, it gets to the point that it asks me to what file I want it, then I pick Excel 97-2000 and the error comes up.
I dont know what seems to be going on today!!! I am getting realy frustrated!!! Well here it is!!!:
I have a button to send an email and the codes goes like this
Private Sub Command75_Click()
On Error GoTo Err_Command75_Click
Dim stdocname As String
stdocname = "Workorder List"
DoCmd.SendObject acSendQuery, stdocname
Exit_Command75_Click:
Exit Sub
Err_Command75_Click:
MsgBox Err.Description
Resume Exit_Command75_Click
End Sub
When I click on the button I get one of those anoying new error messeges from windows, "the ones that you send the info to them" and it restarts my DB. So I change the code to acSendTable and it works fine.
Any Idea on what am doing wrong?
ohh am sending that query to an Excel File 97-2000, it gets to the point that it asks me to what file I want it, then I pick Excel 97-2000 and the error comes up.