redballoon Posted January 11, 2008 Share Posted January 11, 2008 I would like to lock a users records after 2 weeks, so in the Priveleges section on the record tab I have limited the priveleges so that initialy only a person who created the record can edit it, I would then like to limit the time they have to 14 days.... I have got this far... creator = Get(AccountName) + date Entered ≤ GetAsDate ( text ) + 14 Of course this does not work ! but I think you can see what I am trying to do ? can anyone help here ? Thank in advance.... Link to comment Share on other sites More sharing options...
David Jondreau Posted January 11, 2008 Share Posted January 11, 2008 + is a mathematical function. AND is a logical operator. "Date Entered" should be an auto enter field for the Creation Date and "Creator" an auto enter field for the Creation Account name. Able to Access: ( Creator = Get(AccountName) ) AND ( Date Entered + 13 >= Get(CurrentDate) ) Link to comment Share on other sites More sharing options...
redballoon Posted January 19, 2008 Author Share Posted January 19, 2008 OK thanks got that bit but how to lock a record a record now fter a period of time so it can be viewed or copied but not altered... Link to comment Share on other sites More sharing options...
redballoon Posted January 20, 2008 Author Share Posted January 20, 2008 Thanks, so how would I include hat logical operation to lock a file after the specified time ?? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5964 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now