Show or Hide tabs

[jonathanchye]

Hi all,

I've used the MS Access 2010 Tabs feature to create 3 tabs as subform in my main form. Can I set Tab 2 and Tab 3 to stay Hidden based on a criteria like user access level? I can't seem to find a way to do that at the moment.

Thanks.

 

[gemma-the-husky]

something like

tabctrlname.pages("pagename").visible = FALSE

 

[Adam Caramon]

How many users do you have? Take a look at the following site:

http://www.databasedev.co.uk/get_username_or_computername.html

It details a function that allows you to get the username of the person using the database. In my database, since I have only a few users, I run a simple if check on a form's on_load event to permit/prohibit certain users from accessing controls.