Re: [MS_AccessPros] open/activate MS Graph datasheet

 

found it :)

 Dim ctl As Control

   Set ctl = Me.Graph5

  ' Set ctl = Me!OLEUnbound0

   With ctl

      ' Enable control.

      .Enabled = True

      ' Set Locked property to False.

      .Locked = False

      ' Set Verb property to activate for editing.

      .Verb = acOLEVerbShow

      ' Activate object.

      .Action = acOLEActivate

   End With

Terence

On Thursday, March 27, 2014 7:04 PM, "buffalome000@yahoo.com" <buffalome000@yahoo.com> wrote:

 

I am attempting open a Ms Graph's datasheet via VBA code. The Graph is on a form..

below is what I thougth would work, but when I exceute the code "nothing" occurs, any suggestions ?

Me.Graph5.Object.Application.chart.Application.datasheet.Activate

Me.Graph5.Object.Application.chart.Application.Update

I am using MSGraph.Chart.8

with MS access 2007

Terence

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___