Login User

[lukni]

Hi,

1st question:
I have an Approach Database that is shared by twelve users. Every user has his own password. Is there any possibility to transfer the user-name into a variable after login?
2nd question:
Has Approach any capabilities to show, which users are currently online?

Thanks in advance

 

[paulbent]

Add the variable field to the opening view and edit its object name (Macros tab, Info Box) to fbxUserName. Create a Global LotusScript sub:

Public Sub sGetUserName
CurrentView.Body.fbxUserName.Visible = False
End Sub

Press F5 to run the sub and make the field invisible. Then edit the sub to fulfil its intended purpose of assigning the user name to the variable field:

Public Sub sGetUserName
CurrentView.Body.fbxUserName.Text = CurrentDocument.User
End Sub

Finally, create a macro named Open to call the sub when the apr is opened from disk:

View switch to opening view
Run sGetUserName

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[paulbent]

Re Q2: There's no built in facility to see who's currently using an apr or dbfs.

You would have to write something to a dbf when the user opens the apr and clear it when they close it; then you could query this dbf to see who is currently logged on. It's not easy to make this 100% reliable because the user must always close the apr via your procedure to clear them from the dbf.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[lukni]

I'll try it, thanks.