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!

Register Log in
  • Congratulations TouchToneTommy 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: *

  • Users: pyth0n
  • Content: Threads
  • Order by date
  1. pyth0n

    Updating Excel charts using VBA

    Hi All What's the best way to update an Excel Chart using VBA? At the moment, my script does some work to find the cell where the data is, then edits the Formula for the chart, but after a certain number of iterations this gives me a problem. Like this: For i = 1 To chart_count + 1 Set...
  2. pyth0n

    Updating Excel Charts using VBA

    Hi All What's the best way to update an Excel Chart using VBA? At the moment, my script does some work to find the cell where the data is, then edits the Formula for the chart, but after a certain number of iterations this gives me a problem. Any clues would be greatly received.
  3. pyth0n

    PHP and COM question

    This is a bit of a newbie question really. I am trying to use COM to write an Excel spreadsheet from an MSSQL database - limited here by my employers choice of technology. What I want to do is set up a web script that will gather data from the user: dates, preferences etc, then query the...
    • pyth0n
    • Thread
    • Replies: 3
    • Forum: PHP
  4. pyth0n

    Long VBA generated queries

    Hi I have a section of VBA code that generates my SQL query, but when I try to use the query it errors. I have seen found that the query is being split into 1024 character blocks by Access and therefore not providing correct syntax for the query to work. Is there anything that I can do to...
  5. pyth0n

    Transfering from Access to MS SQL 2000

    We are moving from MS Access to MS SQL Server 2000. Some of our Access applications use crosstab queries with the following SQL: TRANSFORM Count([CHTest3].FacingsX) AS CountOfFacingsX SELECT [CHTest3].[LM ID Number] FROM [CHTest3] GROUP BY [CHTest3].[LM ID Number] PIVOT [CHTest3].Product; What...
  6. pyth0n

    Scroller not visible in FF or NN, but works in IE?

    I am working on a site where I am using a javascript text scroller that I have borrowed for news items. The site is being written in ASP.NET, linking various user controls to build the page. Testing the site locally, I find that the page displays correctly in IE6, but when tested in NN7.1 or...
  7. pyth0n

    JavaScript issue with ASP.NET and FF and NN

    I am working on a site where I am using a javascript text scroller that I have borrowed for news items. The site is being written in ASP.NET, linking various user controls to build the page. Testing the site locally, I find that the page displays correctly in IE6, but when tested in NN7.1 or...

Part and Inventory Search

Back
Top