acSendReport Problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top