user login

[Guest]

I use the Microsoft access security to log people in to the database as
either a user or an adninistrator. I then use a secondary login screen once
the user has gone through the initial microsoft access login,to determine the
format of the data screens eg with or without tool bars/slider bars etc.

Can I use the "CurrentUser()" parameter to hide toolbars etc from data users
so that I can eliminate the second login screen - if so, then how?

Thanks in advance.

Peter

 

[Brian Smith]

I use the Microsoft access security to log people in to the database as
either a user or an adninistrator. I then use a secondary login screen once
the user has gone through the initial microsoft access login,to determine the
format of the data screens eg with or without tool bars/slider bars etc.

Can I use the "CurrentUser()" parameter to hide toolbars etc from data users
so that I can eliminate the second login screen - if so, then how?

Thanks in advance.

Peter

You can do this through VBA or at least most of it. Depends on what you want
to hide. For toolbars I believe there is a ShowToolbar command that will let
you show and hide a given toolbar. Just use this command in conjunction with
CurrentUser().

Brian

 

[Rick B]

I used to use an "autoexec" macro to determine which switchboard and
toolbars display based on the user's group.