Groups | Search | Server Info | Login | Register

Groups > comp.databases.ms-access > #719

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

Show all headers | View raw

(PeteCresswell) wrote:
> 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".
>
>
>
> OK, maybe we need the object within....
>
> ------------------------------------------------
> 1002 Dim myChart  As Object
>
> 1010 Set myChart = Me.chtWACQ
>
> 1020 With myChart
> 1021    .Activate
> 1022    .HasLegend = True
> 1999 End With
> ------------------------------------------------
>
I'm missing something. What, besides the line numbers, is the difference
between these two code snippets?


> But now line 1010 throws "Error#  2771: The bound or unbound
> object frame you tried to edit doesn't contain an OLE object.
>
>
> I've been here before, decided it was hopeless, and reverted to
> creating my charts on Excel spreadsheets.
>
> But now it's crunch time: this thing just *has* tb on an MS
> Access report.   The .Activate and .HasLegend are just
> placeholders to see if I've got the refs right.   Once I can get
> to the chart object, I will do a lot more.
>
> Seems like I'm doing something dumb, but what?

Failing to be explicit.
chtWACQ is an ObjectFrame object that has a property called Object that
contains a reference to the contained object. Try:

dim myChart as Chart
set myChart = me!chtWACQ.Object
etc.

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