Lost and Confused in Macro/Module Land

muscle

New member
Local time
Today, 09:56
Joined
Mar 25, 2002
Messages
9
I have the following in my Access 2000 DB...

One Macro named "Report" with a RunCode action and the following Function Name - OutputToReport()

One Module named "Module1" comprised of the following code...

Function OutputToReport()
DoCmd.OutputTo acOutputReport, "Budget Summary Report", acFormatXLS, "D:\Reports\Budget_Summary" & Format(Date, "yyyymmdd") & ".xls"
DoCmd.OutputTo acOutputReport, "PO Tracker", acFormatXLS, "D:\Reports\PO_Tracker" & Format(Date, "yyyymmdd") & ".xls"
DoCmd.OutputTo acOutputReport, "BCER-PO Summary", acFormatXLS, "D:\Reports\BCER-PO_Summary" & Format(Date, "yyyymmdd") & ".xls"
End Function

For some reason only the first report will process then I get a Run-time error '3343'
Unrecognized database format. Any ideas. Thanks beforehand!!!
 

Users who are viewing this thread

Back
Top Bottom