Different start-up for different users

V

Van T. Dinh

You don't want to maintain 3 different copies of the Front-
End! This creates more work for you whenever you want to
update the Front-End.

May be easier if you have a common start-up Form with 3
command buttons and each person can simply click the
command button taking him to his/her (former) Start-up
Form.

I am sure there are other ways to do this automatically
using the same Front-End but open different "Start-Up"
Form (e.g. identify the user using Access Security or
Windows UserID and then open the appropriate Form) but
IMHO, it is not worth the effort. Sooner or later, you
will have more users.

HTH
Van T. Dinh
MVP (Access)
 
D

Damien McBain

Or you could have 1 startupform with no controls and an onopen event which
checks the userid of the user and opens another form as appropriate.

I found a nice function (recommended by someone here) a while ago called
fOSUsername. It returns the windows login id of the current user. This may
be handy for distinguishing automatically between users. Google for it,
there's a lot of links.
 
V

Van T. Dinh

The function is available in The Access Web.

http://www.mvps.org/access/api/api0008.htm

But like I wrote in the last paragraph of my reply, IMHO, it is probably not
worth the effort. In my experience, databases never have static number of
users so doing this will require constant changes (unless UserIDs are stored
with their preferred StartUp Form Forms).
 
Top