Logon - making lists depend on what the logon is

[Larshg]

I want to create a logon - witch several list and other fields should be dependent on - f.eks. the list should only show the records that is relevant to who ever is loged on.

Thanks

 

[ghubbell]

Vague question however check out help for "CurrentUser()":
If CurrentUser() = "Gord" Then
Application.Quit
End if
In queries: in the criteria for perhaps employee "first name": CurrentUser()

You could get very fancy with this working instead from workgroup information but I think this is a good start for you! Gord
ghubbell@total.net

 

[MichaelRed]

Form my experience, using individuals (CurrentUser))) requires to much efort. Essientially, each access needs to crosschecked to the individual. When the number of individuals gets to be more than a VERY few, the maintenance overhead is more than what is required to set up the workgroup security and assign individuals to groups.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[Larshg]

Tanks - I think

I don't even know how to make a logon. And then how to refer to it.