user login

P

PETER

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
 
B

Brian Smith

PETER said:
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
Click to expand...

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
 
R

Rick B

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