Search results for query: *

Excellent mate worked a treat, thanks alot. I hear you about inheriting other people's code; I wanted a quick fix to the few problems this program had and it's made more difficult by not knowing the code at all when it's not your own. The database itself is actually generated and updated by yet...

Right i've discovered a problem hehe. This isn't my code so after further investigation the variable that passDateToQueryField.Text is attached to is actually not a date - it's a String. The reason for this is the database has dates stored in the format 20041201170123. This means that it's 1st...

Sorry about that, I am using VB6 with an access database. I'll give that a try cheers.

For reference, here is where I found the previous problem out: http://www.w3schools.com/sql/sql_between.asp Cheers guys, M.

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

Yeah ive had this problem loads, but I didnt create the database you see. It's a database that's populated by some other software and i'm simply writing a program that creates statistics from it. Cheers for the help. M.

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 '" &...

I'd like to hijack this thread slightly because i'm looking for something similar. I have two calendars, which I want to pass the dates into an SQL query. I want to do this in a loop, from the first date selected, for every day till the date selected in calendar 2. I'm pretty sure I need to use...

Could it be that the error in your original code is due to no records being found? If this is the case, the code will skip the While statement because rs.EOF is true (Skipping the Msgbox), then it will consequently crash on the rs.MoveLast statement because it's not included in any sort of...

Nice one guys, thanks alot.

Bloomin marvelous, doEvents works a treat. Thanks chap. Mike.

Because the current code is like so: ----------------- Private Sub Button_CLick form.show / label.Caption = "Working" (Ive tried both) Do the code form.Hide / label.CAption = "Done." End Sub ----------------- In both cases, the form is either not drawn properly (IE it has labels...

---------------------------- Quote from dwlerwill: EG. Private Sub Command1_Click() Do Until ProgressBar1.Value = 100 'whatever codehere ProgressBar1.Value = ProgressBar1 + 1 'depending how many loops change increment DoEvents Loop End Sub...

No the queries are only found when either the user clicks a button or drops down a combo box and makes a selection. The user may not always wish to run the same query so putting it in form load would waste alot of the user's time - especially considering there's around 1.2 million records...

Yeah I had considered it but haven't a clue how to implement it. I'll take a look through the help file, cheers.

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

*Bump* Rather desperate here :¬/ , any help at all welcomed. Mike.

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

Ah nice, thanks for that John.

That's brilliant mate thankyou. I would try to stay away fro mreserved names but unfortunately another piece of software not written by me makes the database and populates it with data. Also you may have noticed that the time data is backwards too hehe, the date that is 23/06/2000 gets stored...