Startup a database with a full screen switchboard form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DOUG - 27 Aug 2006 16:30 GMT

I want to start a database with a switchboard showing various users and have
them click their name to go to their own switchboard. I know how to set the
startup form but can't find the full screen start up setting. Also, can you
set each subsequent user's switchboard form to require a password to get the
form to open?

Reply to this Message

Ken Snell (MVP) - 27 Aug 2006 19:07 GMT

In the startup form's Activate event, put this code:

DoCmd.Maximize

As for password, you can write programming that will ask the user for a
password and then compare that to a password stored somewhere.

Signature

Ken Snell
<MS ACCESS MVP>

>I want to start a database with a switchboard showing various users and
>have
[quoted text clipped - 5 lines]
> the
> form to open?

Reply to this Message

DOUG - 28 Aug 2006 15:09 GMT

Thank you for the help. Can you be more specific about the programming?

> In the startup form's Activate event, put this code:
>
[quoted text clipped - 11 lines]
> > the
> > form to open?

Reply to this Message

Ken Snell (MVP) - 28 Aug 2006 21:01 GMT

Attach the following code to the form's Activate event:

Private Sub Form_Activate()
DoCmd.Maximize
End Sub

As for the password item, you'll need to tell us more information about
where the password is stored, how it's stored, and how the form would know
whether a correct password has been entered for the person or not.

Signature

Ken Snell
<MS ACCESS MVP>

> Thank you for the help. Can you be more specific about the programming?
>
[quoted text clipped - 14 lines]
>> > the
>> > form to open?

Reply to this Message