Results 1 to 3 of 3

Thread: Report Diagram

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Report Diagram

    Does anyone know how to change programatically (via vba) the row source of the OLE that shows the Diagram [i.e a pie or column diagram]?

    I tried Me.OLE1.Report.RowSource but was not right....
    whee OLE1 is the name of the unbounded chart..
    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Should you not be trying to change the actual row source itself. I take it that the row source is either a query or SQL? If I am talking gibberish, just ignore me.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Yes, I'd like to change it but through VBA so that I am not getting the same chart.
    Thanks for your answer....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •