Error on acSendObject acSendQuery!!

[DaniBoy]

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.

 

[DaniBoy]

Now its working!!!

Well guys I have no idea what is going on here!!! I just redid the hole thing, from the button to the code and now its working!!!


OOOHHHHHHHH !!!! It kills me!!! jeje, but am happy that it works!! It was my goal for the weekend!!!

Thanks
DaniBoy