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

From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-access
Subject	Re: Getting To A "Chart" Object From VBA?
Date	2011-03-31 12:14 -0500
Organization	A noiseless patient Spider
Message-ID	<in2coq$naj$1@dont-email.me> (permalink)
References	<5439p61tasq2ru97iegpsi6gfhlhj56dgt@4ax.com> <in28ei$2n1$1@dont-email.me> <2mc9p6tccvddl6c6586ljeink9crhsp4cs@4ax.com>

Show all headers | View raw

(PeteCresswell) wrote:
> Per Bob Barrows:
>> I'm missing something. What, besides the line numbers, is the
>> difference between these two code snippets?
>>
> None.  RCI on my part.
>
> The second one shb, per your suggestion, "Set myChart -
> me!chtWACQ.Object.
>
>> 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.
>
> Intuitively, I get the "ObjectFrame" distinction, but the error
> that Access throws when I do chtWACQ.Object suggests to me that
> it does not contain an object.
>
> i.e. "Error#  2771: The bound or unbound
> object frame you tried to edit doesn't contain an OLE object."

My attempts to reproduce your error have failed. All I can say is "It works
for me". Sorry

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