date & time picker control ???

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • luanhoxung
    #1

    date & time picker control ???

    hi all !
    i have a date & time picker control bound to 1 field. it worked fine.
    But i always get the message :" Can't set value to Null when checkbox
    properties = FALSE" when i open my form.
    there isnot any checkbox or proceduce on my form.
    if the D&T picker control is unbound to any field, no message appear.
    Can anyone explain to me what is trouble ?
    Thanks ur time visitting my post.
    Luan from VietNam

    Tags: None
    • Tom van Stiphout
      #2
      Re: date & time picker control ???

      On Mon, 25 Dec 2006 22:11:49 -0500, "luanhoxung "
      <luanhoxung@yah oo.comwrote:

      That's how this control deals with Null values.
      If you have a date field that can be null, set the Checkbox property
      to True, and take out what's in the Value property.

      I personally don't like this behavior, but that's what the control
      does.

      -Tom.

      >hi all !
      >i have a date & time picker control bound to 1 field. it worked fine.
      >But i always get the message :" Can't set value to Null when checkbox
      >properties = FALSE" when i open my form.
      >there isnot any checkbox or proceduce on my form.
      >if the D&T picker control is unbound to any field, no message appear.
      >Can anyone explain to me what is trouble ?
      >Thanks ur time visitting my post.
      >Luan from VietNam

        Comment

        • luanhoxung
          #3
          Re: date &amp; time picker control ???

          Thanks, Tom.
          But...we cannot prevent this, can we?
          Luan from VietNam

            Comment

            • Larry Linson
              #4
              Re: date &amp; time picker control ???


              "luanhoxung " <luanhoxung@yah oo.comwrote in message
              news:4e4c0edb9a d6346d6c1683b57 aaa54bd@localho st.talkaboutdat abases.com...
              Thanks, Tom.
              But...we cannot prevent this, can we?
              Luan from VietNam
              You can replace the Date and Time Picker ActiveX with one of many similar
              funtions implemented by participants here, using nothing but Access'
              built-in Forms and Controls. With most of those, you have access to the
              original Forms, Controls, and Codes in design view and can change them as
              you wish, if you want to change a behavior. An added advantage is that, if
              you distribute your application to other users, you will not have to
              distribute the ActiveX control in addition to your database application.

              Larry Linson
              Microsoft Access MVP


                Comment

                Previous template Next
                Working...