Hello I have a form that multi people can use, but I want only one field to have all users be able to update, and the rest of the fields they can view, but only myself can update them. Can you please advice. Thank you
Novice
Windows 7 64bit 
Access 2003
Hello I have a form that multi people can use, but I want only one field to have all users be able to update, and the rest of the fields they can view, but only myself can update them. Can you please advice. Thank you
VIP
Windows 7 64bit Access 2010 32bit
This would require a user info table, code that identifies who the user is (a login procedure in the db or grab the username from network login), and more code that sets Enabled property of textboxes.
Login procedure is common topic.
Restricting user interaction with forms based on user permissions is also common topic.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Is Access limited to a single CPU core during import ?
Indexes limited
Posting Permissions
Reply With Quote