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!

  • Congratulations strongm 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: *

  1. HelsByTheDock

    Boss behavior - is this normal?

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

    Corrupt db? - it has 'forgotten' some functions

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

    pulling data , and the hiearcy

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

    I need British date format but goes in as American please help.

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

    Another request for query help

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

    oracle date timestamp

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

    Corrupt db? - it has 'forgotten' some functions

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

    Corrupt db? - it has 'forgotten' some functions

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

Part and Inventory Search

Back
Top