Re: Getting To A "Chart" Object From VBA?

From	"David-W-Fenton" <NoEmail@SeeSignature.invalid>
Newsgroups	comp.databases.ms-access
Subject	Re: Getting To A "Chart" Object From VBA?
Date	2011-04-01 19:58 +0000
Organization	David Fenton Associates
Message-ID	<Xns9EBAA27ECB72Df99a49ed1d0c49c5bbb2@74.209.136.89> (permalink)
References	<5439p61tasq2ru97iegpsi6gfhlhj56dgt@4ax.com>

Show all headers | View raw

"(PeteCresswell)" <x@y.Invalid> wrote in
news:5439p61tasq2ru97iegpsi6gfhlhj56dgt@4ax.com: 

> Using Insert | Chart, I added a chart object to my report.
> 
> Ole Class = Microsoft Graph Chart
> Class     = MSGraph.Chart.8
> 
> But when I try to instantiate it in VBA, something is wrong:
> 
> ------------------------------------------------
> 1002 Dim myChart  As Object
> 
> 1010 Set myChart = Me.chtWACQ
> 
> 1020 With myChart
> 1021    .Activate
> 1022    .HasLegend = True
> 1999 End With
> ------------------------------------------------
> 
> Starting with line 1021, I get "Error#  438: Object doesn't
> support this property or method".

Where are you putting the code? Certain objects do not exist for
certain events. In general, I wouldn't expect this kind of thing to
work, since you can't do anything like this with subreports. 

-- 
David W. Fenton                  http://www.dfenton.com/ 
contact via website only     http://www.dfenton.com/DFA/

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Getting To A "Chart" Object From VBA? "(PeteCresswell)" <x@y.Invalid> - 2011-03-31 10:25 -0400
  Re: Getting To A "Chart" Object From VBA? "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-03-31 11:00 -0500
    Re: Getting To A "Chart" Object From VBA? "(PeteCresswell)" <x@y.Invalid> - 2011-03-31 13:01 -0400
      Re: Getting To A "Chart" Object From VBA? "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-03-31 12:14 -0500
        Re: Getting To A "Chart" Object From VBA? "(PeteCresswell)" <x@y.Invalid> - 2011-03-31 13:27 -0400
  Re: Getting To A "Chart" Object From VBA? "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-01 19:58 +0000
    Re: Getting To A "Chart" Object From VBA? "(PeteCresswell)" <x@y.Invalid> - 2011-04-02 18:50 -0400
      Re: Getting To A "Chart" Object From VBA? "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-03 15:35 +0000

csiph-web