P
pubdude2003 via AccessMonster.com
Hey all, trying to run a report in an MDB from an MDE and it is failing with
a 2501 the CopyObject was cancelled.
Any thoughts anyone?
'Set myApp = New Access.Applic ation
'myApp.OpenCurrentDatabase ("C:\mydb\Reports.mdb")
'myApp.DoCmd.CopyObject "C:\mydb\Reports.mdb", "Report - " & ReportName,
acReport, "report1"
'myApp.OpenReport "Report - " & ReportName, acViewNormal, "", "", acHidden
'myApp.Close acReport, "Report - " & ReportName
'Pause 1000
'myApp.OpenReport "Report - " & ReportName, acViewNormal, "", "", acHidden
'myApp.Close acReport, "Report - " & ReportName
'my.app.DeleteObject acReport, "Report - " & ReportName
'myApp.CloseCurrentDatabase
a 2501 the CopyObject was cancelled.
Any thoughts anyone?
'Set myApp = New Access.Applic ation
'myApp.OpenCurrentDatabase ("C:\mydb\Reports.mdb")
'myApp.DoCmd.CopyObject "C:\mydb\Reports.mdb", "Report - " & ReportName,
acReport, "report1"
'myApp.OpenReport "Report - " & ReportName, acViewNormal, "", "", acHidden
'myApp.Close acReport, "Report - " & ReportName
'Pause 1000
'myApp.OpenReport "Report - " & ReportName, acViewNormal, "", "", acHidden
'myApp.Close acReport, "Report - " & ReportName
'my.app.DeleteObject acReport, "Report - " & ReportName
'myApp.CloseCurrentDatabase