SendObject function attaches report in the Wrong Format

B

Bill Johnson

What is puzzling, is this function was working up until Access crashed one
time. I performed the Database repair and now instead of attaching the
report in SNP format, it enters a default Naming Convention (like CDB35.XLS)
and an Excel extension.

DoCmd.SendObject acSendReport, stDocName, acFormatSNP, msgTo, msgCC, msgBCC,
msgSub, msgBod

I'm really confused because another report procedure in the same database
uses a procedure with very similar code that works perfectly, and if I run
this procedure from another workstation it works perfectly as well. I'm
sending the email and report to Lotus Notes. Have you seen this before?
 
B

Bill Johnson

I was able to fix this by changing the Report Caption (the name that Access
uses when attaching the report) in the Report Properties. It doesn't
explain why the problem began in the first place, or why it should work on
another workstation, but it is something I've noted in the VB code in case it
ever comes up again.
 
C

cameronw

Bill Johnson wrote on 02/06/2005 11:43 ET
I was able to fix this by changing the Report Caption (the name that Acces
uses when attaching the report) in the Report Properties. It doesn'
explain why the problem began in the first place, or why it should work o
another workstation, but it is something I've noted in the VB code in case i
ever comes up again
This happened to me because my mail application crashed while trying to sen
on
of these and the previous file got stuck in my temp directory

Check for the file name it's trying to send in <home>/local settings/tem
(or just clear that entire directory

This resolved it for me.
 

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