Search results

  1. C

    2010 f@#$@#$@!

    they removed the calendar control and snapshot viewer from 2010 access. both are problems for me....yuck!!! i know snapshot def gone, anyone figured a way to reference and get the calendar back yet?
  2. C

    filter string question

    ARRRRGHHH#$@#$@#$@#$@ somehow YOU ARE RIGHT. now, this sh!ts me on SEVERAL levels. 1. i read about this in advance. doing it right seemed to generate errors. prob my fault so not the biggest issue 2. DateSerial returns dates IN LOCAL FORMAT!!! so i can't use it to pass dates, work out last...
  3. C

    filter string question

    Dude i swear i had a DAO of a query for over 1.5 days working fine with ActivityDate: TransactionsDate in the query but some um, "reverted"? to just TransactionDate. Weird. how it ran all Friday i'll never ever know....
  4. C

    filter string question

    and yet giving the compiler 11/30/99 gives a compile error. is everyone one 2007 and later with this? i will triple check it.
  5. C

    filter string question

    LMAO!!! took me forever to check field names in query, esp SINCE THEY WERE FINE BEFORE...how the heck did it run last time???
  6. C

    filter string question

    when the date order is wrong i get a vba error so sure they're right and dateserial sends them that way...to elaborate a bit, what i'm showing is the debug.print statement. it seems unhappy to filter the jobnumber twice and the activity date at same time. would do 1 job number filter and a...
  7. C

    filter string question

    btw not sql direct. i'm using the .Filter property/method on a loaded DAO recordset. i'm considering filtering the recordset twice but seems inefficient and shouldn't really have to?
  8. C

    filter string question

    we're souther hemisphere access 2007 seems to be ok with that here. frankly the date was working till i changed the jobnumber thing. ie: JobNumber Like '096' Or JobNumber Like '096-*' works fine JobNumber Like '001*' And ActivityDate Between #1/01/1950# And #30/11/1999# -works fine...
  9. C

    filter string question

    seems to work on a query where i don't use the between dates. really need them, is there a max number of filter args that can be passed with the .filter method? do i have to filter twice? hope not...
  10. C

    filter string question

    ok i'm stumped here: this filter list on query ok, JobNumber Like '001*' And ActivityDate Between #1/01/1950# And #30/06/2010# but this one isn't: JobNumber Like '001' Or JobNumber Like '001-*' And ActivityDate Between #1/01/1950# And #30/06/2010# Can't see it myself. works in QBE grid but...
  11. C

    between date to date in vba(syntax)

    my information simply must be wrong or out of date, as the date() functions returns local format in debug.print....
  12. C

    between date to date in vba(syntax)

    i've read (not sure) that since we use the day/month/year format here in the UI i still need to code my dates month/day/year *US format* - DateSerial returns (to my surprise) day/month/year (my local format) i wonder if 2007 is now smart enough to run both code and UI on same date settings?
  13. C

    between date to date in vba(syntax)

    holy @#$. that is awesome!!!! exactly what i need, and will make programming it so easy. just tried it now :)
  14. C

    between date to date in vba(syntax)

    cheers, yes makes PERFECT sense and just the kind of thing you can soldier through and not know with more code (no doubt the road i would have been on) i may not be the best access developer (lol) but i've done autocad management and application development for 20 years and i delight in the...
  15. C

    between date to date in vba(syntax)

    i don't even know what to say bob - you just ANTICIPATED todays question (and believe it or not i work hard to look myself and not ask RIGHT away). breaking things into months was todays scripting exercise your a legend as always :) *runs off to read about DateSerial...*
  16. C

    between date to date in vba(syntax)

    i've reworked the code to be more object oriented date wise - i needed it for the month to month stuff anyway...that kind of functionality to the end user will have to come after this hurdle though.... I've done some access stuff over the years... every time seems to be a very different...
  17. C

    between date to date in vba(syntax)

    its very ok, tough but fair lol... i'm a southern hemisphere too, in Australia :) as for the non hard coded dates, ya i know. we're doing a report/spreadsheet that will calculate the Work In Progress to end financial year, then thereafter break following expenditure into months. this is the...
  18. C

    between date to date in vba(syntax)

    *gasp* did i detect sarcasm there?? lol....
  19. C

    between date to date in vba(syntax)

    thanks always nice when they are relatively simple
  20. C

    between date to date in vba(syntax)

    couple of quick questions....(same project as last time to those who helped) all going great, trying to sort the (now working) results a little more, first was by job number, now needs to be by job number and a DATE RANGE. was originally filtering my recordset (successfully) with this (the...
Back
Top Bottom