|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Is it a good idea to create my own navigational buttons ??I have a new requirement to lock and unlock specify fields on the form such
that users can or cannot edit data field depending on the condition of other fields. For example, if the record displayed is Approved by a supervisor (indicated by the "Approved" field in the record, I'd like to LOCK the field such that other users cannot modify the contents of certain fields. If it is NOT approved, the user can still modify certain fields of the record At present, I'm using the default Navigational Button at the bottom of the form to allow users to browse the record. Is it a good idea for me to disable the Navigation Button feature in the form and then create my own set of Next Record, Previos Record, New Record, etc buttons to brows the record such that I can enable/disable the field based on the condition of one of the record field ? If so, can somone provide me some guidance on how to do it ? If it is not a good idea, can someone advise a method to achieve this objective ? Wellie wrote:
Show quoteHide quote > I have a new requirement to lock and unlock specify fields on the There is a pefectly good event that is meant to be used for this. The Current > form such that users can or cannot edit data field depending on the > condition of other fields. For example, if the record displayed is > Approved by a supervisor (indicated by the "Approved" field in the > record, I'd like to LOCK the field such that other users cannot > modify the contents of certain fields. If it is NOT approved, the > user can still modify certain fields of the record > > At present, I'm using the default Navigational Button at the bottom > of the form to allow users to browse the record. > > Is it a good idea for me to disable the Navigation Button feature in > the form and then create my own set of Next Record, Previos Record, > New Record, etc buttons to brows the record such that I can > enable/disable the field based on the condition of one of the record > field ? If so, can somone provide me some guidance on how to do it ? > > If it is not a good idea, can someone advise a method to achieve this > objective ? event of the form. Put your code there and it works no matter how the user arrives at the record (and there are LOTS of ways besides the buttons at the bottom). -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 
Other interesting topics
application deployment for SP2
New Post - Owner deleted - No backups, nothing! Problem with Multi-users in Access97 Suggestion on deploying and securing an Access appl Security in fields Preventing design changes with share-based security Workgroup file in Network drive and Local computer how I add an username + posword to a mdb file? Hiding database window In Security, Workgroup Administrator Add Check Box to always point |
|||||||||||||||||||||||
