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 Mike Lewis 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. PSchubert

    Excel - SUMIFS() works with one range, but doesn't with another nearly identical range

    Thanks for your replies, Andrzejek and Combo! Andrzejek's solution worked very well. I couldn't get Combo's to; probably my ineptitude.
  2. PSchubert

    Excel - SUMIFS() works with one range, but doesn't with another nearly identical range

    Hi Techies, I have an Excel spreadsheet that tracks hourly temperature and relative humidity for Level 1 and Level 2. It uses averages, and minimum and maximum values. I've attached it to make it easier to follow my issue. In the range B12:AW12, I've averaged the readings for temperature and...
  3. PSchubert

    Data in db table cell not displayed in asp table cell -- a CSS issue?

    Hi Tech! Thanks in advance for your help. Tek-Tips has always been extremely helpful when I'm expreriencing stumpage. I posted this in the asp forum, where it was suggested that it might be a CSS formatting issue. Is there something with my CSS thaat could be causing the grief? I have an asp...
  4. PSchubert

    Data in DB table cell not displaying in asp page table cell

    Oops! Well spotted, guitarzan. That was just an error from my clumsy copy and pasting. The variable idxItems holds a value from a previously opened recordset that filters the results of the SQL statement. As I didn't paste the code for the entire page (it's too onerous), I just pasted that line...
  5. PSchubert

    Data in DB table cell not displaying in asp page table cell

    Hi Tech! Thanks in advance for your help. Tek-Tips has always been extremely helpful when I'm expreriencing stumpage. I have an asp page that connects to a database. Everything works great except for this one table cell on the page. In the database is a table, tblTravelHistory: (there are...
  6. PSchubert

    Excel - SUM only cells in a columnar range when a corresponding cell in a row is blank

    Thank you, JVF and Skip! All of your solutions work perfectly. I went with SUMPRODUCT, as it works across all Excel versions, including legacy. Your help is awesome! Thanks again.
  7. PSchubert

    Excel - SUM only cells in a columnar range when a corresponding cell in a row is blank

    Hi Tech, I've been pulling my hair out over this one. The range F3:F7 holds numbers. Cell G9 holds the sum of F3:F7. I want G9 to sum only the values in that range where the corresponding cells in columns I, J and K are blank. In other words, if F3=9, and either I3, J3 or K3 are not blank...
  8. PSchubert

    Report repeats Detail section

    As usual, I was making things more difficult than they actually are. The problem was that the main report was bound to a query that returned multiple invoice numbers, so the subreports in the detail section repeated themselves the corresponding number of times. Making the main report unbound...
  9. PSchubert

    Report repeats Detail section

    Hello All, In the attached (Access 2000) database, the report repeats the Detail section once for every invoice from which it draws data. So, what should be a 3-page report on 10 invoices becomes a 30-page report with the same information repeated on pages 4 through 30. A 2-page report on 6...
  10. PSchubert

    How to prevent fixed header from overlapping content when browser resized?

    Hi Chris, Thank you for your reply. When I remove "position: fixed;" from header_container, undesireable effects are produced: the header doubles in height (?!), and the header scrolls up with the rest of the page. What I'm trying for is to only have the header's height expand when the buttons...
  11. PSchubert

    How to prevent fixed header from overlapping content when browser resized?

    Hello Gurus! This page works just like I want, except for one thing: when the browser window is resized so that the header buttons take up two rows, the now height-expanded header encroaches upon the beginning of the content. What I wish would happen is that the entire content block would...
  12. PSchubert

    ASP error on page recoded for w3c compliance

    I've solved it, by: 1. examining the output (page source) of the working version; 2. using that to replace the deprecated html with current html; 3. replacing with the new html and testing variable values one at a time. There were a few mistakes in my previous attempts, including a couple that...
  13. PSchubert

    ASP error on page recoded for w3c compliance

    Correction: the end of the above code block is: rs.Close set rs = Nothing conn.Close set conn = Nothing %> </TABLE> </div> </div> </BODY> </HTML>
  14. PSchubert

    ASP error on page recoded for w3c compliance

    Hi Chris, Thank you for your reply. I've asked myself the same question, and the answer is that if/when browsers stop supporting deprecated html tags, my pages won't work anymore, so I'm trying to be proactive at avoiding that situation. Thanks for the link. I apologise to all for the copious...
  15. PSchubert

    ASP error on page recoded for w3c compliance

    Odd situation here. Hugest thanks if you can help me solve it! I'm betting you can, because on this forum I've found solutions to all but one of my posts! This page displays as intended: <%@ LANGUAGE="VBSCRIPT" %> <% Option Explicit 'Response.Buffer = True 'Check if user is logged in...
  16. PSchubert

    Logging the automatic pinging of a series of IP addresses in a text file produces error

    I found the answer, and of course it's very simple. The line that was giving me trouble: wshShell.run("%comspec% /k ping -a -n 1 " & sText & " >> " & sLog) should be: wshShell.run("%comspec% /c ping -a -n 1 " & sText & " >> " & sLog) As cmd /? says: /C Carries out the command...
  17. PSchubert

    Logging the automatic pinging of a series of IP addresses in a text file produces error

    Hello, I have the following line in a vb script: wshShell.run("%comspec% /k ping -a -n 1 " & sText & " >> " & sLog) where sText is a line in a text file that contains ip addresses, one per line, and sLog is the text file in which to write the results. The code works only for the a single ip...
  18. PSchubert

    How to toggle the achor text along with the div?

    Hey Phil, You rock! You've really helped a guy out, whose name also happens to be Phillip. Thanks for the schooling. Awesome! Phillip
  19. PSchubert

    How to toggle the achor text along with the div?

    Hi all, The following code almost works perfectly, except that the anchor text does not toggle on expand (+) and collapse (-). Any suggestions? (JavaScript) function Toggle(id, link) { var ListItems = document.getElementsByTagName("div"); for(var x=0; x<ListItems.length; x++) {...
  20. PSchubert

    Can I detect what URL the user has entered in the address bar?

    Thanks for responding, guitrzan. Ultimately what I'm trying to do is protect my asp code from being viewed. I'm aware of the old ::$DATA bug, whereby a user could view the code simply by appending "::$DATA" to the URL. While this is now a non-issue, what if in the future a different method is...

Part and Inventory Search

Back
Top