Search results

  1. I

    Querying Null Date Value

    Ok, understood, what is the value Is Null as part of the search parameter. 10% of the entries in that field only contain a value other than Null. The user will select either a date value, or by default, unless otherwise selected, the value will be null in the date field Regards
  2. I

    Querying Null Date Value

    OK, I found that the bracket needed to go at the end, however it still does not work. Any ideas?
  3. I

    Querying Null Date Value

    It does not appear to like that line of code, it keeps saying that there is a missing parenthasis in the expression. Damned if I can find it. Well obviously I can't find it because it is missing, but can find where it is supposed to go Regards
  4. I

    Querying Null Date Value

    I have a form that provides information to a query utilising Like statements, as displayed below SELECT tblArchive.DateTo, tblArchive.IndividualsName, tblArchive.BoxNo, tblArchive.Reference, tblArchive.TenantorDescription, tblArchive.ToBeDestroyed, tblArchive.DateDestroyed, tblArchive.DateFrom...
  5. I

    Format Date Problem

    Thanks for you help Brian today, mucho appreciated Regards
  6. I

    Multiple criteria to be met problem

    More than one way to skin a cat. I like that approach, that'll do Thank You
  7. I

    Format Date Problem

    I found exactly the same thing yesterday on another date field I was working on, however I did not actually get as far as you in the detection of what causes it or the logical steps to recreate it. Ummmm, Microsoft Feature I guess. Unless it is similar to the Excel thing where certain data...
  8. I

    Format Date Problem

    OK, Brian, I will keep pluggin away at it Perhaps you can redeem yourself with this problem http://www.access-programmers.co.uk/forums/showthread.php?t=82557 Regards
  9. I

    Multiple criteria to be met problem

    I have a series of text boxes on my form. The user makes various selections in order to submit a query to the database. The default value for these boxes is * When the user clicks on the submit button, I only want the code to run for the button as long as not all of the boxes still have a * in...
  10. I

    Format Date Problem

    The DB has been open and closed many many times Regards
  11. I

    Format Date Problem

    Hi Brian I have set the format of the combo to mmm yyyy already. This is the bit I do not understand. Everything from source to display is set to that value and yet it appears to make no difference Regards
  12. I

    Date Equivelant of this line?

    Yeah Brian, what a load of old rubbish. God you don't half go on and on and on. Only kidding. I revisted my query and form and it 'seems' 0K now, although I am not really sure why. Maybe it was just one of those days where even ABC123 is complicated Thanks for your comments. Kindest Regards
  13. I

    Format Date Problem

    I have a query which formats the date field I have to mmm yyyy. This result set is accessed by a combo box. When it appears in the list of the combo the format is mmm yyyy. When you make you slection from the list, it reverts the date back to dd/mm/yyyy. I have changed the format of the combo...
  14. I

    Timed event on form

    Works like a charm, thank you very much and apologies for not noticing the amended code Kindest Regards
  15. I

    Timed event on form

    My Bad, sorry Regards
  16. I

    Timed event on form

    and the slight amendment is? Regards
  17. I

    Timed event on form

    I have put the code in in the two places suggested but the label does not disappear Regards
  18. I

    Moving OK button

    I am just writing a DB for one of the ladies who sits downstairs and I wondered if anyone knew where I could get the code that basically prevents them being able to click on OK when a message box appears. I would just like the msgbox to move somewhere else on the screen so she can chase it...
  19. I

    Timed event on form

    I wish a label to be visible for only 10 seconds when the call is made to it. I am sure this is basic VB stuff. How can I set it so that when Me.lblnodateten.Visible = True is fired, a 10 second counter will kick off and then the line Me.lblnodateten.Visible = False will activate Kindest...
  20. I

    Date Equivelant of this line?

    Yeah maybe. I will revisit it and see what I screwed up Thanks
Back
Top Bottom