Date Stamp for CheckBoxes

[AmyLynnHill]

Does anyone know how to put a checkbox on a form and when the check box is changes from blank to checked it puts the current date in that field? Can this be done by formatting the properties or create an event? Or does VB Code need to be written? Any assistance would be helpful.

 

[ColinEssex]

Amy, In the AfterUpdate property of the CheckBox put this

If Me.CheckboxName = -1 Then
Me.FieldName = Date
Else
Me.FieldName = ""
End If

That'll pop the Date in or take it out

If the DateField is unbound you'll need to check the value of the checkbox when the form opens and put the date in if necessary

Col

 

[rhett7660]

ColinEssex

Thanks a bunch,, Just what I was looking for. One question. Is there a way to have the date permantly time stamped after you hit the update button.

The way I have the field setup is there are the initial fields one fills out. Once they are filled out you save the form. Then on a later date the user comes back and hits the check boxes to when they do a certain task. I would like to have it so that if they check the box......and hit the update button they can not go back and uncheck it..to remove the date and time. Does this make sense? But if they want to remove the check box prior to hitting the update they can click it on and off all they want.... is this possible?

I have a promt right now setup, if you hit the update button it asks you if you want to keep the current changes....

Thank you
R~

 

[YamiMarik777]

Checkbox w/ Date Stamp

I have a main form that has Vendor Number and Vendor Name. Then I created a subform that has the invoices attached to that particular vendor. I did create a checkbox labeled Paid. When a user puts a checkbox in I want Access to put Today's Date in the DatePaid field in the invoice. Another problems is when in the Invoice subform, when a user clicks on the Paid box, it puts a check in all boxes. How do you tell Access that to check to particular box that is clicked on?

Any Help would be greatly appreciated. Thank you.

 

[misslee1888]

Example

I have a small examples that I could show you but I cannot upload it. This is what it does. When you press the update button when the chkbox is ticked a time stamp is put in the textbox with a carriage return. This means that the time can be stamped as many times as you want and you can see all of the times that it has been updated. The is a scroll bar which allows you to view all of them and the textbox with the time stamp is locked so that it cannot be edited once the time has been stamped.

If you want me to email it to you then drop me a line with your email address.

 

[rhett7660]

misslee1888

You have a PM..

Thanks
R~

 

[misslee1888]

Example of time stamp

Here is the example. Let me know if you have any questions.

Thanks