graph.chart does not work
Quote:
>>> The reference to msgraph is set,
Is msgraph in the same location on both machines? Unlike
dao/vba msgraph does not automaticly go to "microsoft shared'
-- it goes to the Office root directory, which may be anywhere.
Quote:
>>http://support.microsoft.com/support/kb/articles/Q190/7/35.ASP for more
This is certainly a very strange article - the review date is november
10, 1999, which implies that it is still current.
Quote:
>Simon,
>the code works fine on one machine and not on the other. It's both NT4 and
>both Access97. It must be some setting outside Access, but which one?
>Frank
>Simon Lewis heeft geschreven in bericht ...
>>Frank,
>>You can't use early binding with Graph. Use late binding instead, e.g.:
>> Dim chrt As Object
>> Set chrt = Me.Graph0.Object
>>See KB article
>>http://support.microsoft.com/support/kb/articles/Q190/7/35.ASP for more
>>details.
>>Simon Lewis
>>> Hello all,
>>> the code below gives error 'type mismatch'. The reference to msgraph is
>>set,
>>> so that's not the problem. MSAccess 97.
>>> Dim chrt As Graph.Chart
>>> Dim Xas As Graph.Axis
>>> Set chrt = Me.Graph0.Object <---there!!
>>> Set Xas = chrt.Axes(xlValue, 1)
>>> Thanx
>>> Frank
