Switchboard

[Guest]

When opening my database, I have created a form for the user to enter their
password. Once this password is entered, I want the user directed to a
certain section of the switchboard. I have used [Switchboard
Items]![SwitchboardID]=5 And [Switchboard Items]![ItemNumber]=0 in the WHERE
condition of the Open Form Action in the macro. When I open the database and
enter the password, the Switchboard is still at the Main Menu.

 

[Rick B]

Why don't you set up Microsoft Access built-in user-level security rather
than reinventing the wheel.

You can then create an autoexec macro that opens the appropriate form based
on the user's group or login userid. You could even build code and forms to
allow the users to select which form starts when the application opens. You
could get as complicated as you like.

My database has a macro that look slike the following...

Condition:
[DBEngine].[Workspaces](0).[Users](CurrentUser()).[Groups](0).[Name]="Superv
isors"
Action: OpenForm
FormName: frmSupervisorMenu

Also,

Condition: [currentuser]="SMITHJOHN"
Action: OpenForm
etc.



My users are only members of one group (and of course, the 'users' group).
My macro basically looks like...



Rick B

 

[Guest]

I tried, but I don't have that program on my computer.

Why don't you set up Microsoft Access built-in user-level security rather
than reinventing the wheel.

You can then create an autoexec macro that opens the appropriate form based
on the user's group or login userid. You could even build code and forms to
allow the users to select which form starts when the application opens. You
could get as complicated as you like.

My database has a macro that look slike the following...

Condition:
[DBEngine].[Workspaces](0).[Users](CurrentUser()).[Groups](0).[Name]="Superv
isors"
Action: OpenForm
FormName: frmSupervisorMenu

Also,

Condition: [currentuser]="SMITHJOHN"
Action: OpenForm
etc.



My users are only members of one group (and of course, the 'users' group).
My macro basically looks like...



Rick B

When opening my database, I have created a form for the user to enter their
password. Once this password is entered, I want the user directed to a
certain section of the switchboard. I have used [Switchboard
Items]![SwitchboardID]=5 And [Switchboard Items]![ItemNumber]=0 in the WHERE
condition of the Open Form Action in the macro. When I open the database and
enter the password, the Switchboard is still at the Main Menu.

 

[Rick B]

What program?

I tried, but I don't have that program on my computer.

Why don't you set up Microsoft Access built-in user-level security rather
than reinventing the wheel.

You can then create an autoexec macro that opens the appropriate form based
on the user's group or login userid. You could even build code and forms to
allow the users to select which form starts when the application opens. You
could get as complicated as you like.

My database has a macro that look slike the following...

Condition:
[DBEngine].[Workspaces](0).[Users](CurrentUser()).[Groups](0).[Name]="Superv
isors"
Action: OpenForm
FormName: frmSupervisorMenu

Also,

Condition: [currentuser]="SMITHJOHN"
Action: OpenForm
etc.



My users are only members of one group (and of course, the 'users' group).
My macro basically looks like...



Rick B

When opening my database, I have created a form for the user to enter their
password. Once this password is entered, I want the user directed to a
certain section of the switchboard. I have used [Switchboard
Items]![SwitchboardID]=5 And [Switchboard Items]![ItemNumber]=0 in the WHERE
condition of the Open Form Action in the macro. When I open the

database
and

enter the password, the Switchboard is still at the Main Menu.