Hi~
I have a report that displays productivity figures for individual reps along with a chart. The page breaks whenever there is a new rep. At one point the department manager would have a chart that did not match the data assigned to the individual rep but would be someone elses data. When I pulled the reports on my PC all my reports would come up with no problem. To fix this I added a code on the OnPrint event of the report
On Error Resume Next
Dim objChart As Object
Set objChart = Me!Chart80
objChart.Refresh
DoEvents
Set objChart = Nothing
End Sub
Now the new problem is that another individual who has XP as her OS is receiving the following error message:
"This action can't be carried out while processing a form or report event.
A macro specified as the OnOpen, OnClose... property setting contains an invalid action for the property."
Myself and the department head do not receive this error message and our OS is Windows 98 (if that has anything to do with it).
A little info about myself I'm a VB beginner - so bare with me. Thanks for your interest. Cherly
I have a report that displays productivity figures for individual reps along with a chart. The page breaks whenever there is a new rep. At one point the department manager would have a chart that did not match the data assigned to the individual rep but would be someone elses data. When I pulled the reports on my PC all my reports would come up with no problem. To fix this I added a code on the OnPrint event of the report
On Error Resume Next
Dim objChart As Object
Set objChart = Me!Chart80
objChart.Refresh
DoEvents
Set objChart = Nothing
End Sub
Now the new problem is that another individual who has XP as her OS is receiving the following error message:
"This action can't be carried out while processing a form or report event.
A macro specified as the OnOpen, OnClose... property setting contains an invalid action for the property."
Myself and the department head do not receive this error message and our OS is Windows 98 (if that has anything to do with it).
A little info about myself I'm a VB beginner - so bare with me. Thanks for your interest. Cherly