Search results for query: *

Hello Mighty Excelers! I'm stumped. I have formulae that extract numbers from imperial linear measurements which are formatted in specific ways, for example: 12' 11-13/16" or 11-13/16" (when there are no feet) or 11" (when there are no feet and no fraction) or 13/16" (when there are no feet and...

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...

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...

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...

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...

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...

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...

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++) {...

Hi all, I'm using classic asp, and I want to screen against url manipulation. I'd like to capture what the user has entered in the address/location bar before it is executed on the server, and if it doesn't match a whitelist, redirect. If there's a way to do it, I know I'll find out here...

Hi all, What I want: to force a line break after the first space after the 30th character. What I have that doesn't work: Dim strCondNotes strCondNotes = rs("mfldConditionNotes") Replace(strCondNotes,(Mid(strCondNotes,(InStr(30,strCondNotes," ")),1))," " & "<br>") This is as close as...

Hi all, I know from prior posts that you people know just what to say to help a brother out, so here goes: What I want to do is just what the subject says, and here's what I've got that doesn't work: <% '...all this code in green works great blah blah blah blah...

Hi all, This is where I go when I can't figure it out, 'cuz you people rock! Here's my code, seemingly simple enough: <%@ LANGUAGE="VBSCRIPT" %> <% Option Explicit Dim conn Dim rs Dim strSQL Dim strConnection Dim AcctNum Dim ItemNum Dim i Set conn =...

Hi there, I've made a custom .ocx control consisting of a command button and three text boxes: [btnGo] [txtAccountNum] [txtName] [txtContact] In my .exe, I have created a data repeater, using the .ocx. It looks something like this: [btnGo] [txtAccountNum] [txtName] [txtContact] (record 1)...

I am trying to convert an mdb to VB6. I want to create a new record, assign a value to a field that is one greater than the highest existing value for that field, and open a form to the new record. Using the following code, I get the above error, and I don't know why! Private Sub...

Hello, and thanks in advance... I need to include only the payment amount that corresponds to the max of the payment date field. Here's what I have so far that's relevant: <b><u>tblInvoices</u></b> nfldidxClients dfldPymtDate cfldPymtAmount <b><u>qryLatestAcctPayments</u></b> <i>(A Totals...

Hello all, and thanks in advance... I have an Access 2000 report that runs 12 pages with only 1 page's worth of information. Page 1 displays as intended. Pages 2-12 display the contents of the Detail section again, once per page. The report is based on a query, which returns only the desired...

Greetings All, I am writing a billing and invoice program. I want to create a query that retrieves the previous month's balance for a given client so that I can include it on the current month's invoice. Here's my setup so far, which works just fine for the current invoice total: tblInvoice...

Hello All, Is there a way to run a procedure as an argument of another procedure? For example: Private Sub ProcedureA(ByVal X As String, ByVal Y As String, _ Z As ???) As Boolean ...code here... End Sub '_________________________________________________________________ Private Sub...