when start

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I know when i start a db i can make it so i close tollbars and and so on
This i can see in tolls/start
But can't i not say if user = "1" then show somthing
and if user ="2" then show me something else
Like if a user is admin then show me all tolls or
if user = normal then don't show tools

Hope someone understand me

Best regards alvin
 
Hi

I know when i start a db i can make it so i close tollbars and and so on
This i can see in tolls/start
But can't i not say if user = "1" then show somthing
and if user ="2" then show me something else
Like if a user is admin then show me all tolls or
if user = normal then don't show tools
Click to expand...

What you'll need to do is put some VBA code in either code called from
the AutoExec macro or (probably better) in the Open event of the
Startup form. This will let you check CurrentUser() to identify who's
logging on, and explicitly set the toolbars. The Tools... Start menu
doesn't have the flexibility you need.

John W. Vinson[MVP]
 
"John Vinson" skrev:
What you'll need to do is put some VBA code in either code called from
the AutoExec macro or (probably better) in the Open event of the
Startup form. This will let you check CurrentUser() to identify who's
logging on, and explicitly set the toolbars. The Tools... Start menu
doesn't have the flexibility you need.

John W. Vinson[MVP]
Hi
Click to expand...
I have some code there check the currentuser i also made it so
the currentuser open a specific form. But it the last thing i need
something like toolbar = hidden or somthing like that or better
hidden all access and only see the forms ?? like in excel where you
can hide excel and only show your form

Alvin
 
Back
Top