Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JohnCaver

    Pivot Query SQL Server 2005

    Hi, I am recording results of matches between various teams in various tournaments. My columns for the score table are HomeTeam, AwayTeam, Tournament, HomePoints, AwayPoints. e.g. HomeTeam|AwayTeam|Tournament|PointsHome|PointsAway ---------------------------------------------------------- A...
  2. JohnCaver

    Change Line Color Of Graph In Excel Using VBA

    Yes I did, read my 2nd post It will still be interesting to see if this is an issue with Excel 2007.
  3. JohnCaver

    Change Line Color Of Graph In Excel Using VBA

    It just records the selecting: ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.SeriesCollection(2).Select
  4. JohnCaver

    Change Line Color Of Graph In Excel Using VBA

    I guess you are not using Excel 2007?
  5. JohnCaver

    Change Line Color Of Graph In Excel Using VBA

    Yes I tried that - unfortuantely, for reasons best known to Microsoft, the color change does not get recorded. I have since discovered you can do it by setting the ColorIndex property of the associated Border object.
  6. JohnCaver

    Change Line Color Of Graph In Excel Using VBA

    Hi, I'm trying to programatically change the color of lines in a line graph using a VBA macro in Excel. Is this actually possible?
  7. JohnCaver

    Outer join problem - hardest query ever?

    Sorry - obviously it doesn't - I just listed it twice by mistake.
  8. JohnCaver

    Outer join problem - hardest query ever?

    Thanks, but gives the error message: The column 'TrialId' was specified multiple times for 'Test'.
  9. JohnCaver

    Outer join problem - hardest query ever?

    Hi - I'm struggling with a query, which is as follows. (I have changed the context slightly for simplicity) I have 4 tables: users, scores, trials, tests Each pair of users takes a series of upto 4 tests in 1 trial, getting a score for each test. There are a different numbers of trials for each...

Part and Inventory Search

Back
Top