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!

Register Log in
  • 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!

acFormatXLS in docmd.sendobject error 2282

Status
Not open for further replies.
Beantree

Beantree

Programmer
Joined
Feb 27, 2001
Messages
95
Location
US
When I use the docmd.sendobject method to send a report in Excel format, I get run time error 2282, output format not available.

If I leave the output format arguement blank so it prompts me, and then I choose xls, it works.

The docmd.outputto method works fine with acFormatXLS.

This is in Access 2002.

Thanks
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question Question
Error 2004
Replies
2
Views
635
lameid
lameid
renigar
  • Locked
  • Question Question
Access VBA Syntax Error
Replies
5
Views
5K
Andrzejek
Andrzejek
renigar
  • Locked
  • Question Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar
Bubba002
  • Locked
  • Question Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
2K
dhookom
dhookom
PizMac
  • Locked
  • Question Question
error 3027 database or object is read-only
Replies
5
Views
966
PizMac
PizMac

Part and Inventory Search

Sponsor

Back
Top