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

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.dougwise.org!nntpfeed.proxad.net!proxad.net!feeder1-2.proxad.net!feeder.erje.net!newsfeed.kamp.net!newsfeed.kamp.net!nx02.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!spln!extra.newsguy.com!newsp.newsguy.com!news4
From	"David-W-Fenton" <NoEmail@SeeSignature.invalid>
Newsgroups	comp.databases.ms-access
Subject	Re: Getting To A "Chart" Object From VBA?
Date	1 Apr 2011 19:58:26 GMT
Organization	David Fenton Associates
Lines	31
Message-ID	<Xns9EBAA27ECB72Df99a49ed1d0c49c5bbb2@74.209.136.89> (permalink)
References	<5439p61tasq2ru97iegpsi6gfhlhj56dgt@4ax.com>
NNTP-Posting-Host	p7c64294703b52139682d31814a67b3560a9c0bb26d70a901.newsdawg.com
Content-Type	text/plain; charset=iso-8859-1
Content-Transfer-Encoding	8bit
User-Agent	Xnews/5.04.25
X-Face	@m-[g?H9x*`!7Ya\|pBsd\euE'N>C~30z2k3vbx%9s#^?z^/CE@wz<?uZv6O1:e^w\|{$Vyy P5v^qUR8?lyJ=\!,H4opW-{je~6"=Oa&x5ts-^>bSU6JEc,Mnx[{4p;}`WH7Pb1C`\|z/"#i+6kL2CiI@viQon3u;xgQ
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-access:758

Show key headers only | 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