Search results for query: *

I'd like to add my 2 pence here having gone through similar-ish situation a few years ago. It seems that situations like this are occurring more and more frequently and not necessarily just to women. There is a certain amount of media attention, particularly in London, to people getting paid...

Great news this Saturday afternoon! I think I have fixed this bizarre error... I found that in 1 of my modules I'd left some unused code at the bottom which would not compile as it was partially commented out. I commented out the remaining Public Declare Function statements and hey presto the...

Have you tried using the Oracle Hierarchical Query syntax? It gave me quite a few headaches, but its wonderful when you get it working! I don't have the Oracle docs to hand, but there is a chapter on this in one of the manuals. There is also a pretty good example and explanation at...

Whenever dates confuse me I re-read a paragraph from this excellent book (IMHO!): "Beginning Access 2002 VBA" by Smith, Sussman et al: "The locale of VBA is always English (United States) irrespective of the way that you have configured the Regional Settings in your Control Panel. As a...

IMHO, EXISTS is a great keyword for these type of queries. eg. SELECT * FROM table1 WHERE NOT EXISTS (SELECT * FROM table2 WHERE table1.field1 = table2.field1) Basically, this selects everything from the first table where it doesn't match the criteria in the subquery.

Have you tried: cdate(Format([Enter the Beginning Date],"yyyy-mm-dd")) And <=cdate(Format([Enter the Ending Date],"yyyy-mm-dd"))? As Format converts the input to a string, you should convert the result back to a date. The field line should read similarly -...

Thanks belovedcej - I've had a look at the references and they appear to be the same. I have the following selected: Visual Basic For Applications Microsoft Access 11.0 Object Library Microsoft DAO 3.6 Object Library Microsoft ActiveX Data Objects 2.1 Library OLE Automation Am I right in...

Hi all, This is my first visit, and I have to say I'm impressed by the content here - nice to find a forum that gets to the point, and so shall I... I have an MS Access db (2000 format, but built in v2003). After making a number of unrelated form changes 1 of my queries now fails with the...