<div>
Is it a plain Access application or do you use SQL Server as back-end?
</div>


Is it a plain Access application or do you use SQL Server as back-end?

<div>
Hi,<br />
<br />
Will updating the form's Caption property be enough ?
</div>


Hi,

Will updating the form's Caption property be enough ?

<div>
<div class="content wysiwyg-content">
I want all the forms to show the names or title of a person logged in the application , the same way my application is able to authorize the the forms to use as per user rights, below is my code for segregation of duties:<br />
<br />
Private Sub Form_Open(Cancel As Integer)<br />
Dim strITAccounts As String<br />
Dim strITManager As String<br />
strITManager = &quot;Managers&quot;<br />
strITAccounts = &quot;Finance&quot;<br />
If (Forms!frmLogin!txtUserrig<wbr />hts.Value = [strITManager]) Then<br />
Cancel = False<br />
Exit Sub<br />
ElseIf Forms!frmLogin!txtUserrigh<wbr />ts.Value &lt;&gt;&nbsp;[strITAccounts] Then<br />
MsgBox &quot;You are not authorized to open this form!&quot;, vbOKOnly + vbExclamation, &quot;Rights Not Granted&quot;<br />
Cancel = True<br />
Exit Sub<br />
End If<br />
End Sub<br />
<br />
The above profile is for an accountant now all what I want to see in all forms is a title called accountant as per profile above.Any idea??????????<br />
<br />
Regards
</div>
</div>


I want all the forms to show the names or title of a person logged in the application , the same way my application is able to authorize the the forms to use as per user rights, below is my code for segregation of duties:

Private Sub Form_Open(Cancel As Integer)
Dim strITAccounts As String
Dim strITManager As String
strITManager = "Managers"
strITAccounts = "Finance"
If (Forms!frmLogin!txtUserrights.Value = [strITManager]) Then
Cancel = False
Exit Sub
ElseIf Forms!frmLogin!txtUserrights.Value <> [strITAccounts] Then
MsgBox "You are not authorized to open this form!", vbOKOnly + vbExclamation, "Rights Not Granted"
Cancel = True
Exit Sub
End If
End Sub

The above profile is for an accountant now all what I want to see in all forms is a title called accountant as per profile above.Any idea??????????

Regards

Logged in Details ( Ms Access application

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.