SendObject error 2282 in XP 2

[bouyelas]

I get this error only in XP for the code below. It works fine in Win98. I am using Access 2000.

"The format in which you are attempting to output the current job is not available"

DoCmd.SendObject acSendReport, "rpt", acFormatXLS, _
"info@gb.com", , , "REPORT", , False

Thanks,
Greg

 

[vbajock]

Have you applied Office Service Pack 3? This would have fixes for XP related bugs.

 

[bouyelas]

VBA Jock: I am actually running Office XP on this machine. I installed all of the Office XP updates, including Office Service Pack 2 for XP. I still get the error message. If I leave the format field blank, a 'select file type' window pops up. After selecting Excel, the message sends fine. The problem is I need this to be automatic.

Any ideas are greatly appreciated.

Thanks

 

[vbajock]

I haven't seen much on the web about this error, and I've never seen it personally. You might need to call MS on this one.

 

[danvlas]

He he I've just come across this problem some 2 weeks ago...

While asking Access XP for ?acFormatXLS returns
Microsoft Excel (*.xls),
the registry reads:
Microsoft Excel Biff5 (*.xls)
for XL 5-7, and
Microsoft Excel Biff8 (*.xls)
for XL 97-2002

I have no clue what the darn Biff stands for...

So...
DoCmd.SendObject acSendReport, "rpt", "Microsoft Excel Biff5 (*.xls)", _
"info@gb.com", , , "REPORT", , False
should (and does) work in XP. But it doesn't in Access 2000.

Go figure, Microsoft [LOL]




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[bouyelas]

Daniel,

You are the man! It works like a charm. Thank you very much!

Greg

 

[vbajock]

Wasn't Biff the bully in Back to the Future? Dan, you might want to email that to ms support. I searched their web site on that error and found zilch, apparently they don't even know about it. Of course, I am also wondering if they have a programmer named "Biff".

 

[danvlas]

I never mail MS. Simply because they don't give a dime...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[vbajock]

Maybe MS is "Biff"