User power

J

Jon

Greeting,
I have created the below code and I placed it in event on load of the main
form. It works with only if the user added to the table or not. What I want
to do is set up more user power (read, write, delete, and full control. How
to do that with same table of user power please??
Dim CurrUser As String ' once user login to db
Dim allowUser As Variant ' the allowed users
'========================= to get cuurent user
CurrUser = NetworkUserName()
allowUser = DLookup("[EmployeeID]", "Employee Privileges", "[EmployeeID] ='"
& CurrUser & "'")
If allowUser > 0 Then
Me.Command37.Enabled = True
Me.Command38.Enabled = True
Me.AllowAdditions = True
Me.AllowDeletions = True
Me.AllowDeletions = True
Me.AllowEdits = True

Else
Me.Command37.Enabled = False
Me.Command38.Enabled = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top