Hello all
I need your help to add permissions or password to some Pages into ( Tab Control ) in Microsoft access forms
Hello all
I need your help to add permissions or password to some Pages into ( Tab Control ) in Microsoft access forms
Last edited by eMassroua; 05-24-2023 at 02:05 AM.
TABS of what - Navigation Form, Tab Control, Tabbed Documents?
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.
If on a tab control you need to use its Change event:
https://learn.microsoft.com/en-us/of...control.change
Here are a few links that come up when I googled for "access vba tab control change password":
http://msaccess.erpmakers.com/Articl...cess%20vba.php
http://www.databasedev.co.uk/tab-control.html
https://www.access-programmers.co.uk...g-tabs.249067/
Cheers,
Hi,
Tab Control
For a different approach, if your users have to login to your database, it is a simple matter to assign permission levels to each user.
You can then use these to control which tabs are displayed on your forms for each level. No passwords needed.
If it's absolutely vital that some people can't view that information, then don't use MS Access for that. Imagine saving the credit card info of your clients in an Access database with a lot of users, that would be the stuff of nightmares, money is enough incentive to google how to break into an access database which has a tab control protected by a password from VBA. In fact, one of your users can come to one of these forums and ask how to remove a password from a tab control, someone will be willing to help and that credit card info will be exposed.
With that aside, just create a form that pops up when a user tries to change from a normal tab page to a protected tab page.
FWIW, tab control pages have a visible property that can be changed via VBA depending on the current user.