can't set value to null when checkbox property = false

[sajarac]

Hello guys I have access 2010, the form has a date field which is not a Date picker or active X control, and every time when I add a new record I got this message:

can't set value to null when checkbox property = false

any idea how to get rid of?

Many thanks

 

[GinaWhipp]

Are you trying to set a Check Box to Null?

 

[sajarac]

thank you very much for your reply, the weird part here is because I'm using access 2010, and I am not including date picker, the field was set as date time field and use date picker for dates.

 

[jdraw]

?? Don't understand your post.

Please describe what is or is not happening. Use an example if possible.
Where does the Checkbox fit in your set up?

 

[sajarac]

Let me try again, I'm using access 2010, and I have a form, in this form I have several fields and one of them is order date, is not a date picker I mean is not an inserted active x control, but in the properties I've select use date picker for dates. Now every time when I click in new record I got that message

 

[jdraw]

I suggest you post a copy of your database. Remove anything confidential. All readers need is enough data to illustrate the issue.
Suggest you attach in zip format.

 

[sajarac]

Thank you very much for any help, here is a copy of the file, try to add a new record and you get the error.

 

[jdraw]

I think I added a new record without any error.
You didn't provide instructions of what to do to add the record.
So, I found 5 records, then added another. I did add some values to other fields.
Attached is a jpg of record 6 of 6.

If this isn't what you expected, please provide details showing what you do to get the error.

I am using Access 2010 on windows 8.1.

 

[bob fitz]

I don't know if this helps at all but I was also able to add a new record but I did get an error message "There is no object in this control" when the form opened.
I also have a missing reference. Using A2013

 

[jdraw]

Just saw Bob's post. And, yes I did get that message at the start. I ignored it and added the record. I did not get an error when I added the record.

 

[bob fitz]

Just saw Bob's post. And, yes I did get that message at the start. I ignored it and added the record. I did not get an error when I added the record.

I had no error message when adding a new record either.

 

[sajarac]

i get the error when I tried to add a new one, but after two clicks the message goes away, see my screen shot

 

[GinaWhipp]

The Reference to...

Microsoft Windows Common Controls 6.0 [mscomctl.ocx] (SP6)

...is what is causing the error. Once I removed it no error.

 

[sajarac]

Sorry, could you please let me know how to do that?

 

[jdraw]

Good eye Gina! I just reopened the database, looked at the references and saw the MISSING mscomctl.ocx and as you said, remove it and error goes away.
Thanks.

 

[sajarac]

But how to do this please, I am getting mental!!!

 

[sajarac]

Thanks, but please how to do that, I am getting mental !!

 

[sajarac]

Got it...got it...got it......

is the field marked as "Hora" which is "time" I don't know how to include a time picker so in the setting I've chosen Format: 2 -dtpTime, that is the error, so I guess I have no choice and change this field for an user input field rather than a select.

Thank you very much to all of you guys who helped me out with this issue.!!

Many respects!!

 

[GinaWhipp]

sajarac,

How to remove References...
http://www.access-diva.com/d5.html

 

[GinaWhipp]

Oh, I see I was too late! Oh, well.. better late than never.