P
pjscott
I’m running WinXP sp2 on 200 plus computers. I’m using sql 2000 w/ Access 2002.
I have a form with a command button that when clicked sends a report via
Outlook. I’m using the following code to do this:
DoCmd.SendObject acSendReport, "rptMaintWO", acFormatRTF, "E-mail Address",
, , "Maintenance Work Order", , False
The problem I’m having is the code works on some computers but not others.
When you click the button on the computers that the code doesn’t work the
button depresses but that’s all. It sits there like there’s no code attached
to the command button.
If I run the code below it works on all computers. This code sends an e-mail
but doesn’t send the report.
DoCmd.SendObject , "rptMaintWO", acFormatRTF, "E-mail Address", , ,
"Maintenance Work Order", , False
The only difference in the 2 codes is the acSendReport.
Can anyone tell me why the acSendReport would be causing any problems?
Thanks for the help,
Paul
I have a form with a command button that when clicked sends a report via
Outlook. I’m using the following code to do this:
DoCmd.SendObject acSendReport, "rptMaintWO", acFormatRTF, "E-mail Address",
, , "Maintenance Work Order", , False
The problem I’m having is the code works on some computers but not others.
When you click the button on the computers that the code doesn’t work the
button depresses but that’s all. It sits there like there’s no code attached
to the command button.
If I run the code below it works on all computers. This code sends an e-mail
but doesn’t send the report.
DoCmd.SendObject , "rptMaintWO", acFormatRTF, "E-mail Address", , ,
"Maintenance Work Order", , False
The only difference in the 2 codes is the acSendReport.
Can anyone tell me why the acSendReport would be causing any problems?
Thanks for the help,
Paul