Expiration for editing

[najah via AccessMonster.com]

Hello All,

I have a form where employees enter their time as well as their task. Once
they print their timesheet report, if they find any errors they can go back
and edit the form. However, to avoid any future discrepancies, we don't want
our employees to be able to go back and edit their timesheet months down the
line. Can I implement editing restrictions after a certain period of time
(30 days) where they can only view the data but not make any changes. Please
help!

 

[ManningFan]

Timestamp the record when it's originally created, then check the
timestamp before allowing an edited record to be written.

Simple as sex with fat chix.

 

[Guest]

Yes, you can do this in the Form's Current event.

If DateDiff("d", Me.txtPayDate, Date) > 30 Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End If

 

[Guest]

simplest sex with fat chix is on a water bed.... one pump and you're good for
the duration

Timestamp the record when it's originally created, then check the
timestamp before allowing an edited record to be written.

Simple as sex with fat chix.

 

[ManningFan]

Despite out differences of opinion, I knew I liked you for some reason.
;oÞ

 

[najah via AccessMonster.com]

Thanx a lot. By the way, I'm a Slim chick that doesn't do fat chix

Timestamp the record when it's originally created, then check the
timestamp before allowing an edited record to be written.

Simple as sex with fat chix.

Hello All,

[quoted text clipped - 9 lines]

Message posted via AccessMonster.com

 

[najah via AccessMonster.com]

Thanks Klatuu,

This was the easiest way to do this especially because I'm an access newbie.

Sorry, cant follow advice on fat chix and waterbeds. I'm a slim chick that
doesn't do fat chix

Yes, you can do this in the Form's Current event.

If DateDiff("d", Me.txtPayDate, Date) > 30 Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End If

Hello All,

[quoted text clipped - 5 lines]

(30 days) where they can only view the data but not make any changes. Please
help!

 

[ManningFan]

I won't hold that against ya... ;o)