Results 1 to 4 of 4

Thread: access charts

  1. #1
    Join Date
    May 2003
    Location
    sidcup kent
    Posts
    7

    Smile Unanswered: access charts

    does anyone know how to change the chart rowsource using vba withan unbound chart in a report.

    I want a chart to work with multiple record sources in a multiuser environment. Had intended to build a query def for individual users with their name attached to run a passthrough into oracle. but i need to change the chart rowsource for each user.

  2. #2
    Join Date
    May 2003
    Location
    New York, NY
    Posts
    225

    Try This

    [ChartName].RowSource = "Your SQL"

  3. #3
    Join Date
    May 2003
    Location
    sidcup kent
    Posts
    7

    Re: Try This

    Originally posted by Mark Gambo
    [ChartName].RowSource = "Your SQL"


    thanks mark

  4. #4
    Join Date
    Jun 2006
    Location
    Perth, Western Australia
    Posts
    4
    And did the suggested approach work?
    Because it gave me an error and I managed to find a post where it said that if you wanted to change the sql of a chart in a report you'd have to change the querydef instead!

Posting Permissions

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