sodochartaigh
New member
- Local time
- Today, 02:12
- Joined
- Jan 9, 2012
- Messages
- 2
Hi there,
Should be relatively simple one this, but its just not working.
We've upgraded from 2003 to 2007 in our office, and have many links to reports that need to be printed. The code is fairly simple:
DoCmd.OpenReport "RiskAssess", acViewNormal
printcode
Trouble is I get the "Runtime error 2501 - openform action was canceled" error. Double clicking on the guilty report in the navigation gives the following error
"The expression On Open you entered as the event property setting produced the following error: A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control"
This now occurs for all reports in the database.
Can anyone shed some light as to why our once-working reports now do not work? I've checked the syntaz and apparently the command shouldn't be any different
Thanks
Jim
Should be relatively simple one this, but its just not working.
We've upgraded from 2003 to 2007 in our office, and have many links to reports that need to be printed. The code is fairly simple:
DoCmd.OpenReport "RiskAssess", acViewNormal
printcode
Trouble is I get the "Runtime error 2501 - openform action was canceled" error. Double clicking on the guilty report in the navigation gives the following error
"The expression On Open you entered as the event property setting produced the following error: A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control"
This now occurs for all reports in the database.
Can anyone shed some light as to why our once-working reports now do not work? I've checked the syntaz and apparently the command shouldn't be any different
Thanks
Jim