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 Mike Lewis 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: *

  1. Scarecrow

    Filtering a database query using a drop down list

    Yes. For example, in the 'Position' field name of my 'Item' database table there will be SP, MR, CL, C, 1B, 2B... . I want it so that there is a drop down box in the top row (currently a header row that says 'Position') so that if I want to see just the Catchers, I can select 'C' from the drop...
  2. Scarecrow

    Filtering a database query using a drop down list

    I have been told what I am wanting is easy to do, but I just can't figure it out. What I'd like to do is change my current database listing so that the heading column is a drop down filter, like the excel autofilter function. Below is my current coding. I would like to replace the headings...
  3. Scarecrow

    Timer Using DateDiff

    Thanks for the help. I had to make a couple of corrections, though. Here is the corrected script in case anyone else needs it: Dim DiffHrs, DiffMin, DiffSec DiffSec = DateDiff("s",Now, rsBid("LastBidTime")) DiffHrs = Fix(DiffSec/3600) DiffSec = DiffSec - DiffHrs * 3600...
  4. Scarecrow

    Timer Using DateDiff

    I am in the process of putting a countdown timer in my online auction. Right now, I'm using the DateDiff function to figure the Hours, Minutes, and Seconds remaining in the auction. The 2 problems I'm facing are: (1)How do I format the minues and seconds to represent 'real' minutes and...
  5. Scarecrow

    Changing data between tables

    It worked!!!! [bows down]Thank you.[/Bows]
  6. Scarecrow

    Changing data between tables

    That's what I'm looking for (I think). Two questions, though: 1. It is and MS Access dBase. Which ' should be changed to #? 2. Exactly where in the script do I add that line? I apologize for being so stupid; this was done by someone else prior and, in addition to me never using asp...
  7. Scarecrow

    Changing data between tables

    I am in the process of creating an online 'auction'. I have two tables in my access dbase labled 'Item' and 'Bid'. Within the 'Item' table are field names ItemID, ItemName, ExpirationDate, and ItemStatus. Within the 'Bid' table are field names ItemID, and BidClose. My script in addbid.asp...
  8. Scarecrow

    Comparing form results

    Got it to work. Thanks again
  9. Scarecrow

    Comparing form results

    Just so I make sure I understand what you've said, my script should now look like this?: <SCRIPT language=&quot;JavaScript&quot;> <!-- var curBid = &quot;<%= varHighBid %>&quot; function VerifyData() { if...
  10. Scarecrow

    Comparing form results

    the original formula used is: Bid*(3-ABS(3-Length))+5.47, where length is the length of the contract, and bid is the amount of the contract. varHighBid is the highest bid amount (using the same formula) in the database.
  11. Scarecrow

    Comparing form results

    I am in the process of creating a fantasy baseball auction page where you bid on the players by offering them contracts of varoius lengths and amounts. The problem I am having is that it doesn't check to see if a persons offer is the best offer. Below is the script I am using: <FORM...
  12. Scarecrow

    hyperlink question

    I am also having similar problems. In my Access Database there is a table (items) with a column(description). Each items' description inludes a separate hyperlink (Item 1's description is www.dontclick.com/1.htm, item 2 is www.dontclick.com/2.htm...) My .asp code is: <% Dim rsItem...

Part and Inventory Search

Back
Top