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 derfloh 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: PSchubert
  • Content: Threads
  • Order by date
  1. PSchubert

    Excel: Formula only works with certain numerical values

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

    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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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++) {...
  11. PSchubert

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

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

    Nested functions Replace, Mid, InStr

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

    How to hide HTML output when recordset field value is null?

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

    Why are Cstr and Replace not working in this code?

    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 =...
  15. PSchubert

    Open form in .exe using button in .ocx

    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)...
  16. PSchubert

    Runtime Error '3020': Update or CancelUpdate without AddNew or Edit

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

    Limit records returned by a Totals query according to Max field

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

    Report has redundant pages

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

    Access query to retrieve a field from an earlier record?

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

    Run procedure as argument?

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

Part and Inventory Search

Back
Top