john j Posted February 14, 2007 Share Posted February 14, 2007 What is the best way of locking a record so it cannot be modified(text field) that is made on a different date than today. I want to be able to edit and change records made today but not to accidentally modify records made on previous days. This data field is a text field(s) that contain patient data that should be "locked at midnight". thanks, john Link to comment Share on other sites More sharing options...
Raybaudi Posted February 14, 2007 Share Posted February 14, 2007 Hi a way is to create a date field (date) with option to auto-enter the date of creation; and to put this calc into validation option of your text field: date = Get ( CurrentDate ) BTW: this isn't the best way, maybe the simplest :) Link to comment Share on other sites More sharing options...
john j Posted February 16, 2007 Author Share Posted February 16, 2007 I was trying to do this with privilege restrictions but using a get command with a calculation may be the best. thanks, john Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6272 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