Date/Time Picker error msg "Can't Set Value to Null when Checkbox property = False"
I believe this is a common problem- perhaps a fault with the program...
I need to have three boxes. 1- Date. 2- Start Time, 3- End Time
I thought the easiest way to do this would be to use the Microsoft Date and Time picker Control version 6.0. Except when I link the Control Source to the fields in my table it instantly comes up with the warning message when you run the form: "Can't Set Value to Null when Checkbox property = False". The only way I can find to get rid of the error msg is to add a checkbox but I don't want one!!! How do I get around this?
I also want to save the date to a second field in the table- how would I do this?
Alternatively if anyone has made a good date and time picker that they don't mind sharing...! (I really hate the visual display fo the calander on the date picker- what's with the red almost circle!)
Help very much appreciated- I'm a non-violent person but right now I would really really like to punch my computer ahh!
I believe this is a common problem- perhaps a fault with the program...
I need to have three boxes. 1- Date. 2- Start Time, 3- End Time
I thought the easiest way to do this would be to use the Microsoft Date and Time picker Control version 6.0. Except when I link the Control Source to the fields in my table it instantly comes up with the warning message when you run the form: "Can't Set Value to Null when Checkbox property = False". The only way I can find to get rid of the error msg is to add a checkbox but I don't want one!!! How do I get around this?
I also want to save the date to a second field in the table- how would I do this?
Alternatively if anyone has made a good date and time picker that they don't mind sharing...! (I really hate the visual display fo the calander on the date picker- what's with the red almost circle!)
Help very much appreciated- I'm a non-violent person but right now I would really really like to punch my computer ahh!
