Navigation pane control!

[karanvemuri]

Hi guys, i have a db, with a log in form, made up by two tables tblusers,tbluserRights.

tblusers has fields active,currentuser,priority



I want to lock the navigation pane depending on the user who logged in. If the person is a adminstrator he has priority 1 which should get him access to the navigation pane.

If the person is an agent with priority 2, the navigation pane should be locked .. any ideas on how to code this?? truly appreciated

[Toyman]

Try this:
you must capture the the user priority and pass it on to a veriable

Dim Priority as Integer
Priority = "CapturedValue"

Select case Priority
Case 1
'hide the navagation pane
DoCmd.SelectObject acTable, “YourTable”, True
DoCmd.RunCommand acCmdWindowHide
Case 2
'unhide the navagation pane
DoCmd.SelectObject acTable, “YourTable”, True
End Select

End select

[karanvemuri]

hi mate, not running though ,ere's wat i put in the Form Load Event



Dim Priority as Integer
Priority = 2

Select case Priority
Case 1
'hide the navagation pane
DoCmd.SelectObject acTable, “Canada Daily”, True
DoCmd.RunCommand acCmdWindowHide
Case 2
'unhide the navagation pane
DoCmd.SelectObject acTable, “Canada Daily”, True
End Select

[Toyman]

hi mate, not running though ,ere's wat i put in the Form Load Event



Dim Priority as Integer
Priority = 2

Select case Priority
Case 1
'hide the navagation pane
DoCmd.SelectObject acTable, “Canada Daily”, True
DoCmd.RunCommand acCmdWindowHide
Case 2
'unhide the navagation pane
DoCmd.SelectObject acTable, “Canada Daily”, True
End Select

You set your "priority" to 2. Case 2 is to unhide the pane and Case 1 is to hide.

[karanvemuri]

ok,is there a way tht i can pass the priority value from 'tblusers ' with the user who logged in and pass it to the varieble?

[Toyman]

ok,is there a way tht i can pass the priority value from 'tblusers ' with the user who logged in and pass it to the varieble?

Yes, in your log in form, you probably have a code to check if the person logging in is actually a database user. From there, capture the id of the person logging in and run a dlookup in the tblUsersRight to get the priority number. Post the code for the log in form and I will give you a sample code