Log creation for editing on a table

[kviglas]

Hello,

I have created a table containing jobs that need to be done from my team (IT production). Each time someone start or finishes a job, he must fill a box that updates a specific row in the table. I want to log the time of that action.

Any ideas of how I could set this up in Access? I have tried the Now() function in the Default Value of the field End Time, but this is updated everytime I refresh the table

 

[BarryMK]

Here's a suggestion, although there's probably a better way.

Add a date field to your table called Job

Add this field to your query and then to your form. Place a checkbox on your form called chkJobDate

Ad the following events to your form

Private Sub chkJobDate_AfterUpdate()
Form_Current
End Sub

Private Sub Form_Current()
If Me.chkJobDate = True Then
Me.job = Now()
Else
Me.job = Null
End If
Me.Requery

End Sub

When the checkbox is ticked it will input the date and time. Hope this helps.

 

[kviglas]

I created the field on the table and the checkbox on the form but I get the message pointing on the line Private Sub Form_Current():

Compile Error:

Method or Data member not found

 

[BarryMK]

Scrap the previous db the check box needs to be bound to a field so that you get blank fileds for each new record. Try this one

 

[kviglas]

Thanx a lot!

 

[BarryMK]

Thanx a lot!

You're welcome Mind you a little knowledge is a dangerous thing!