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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.