Recent content by TBreak

Thanks Andrew, I tested that and it was certainly a major part of the problem. The other being the fact that the DB I am accessing has SPACES in the field names and SQL doesn't seem to like that, even if it is in "" Wierd, but true. So I am now off to get a few drinks and forget...

Yup, I have tried all formats, yyyy/mm/dd, dd/mm/yyyy etc... and used dash seperators as well as slashes. The fields are declared as Dates (D), NOT DateTime (@). Anyone else any ideas why such a simple query won't work?

Thx lou, As I mentioned I have tried US and other formats with the same query and no luck. I have also tried using # around the date but that resulted in an exception of invalid use of token Anyone else any ideas? TIA

Can anyone explain why the following query returns an empty dataset, even though there are definitely records which match... SELECT * FROM TRANSACTIONS.DB WHERE "Submit Date" BETWEEN "01/01/2003" AND "31/12/2003" and: SELECT * FROM TRANSACTIONS.DB WHERE...

Leslie> When I do that I get the error: "Data type mismatch in criteria expression" I will try a normal Access 2000 database tonight with a date field and see what difference that makes and give you an update tomorrow. I feel like my brain is slowly melting outta my ears, nose...

There could be an issue with the Access version. When I use my Access 2000 to open the table there is a prob with the date field when I try to set the default value, saying a function has not been installed CDate() (whatever that is). So I will try to update to Access 2002 tomorrow and see if...

LESLIE> It does not work. Using the query above provides an error: "Invalid use of '.', '!', or '()' in query expression 'DISBURSEMENTS."DATE CREATED" = '#03/07/21#'" The reason I modified the above code was I figured you had typoed. ALSO, the use of '' around the date...

Ok, tried that too. No good. I get no errors, but no results. I tried: SELECT * FROM DISBURSEMENTS WHERE "DISBURSEMENTS.DATE CREATED" = "#03/07/21#" SELECT * FROM DISBURSEMENTS WHERE "DISBURSEMENTS.DATE CREATED" = "#21/07/03#" SELECT * FROM...

Thx again, guys. Eric> I did that as the 1st line of attack (see above). DoorV> I am using a straight TEdit to enter a qeury string directly in as I am just testing b4 I integrate the functionality fully into the app. Just to recap: I have tried all the formats I am aware of, including...

Thx, Just tried that, but it appears not to work with Access. I am getting a "Data type mismatch in criteria expression" error. This is wierd. I do: SELECT * FROM DISBURSEMENTS WHERE "[DATE CREATED] = 07-21- 03" and get all the records in the dataset. If I do...

Thx guys, but I have tried all those combos. Yes the name has a space in it, and I tried the square brackets and in quotes. The SQL command is not rejected when executed, which it was when the name was incorrectly spelt. I am really at a loss. There is data in the table that matches the...

I am trying to select portion of a dataset using a TADOQuery with a date filter, but no matter what format I use it seems to make no difference. eg. SELECT * FROM DISBURSEMENTS WHERE "DATE CREATED = #21/07/03#" I have tried it with all the date formats possible (dd-mm-yy, yy-mm-dd...

SOLVED IT! :) Stupidly simple as it happens. All I needed to do was typecast the document property of the TWebBrowser with OLEVariant and hey-presto! OLEVariant(WebBrowser1.Document).doSubmitForm() accesses the pages java routine. Sweet. Hope this helps some1 else in future. It was a pain...

Right, I tried that and it did work for the print! But as per usual it won't cure what ails me because: I need to access java script procedures within the pages I am accessing. I can do this via the OLEVariant but (dunno why) not throught the IDispatch of the TWebBrowser component. eg. In...

If any one out there has managed to stop the print & save dialogue boxes from being displayed could they PLEASE contact me. I am writing an automation process using IE6. I am using an OLEVariant and all other features of the app are perfect, except the print & save functions, which require...