Showing startup menu dependant on user loged in

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

Guest

I have user level security active on my database, with the following user
groups: Agent, Manager, DBManager

I would like the main menu that is displayed when the application opens to
be dependant on the user group that has loged in.

Currently i am just using the startup options to set a defult menu.

Any help or direction on where i can look for answers would be great, thanks
 
in message:
I have user level security active on my database, with the following user
groups: Agent, Manager, DBManager

I would like the main menu that is displayed when the application opens to
be dependant on the user group that has loged in.

Currently i am just using the startup options to set a defult menu.

Any help or direction on where i can look for answers would be great, thanks
Click to expand...

I would do this:

1. Create an AutoExec macro that runs some module function.

2. Set the Startup form to be none.

3. In the module code, first check to see what group the current user belongs
to (there is code in the Seucirty FAQ to do this). Then depending upon what
group the user belongs to, you simply issue a different DoCmd.OpenForm
command to open the correct form.

Follow me?
 
Thanks Jeff that has answered my question.

could you let me know what "Action" to use in the macro inorder to run the
module ?
 
Select RunCode in the Action column.

In the Function Name area in the bottom left corner enter
something like: OpenSpecificForm()

Then create a new standard module (or use an existing one)
and create a new function called OpenSpecificForm()
and enter your startup code in that function.

Make sure you name the macro AutoExec so it runs whenever
the database starts up.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message:
 
Thanks very much Jeff

Jeff Conrad said:
Select RunCode in the Action column.

In the Function Name area in the bottom left corner enter
something like: OpenSpecificForm()

Then create a new standard module (or use an existing one)
and create a new function called OpenSpecificForm()
and enter your startup code in that function.

Make sure you name the macro AutoExec so it runs whenever
the database starts up.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message:
Click to expand...
 
You're welcome, glad to help.
Good luck with your project.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message;
 
Back
Top