|
|
Saving boolean data to an Access Database. 
Posted: 15 Mar 11 6:13 PM
|
I have a proram that saves a record to an access database it all work except for saving a check box to a yes/no field in MSAccess. How do I do this?
|
|
|
Bev Connor
Posts: 117
|
 |
|
Re: Saving boolean data to an Access Database.
Posted: 16 Mar 11 10:47 AM
|
First please confirm that your Access database field has its data type set to yes/no.
In your ITScriptNet program, open the properties window for your Checkbox element. Confirm that the Selected value is a 1 and the Unselected value is a zero.
Next, along the bottom of that properties window, there should display a drop-down to set the Database Field for this element. Confirm that the Checkbox element's Database Field drop-down list is set to your Access database's yes/no field.
|
|
|
|
Re: Saving boolean data to an Access Database.
Posted: 16 Mar 11 3:48 PM
|
| Thank you it worked! In one of the fields everything was right except I had the box do not save data checked, in the other the values were -1 and 0 not one and zero, once fixed it worked. |
|
|
|