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!!!
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!!!