Data restriction by month

[eddy via AccessMonster.com]

Hi,

I just want to put some month age restriction to my database when user open
form. For example more than 3 month data, all field will be lock. All data
refers to field "InputDate". I tried with dateadd but it doesn't work.

Thank you

 

[Guest]

Look at DATEDIFF function in Access help.
Put code in OnCurrent event to lock all fields when date meets your needs

-Dorian

 

[eddy via AccessMonster.com]

Well I got it..

DateDiff("m", [DateUpdated], Date) < 3...

Thanks anywhre.

Look at DATEDIFF function in Access help.
Put code in OnCurrent event to lock all fields when date meets your needs

-Dorian

Hi,

[quoted text clipped - 3 lines]

Thank you