Form Restrictions

[Evgeny]

Hi guys, it there any way to restrict form control based on user? (logged in user).



Regards,

Evgeny

[ajetrumpet]

depends on what you mean by CONTROL

[Rawb]

The only way you could do something like that would be to have a Table in your database with all the user names in it and fields for any Forms, etc. that you want to limit access to.

Then, you have VB code that runs a check each time a user attempts to Open a Form similar to the following:

' Assume rstUserAccess is linked to your table and you're using
' Yes/No fields for each Form you want to limit control too.

strCriteria = "[Username]='" & CurrentUser() & "' And [MyForm]=TRUE"

rstUserAccess.FindFirst strCriteria

If rstUserAccess.NoMatch Then
  MsgBox "You don't have permission to view this Form!"
  Exit Sub
End If

DoCmd.OpenForm frmMyForm

EDIT: Fixed my syntax so that the code snippet would actually work (added the text in bold).

[Evgeny]

Thank you. I will give it a go

[Evgeny]

depends on what you mean by CONTROL

Things like table, forms access, operations of buttons and etc....