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 strongm 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: mbutler55
  • Order by date
  1. mbutler55

    Status Bar showing progress

    I have a script that is "backing up" and "restoring" files. Because there are MANY files, many of which have thousands of records, the script takes a LONG time. I really have 2 questions: 1 - I have frozen the screen, but the delete records, import records, and export records status boxes are...
  2. mbutler55

    Remembering the usersname

    I can get a user's name from a log in page no problem. I have strName = Session ("Username") I then have if the user name is "guest" (strName="guest") then go to a different server which is my guestbook to log personal information. Here is the problem, after...
  3. mbutler55

    Adding a cc in a Submit button

    Is it possible to include a cc in a Submit button in Adobe? I know that I can <A HREF=&quot;mailto:who@wherever.com?cc=yohoo@somewhere.com&quot;> but I can't get that to work in the URL of a Submit button.
  4. mbutler55

    Information is in a FORM not a Query or Table

    When I say it exists in a &quot;FORM&quot;, I mean an Access FORM. Are you also using the word FORM in the same way?
  5. mbutler55

    Information is in a FORM not a Query or Table

    I have data in a field that exists in a Form. How do I get that information into a Table or Query so that I can use it in a web page via ASP?
  6. mbutler55

    Need to get data in a Form to a Table or Query

    I have data in a field that exists in a Form. How do I get that information into a Table or Query so that I can use it in a web page via ASP?
  7. mbutler55

    creating a calculation - should be easy

    I am NOT an expert in Access and don't even pretend to be, so don't hesitate to &quot;dumb-down&quot; your answers. You will not insult me! Here goes: In a table I have 2 fields both of which are numbers - YEAR and MONTH Now I want to calculate the duration using the formula YEAR + MONTH / 12...
  8. mbutler55

    Getting a date out of Access

    Thanks Brian that was what I was looking for!
  9. mbutler55

    Getting a date out of Access

    Pardon me - here is the complete code: Dim objConn Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot;) objConn.ConnectionString = &quot;DRIVER={Microsoft Access Driver (*.mdb)};&quot; & &quot;DBQ=&quot; & Server.MapPath (&quot;fpdb/CryoCathIPR.mdb&quot;) & &quot;;&quot...
  10. mbutler55

    Getting a date out of Access

    I don't understand what you are saying since both of those lines are included in my page.
  11. mbutler55

    Getting a date out of Access

    I have a table called CurrentDateAndTime. It consists of 1 field and 1 record. The field is called CurDateTime. It has an automatically filled in value from the function Now(). My db will be static not dynamic and this field will store when the db was last updated. In my web page I have: set...
  12. mbutler55

    Yes/No Data Type

    Ok gurus - In a field that is defined as &quot;Yes/No&quot; in Access, how do I make a comparison in ASP? Example: sql = &quot;SELECT INVEST, REF1CODE, NEWAC1 From AblProc WHERE REF1CODE='2AC20' AND NEWAC1='Yes';&quot; Having NEWAC1='Yes' gives &quot;Data type mismatch in criteria...
  13. mbutler55

    x = x + 1 gives illegal character

    I'm sure Option Explicit is a preference. I personally like it as it keeps me from accidentally typing an incorrect variable name. I did in fact get the necessary code in question working. Still don't know what the cause of the error is/was. I was actually working on getting a Median function...
  14. mbutler55

    Getting A value out of a db

    Okay guys (& gals) I have no clue what happened, but I went back and added 1 line at a time and it know works. Here is the final code for any of you who care. This computes the median of a list of numbers. <%@ Language=VBScript %> <% Option Explicit %> <!--#include...
  15. mbutler55

    x = x + 1 gives illegal character

    I have had some WONDERFUL help on some previous questions this morning from jlsmithprism BDC2 FesterSXS just to name a few helping me with several issues. I am now down to this one BIG BUG!!!! I have taken out ALL of my code except for the following: <%@ Language=VBScript %> <% Option...
  16. mbutler55

    Getting A value out of a db

    Now it is even spookier - all I have is <%@ Language=VBScript %> <% Option Explicit Dim iNumRec iNumRec = 0    iNumRec = iNumRec + 1 response.write (iNumRec) %> and I still get that there is an illegal character. I am going to repost just this in another thread in hopes to open it up...
  17. mbutler55

    Getting A value out of a db

    I'm so sorry - I did try that and no it did not work. Please don't stop on me now.
  18. mbutler55

    Getting A value out of a db

    OKay - I took out EVERYTHING except what pertains to this code and the page works fine. I then copied this to another page. Just plain and dirty - nothing perty. Here it is: <%@ Language=VBScript %> <% Option Explicit Dim objConn Set objConn =...
  19. mbutler55

    Getting A value out of a db

    I'm not sure about when the End If got seperated, but it is fixed now. So here is what I have: Dim tempAge, iNumRec, Median, intMedian, iCounter Set objRS = Server.CreateObject (&quot;ADODB.Recordset&quot;) sql=&quot;SELECT PTAGE FROM Median&quot; objRS.Open sql, objConn, 3...
  20. mbutler55

    Getting A value out of a db

    Nope still doesn't like x = x + 1

Part and Inventory Search

Back
Top