OutputTo Error in A2007

[Tom Ventouris]

I have a function on my Ribbon to send the active report to Snapshot.

DoCmd.OutputTo acOutputReport, "", "SnapshotFormat(*.snp)", "", False, "",
0, _
acExportQualityPrint

This works fine when I open with ShiftKey to test, but returns an error when
opening the DB without the shifkey.

Error 2487 - The object type argument for the action is blank or invalid.

Any suggestions will be appreciated.

 

[Tom Ventouris]

Resolved.

it seems A2007 will not output the active report when the report name is
left balnk, like earlier versions. I used Screen.ActiveReport.Name to do the
job:

DoCmd.OutputTo acOutputReport, Screen.ActiveReport.Name,
"SnapshotFormat(*.snp)", "", False, "", 0, acExportQualityPrint