Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SendObject error 2282 in XP 2

Status
Not open for further replies.

bouyelas

Programmer
Joined
Nov 11, 2003
Messages
3
Location
US
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
 
Have you applied Office Service Pack 3? This would have fixes for XP related bugs.
 
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
 
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.
 
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]



[pipe]
Daniel Vlas
Systems Consultant

 
Daniel,

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

Greg
 
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".
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top