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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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++) {...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.