Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checkbox value & Datagrid

Status
Not open for further replies.

kre1973

IS-IT--Management
May 5, 2006
47
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top