Multiuser login form

[atom]

I'm thinking of creating a login form , where user enters username and password before login.

I know that this can be done through a table with all needed information and according to that open a spesific form.


But how about user level permissions?

I have read that this can be done by creating .mdb files but then I can't open a form based on what user has logged in.

Is there a way to combine those two parameters I need?

I am using Access 2007

Thank you in advance

[R_Badger]

I have enclosed a sample of how to create a login, in order to control user level permissions do you want it to open a different form for different people who login? or hide/show certain elements of it?

I hope it helps a little!

[atom]

Thank you very much!
About user level permissions both would work ( open different form / show-hide certain elements on switchboard)
What would be the safest way?

[R_Badger]

You're welcome, I personally prefer to show/hide items as it means if i make a change I only really have to worry about one form. I have uploaded a new example using 'roles' to control who gets to see what.

There is another method I use which doesnt require directly logging into the database as such, I use a getnetuser() function someone wrote (I forget who otherwise I would credit you and link to your great work!) to get the username of the person logged into the machine running the file and compare it to a similar table to that in the example.
If their username doesnt show up, then all their permissions are set to "No" giving them read only access to my database, but that could be modified to prevent entry.

Apologies for the wall of text!

Safest is either really, because if you can break in to show objects, you can probably also break in to show the database window anyway and just bypass any security you have anyway.

I would try to explain a bit better but generally I overcomplicate things so I try to keep it short and sweet!

[atom]

That works great!
I never thought of this way using forms-queries..
Very nicely done thank you a lot!

[atom]

Please tell me , can I use the above method using a switchboard and if yes how?

[R_Badger]

Yes you can, you would have to modify the vb code (and copy it to your swtichboard).

Firstly, set all controls that you want hidden via properties to visible=no.

Then open the code builder and add the lines for the option and the label you wish to be viewed under the role ="yes" then section e.g.

 
Private Sub Form_Open(Cancel As Integer)
If [Forms]![userpermissions]![role1] = "Yes" Then
option1.visible=true
Label1.Visible = True
End If
If [Forms]![userpermissions]![role2] = "Yes" Then
option2.visible=true
Label2.Visible = True
End If
End Sub

Hope that helps!

[atom]

I think I should convert first switchboard's macros to vba .
As far as I can see this is a bit complicated.
I'll stick with the form (the only problem here is that I can't disable right click->close , so that the form always stays open) and if problems occur I will try switchboard

[R_Badger]

You dont have to convert the macros to vb (although for performance they are more efficient) all this does is hide the controls, and since if you cant see the controls you cant click them you're safe.

As for disabling the right click-close, do you mean for the switchboard? the user permissions form should open hidden so they can't see it.
You could use a macro/vb so when you navigate away, the script hides it, and then only make it visible if you navigate back.

[atom]

I'm trying to figure out how to make this via switchboard.
The switchboard has onOpen property embedded macro .
How can I add vba code too?

[R_Badger]

Its an either/or for macros and vb, the good news is you can do anything you can with a macro in vb.

If you would like it translating, although im not amazing at vb, i can do most things, so if you post the macro, i'll gladly give it an attempt at translation

[atom]

I have attached the macros that are running on_Open

Sir, I thank you so much

[atom]

One additional information ,the switchboard was generated by Switchboard manager.
So this is not a custom made form ,acting like a switchboard

[R_Badger]

Sorry for taking so long, Spent spent ages trying to find my access 2007 disc (i most use 2003 since its what we have at work) and unfortunately the set tempvar command isnt available there (since i dont use it normally i cant even remember how to use it), however i do have an alternative now i have thought about it, you could instead of running the vb code on the on_open event, try running it on the on_activate.

[atom]

Great! I appreciate your help
I will try it at evening and post back
Thank you