SSTab with diff dept and how user access each tab?

[frimily]

Hi All,

Is me again.. Hope you all will not feel i am so troublesome posting some silly questions always. Hehe..Here is my question

I have different dept in the SSTab.Altogether is 4 Tab,alright?Then, the user from this dept,let's say is repair dept can see the data from other dept,let's say is store dept. They might need to key in some data to the repair dept.

How am i going to enable them to key in some data in the field and some is disabled it? In such situation, is it means i have to do like as below:-

txtEngineer .enabled = True
txtVendor.enabled = False

till all the data is being set?

It is quite confusing if it really so. Pls help me. Thank you every body..

Have a nice day

[Static]

here is an idea:

In each text fields TAG property.. enter the dept name of who can use it like

txtVender.Tag = "repair service store" (enter each dept name thats allowed)

Public Sub SetSecurity(SecLevel As String)
Dim ctl As Control
For Each ctl In Me.Controls
    If TypeOf ctl Is TextBox Then
        If InStr(ctl.Tag, SecLevel) = 0 Then
            ctl.Enabled = False
            ctl.BackColor = vbButtonFace
             
        Else
            ctl.Enabled = True
            ctl.BackColor = vbWindowBackground
        End If
    End If
Next
End Sub
 
Private Sub Form_Load()
    SetSecurity "store"
End Sub

[Hack]

Is this the same question you have in your other thread?

If so, why are you making two threads for the same thing?

[frimily]

No.This is related to SSTab. Because all of my data is inside the SSTab.Therefore, i will ask questions regarding that but it is the different problems that i faced.

Ok,make it simple then. Actually, i want to make the user of current dept can view or update things in other dept. How can i make it view something in other department and at the same time some of the data it can add and update it? If like that, then i must do many time enabled and disabled stuff?

Pls help.Thank you everyone

[Static]

frimily.. read my post..

[frimily]

I've tried to use the code given,but when i login, the password login field is automatically disabled. Can i try the other way?

When the user of a dept,let's say is service dept login, they only manage to c their own dept, the other 3 tabs are invisible from them. Wat code should i put to make that?