It has been a while for this forum and for MSAccess but I'm back at it updating from Win7 Office 2007 to Win10 Office 2010.
I have a few Microsoft Graph Chart object in a form and I am using the onUpdated event of the chart object. That code looks like this;
I am however getting an automation error
In my research today I found this thread which is unresolved
https://access-programmers.co.uk/forums/showthread.php?t=247776
and then this thread https://access-programmers.co.uk/forums/showthread.php?t=246755 which suggests using the timer. I assume using the time "brings the call back on the right dispatcher" (never thought I would be talking about such things in VBA).
I would prefer not to have to use the Timer as I have more than one graph and thus multiple updates happening.
Could anyone suggest another way?
I have a few Microsoft Graph Chart object in a form and I am using the onUpdated event of the chart object. That code looks like this;
Code:
With Me.chart_status.Axes(2)
.MinimumScaleIsAuto = True
.MaximumScaleIsAuto = True
Select Case .MaximumScale
Case Is < 10
.MajorUnit = 1
Case Is > 100
.MajorUnit = 10
Case Is > 10
.MajorUnit = 5
End Select
.MinorUnitIsAuto = True
.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With
Such an error seems impossible for VBA.Automation Error
The caller is dispatching an asynchronous call and cannot make an outgoing call on behalf of this call
In my research today I found this thread which is unresolved
https://access-programmers.co.uk/forums/showthread.php?t=247776
and then this thread https://access-programmers.co.uk/forums/showthread.php?t=246755 which suggests using the timer. I assume using the time "brings the call back on the right dispatcher" (never thought I would be talking about such things in VBA).
I would prefer not to have to use the Timer as I have more than one graph and thus multiple updates happening.
Could anyone suggest another way?