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 bkrike 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
  • Content: Threads
  • 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

    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?
  5. 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?
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. mbutler55

    objRS.RecordCount

    If I have Set objRS = Server.CreateObject (&quot;ADODB.Recordset&quot;) sql=&quot;SELECT PTAGE FROM Median&quot; objRS.Open sql, objConn iNumRec = objRS.RecordCount Why is iNumRec coming out -1?
  11. mbutler55

    Getting A value out of a db

    This has to be THE dumbest question ever asked, but I feel like I have tried everything and nothing seems to work! I have a list of numbers, sorted in ascending order in a table called Median - (yes I am trying to find the median value) My code to peruse the list of numbers until finding the...
  12. mbutler55

    Performing a query and viewing information

    I have set up the database to make the connection, now I am trying to get information out of the db. The user will type in a username and password and I need to check to see if the person matches someone in the db. Pretty elementary I am sure, but I am doing something wrong. <% Dim objRS...
  13. mbutler55

    Opening the Connection in a DSN-less Connection

    I am creating my first asp web integrated page. I obviously don't know what I am doing. Although I used to consider myself a fairly knowledgeable programmer. I am using FrontPage 2002 and Access 2000. I am on a Windows XP Professional machine with IIS installed. I created my Form in FP and then...

Part and Inventory Search

Back
Top