Nelson Barros Posted February 23, 2007 Posted February 23, 2007 I to all! I need some expert help! I have a database, and i need to lock some records, (entire records), with a script,geting acess to the record again with password. Thanks in advance for your help!
Twd70 Posted February 23, 2007 Posted February 23, 2007 if the record is to be seen only by certain users you can set the accounts to allow only named users/those who meet certain cryteria. more info on exactly what you need please
Nelson Barros Posted February 23, 2007 Author Posted February 23, 2007 Hi! The records are to be made by all users, but after that, we want to lock them to prevent accidental alterations. Thanks again for the help!
Inky Phil Posted February 23, 2007 Posted February 23, 2007 It would appear from your last post that there are only two views of a record - the new record entry view and the existing record data view. Rather than 'lock' the records by script, why not just use the script to direct the user who wishes to view a record to a layout where the fields are not editable. Phil
Twd70 Posted February 23, 2007 Posted February 23, 2007 ah! ok if we're going for a create then lock thats simple! 2 layouts 1 for creation / editing 1 for viewing. layouts -> duplicate then select all fields and change 'behaviour', untick the 'enter in browse mode box' this will prevent editing on this layout, but you can still go to your create / edit page to do, well... what it says on the tin, create & edit. that what you were after? if your still not clear say so + ill do screenshots.
Nelson Barros Posted February 23, 2007 Author Posted February 23, 2007 Hi again! We still with the same problem! My database, is a db with 6 differents layouts, where we put information about samples. Some of that layouts have the same information, and they are to print like a document. So, when we receive a sample, one of us made a new record, where we put the information about that sample. After that, we need to introduce data in that record 3 or 4 times. It is the moment i need to lock the record to prevent acidental changes. Thats my big problem! Thanks again in advance for any help, and sorry my confuse english!
Recommended Posts
This topic is 6485 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