Interesting problem. I have a datagrid with several columns which are bound to an Access database. Two of the columns are checkboxes. The 1st and 4th columns are checkboxes.
Here's the situation...I'm concerned with the 4th column.
This is what currently happens... when a user clicks the checkbox in the 4th column it puts the value of "True" into the Access database for that column. When the user unchecks the checked checkbox it removes the value of "True" and becomes blank.
Now, this is what I'd like it to do if it all possible???
When the user checks a checkbox in the 4th column I want the current time to be put into the Access database instead of the value "True", maybe in a adjacent column. But, I want the checkbox to stayed checked when the application is re-opened. Also, I don't want the user to uncheck the checkboxes once checked. All the checkboxes are unchecked at the end of the day when I update the column with null values.
Basically, this application is meant to keep track of tasks that the user has to do at a certain time of the day. When the user checks the checkbox it would record the time in the database for that task as to when they did it. If they're allowed to uncheck the checkbox it would record a different time so they could cheat on doing their tasks at the proper time required.
I hope this all makes sense.
Any ideas?
Thanks!
Here's the situation...I'm concerned with the 4th column.
This is what currently happens... when a user clicks the checkbox in the 4th column it puts the value of "True" into the Access database for that column. When the user unchecks the checked checkbox it removes the value of "True" and becomes blank.
Now, this is what I'd like it to do if it all possible???
When the user checks a checkbox in the 4th column I want the current time to be put into the Access database instead of the value "True", maybe in a adjacent column. But, I want the checkbox to stayed checked when the application is re-opened. Also, I don't want the user to uncheck the checkboxes once checked. All the checkboxes are unchecked at the end of the day when I update the column with null values.
Basically, this application is meant to keep track of tasks that the user has to do at a certain time of the day. When the user checks the checkbox it would record the time in the database for that task as to when they did it. If they're allowed to uncheck the checkbox it would record a different time so they could cheat on doing their tasks at the proper time required.
I hope this all makes sense.
Any ideas?
Thanks!