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

    SQL Between statement

    Hi all. I found a problem with my code and realised that the SQL statement... rs.Open "SELECT Name, S, Time, Tid FROM TstArchive WHERE [Time] BETWEEN '" & passDateToQueryField.Text & "%' AND '" & passDateToQueryField2.Text & "%' ORDER BY Name ASC", db, adLockOptimistic ...does not...
  2. Polariz666

    Quick SQL Syntax Problem

    Hey guys, I'm having a small bit of trouble with an SQL statement in VB6 and was wondering if any of you could help me. The statement is as such: rs.Open "SELECT Name, S, Time, Tid FROM TstArchive WHERE Time >= LIKE '" & passDateToQueryField.Text & "%' AND <= LIKE '" &...
  3. Polariz666

    The best way to show program status?

    Hi guys. I have a program that does alot of SQL cycles and can take as long as 40 seconds to load in all the relevant data. At the moment, a form appears to show that the program is working (And taking up all of the CPU power), and disappears when the cycles have finished. However the forms are...
  4. Polariz666

    Complex algorithm - Misreading db?

    Hi all. ========= Intro ========= I'm having alot of trouble with an algorithm i've written, as it's producing odd results. The program i'm writing sifts through a load of data about the testing of Boards. A Previous algorithm searches through a different set of records, tallying up which...
  5. Polariz666

    Help! SQL syntax problem

    Hey guys, I'm currently writing a program that pulls data out of a database for statistical purposes. The following SQL command is wrong somehow and I can't figure out why. rs.Open "SELECT Name, S, Time, Tid FROM TstArchive WHERE Time LIKE '" & passDateToQueryField.Text & "*' ", db...

Part and Inventory Search

Back
Top