Microsoft access Tabs permissions

[eMassroua]

Hello all
I need your help to add permissions or password to some Pages into ( Tab Control ) in Microsoft access forms

[June7]

TABS of what - Navigation Form, Tab Control, Tabbed Documents?

[Gicu]

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,

[eMassroua]

Hi,

Tab Control

[isladogs]

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.

[Edgar]

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.

[davegri]

FWIW, tab control pages have a visible property that can be changed via VBA depending on the current user.