ms access Startup

[Kay]

Hi

I am using access 2000. I have created a database and have applied the
security feature available as Ive got 2 different groups of users. I
have a 'managers options' and 'users options' forms in the database.
Is there any way that when the database starts up that I can open one
of these forms depending on the user signing in
e.g if a user signs in, the user options for to run at startup and if a
manager signs in, a managers options form to run at startup.

Any help is much appreciated

[Keith Wilby]

"Kay" <kh******@hotmail.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...

Hi

I am using access 2000. I have created a database and have applied the
security feature available as Ive got 2 different groups of users. I
have a 'managers options' and 'users options' forms in the database.
Is there any way that when the database starts up that I can open one
of these forms depending on the user signing in
e.g if a user signs in, the user options for to run at startup and if a
manager signs in, a managers options form to run at startup.

Any help is much appreciated

Yes you can use the CurrentUser method to return the name of the current
user of the database in your main form's Open event:

If CurrentUser = "MyUserName" Then
'Do something
Else
'Do something else
End If

HTH - Keith.
www.keithwilby.com

[Haim]

Hi,
For my opinion:
1) It will be better if you manage the users with tables like
"tblUsers" if you do so ignore this step.
2) On 'tblUsers' you shall add another field except UserName & Password
, "Status".. this field will determine if the user is 'manager' or
'user'
3) Then you shall create "Main Form" that will get user's details
like(Password,UserName..) and when you get the user details you shall
check on 'tblUsers' if it is 'manager' or 'user' and this form will
open the correct form for the specific user.

** There's another options by use "Environ" function for identify the
current user/computer..
If u have a users Table,

[Scott McDaniel]

On 27 Mar 2006 03:21:09 -0800, "Kay" <kh******@hotmail.com> wrote:

Hi

I am using access 2000. I have created a database and have applied the
security feature available as Ive got 2 different groups of users. I
have a 'managers options' and 'users options' forms in the database.
Is there any way that when the database starts up that I can open one
of these forms depending on the user signing in
e.g if a user signs in, the user options for to run at startup and if a
manager signs in, a managers options form to run at startup.
If you'd prefer to do this dependant on the Group membership, you'd do something like this:

'/this was taken from the MS Security FAQ:
http://support.microsoft.com/default...#_Toc493299691

Function faq_IsUserInGroup (strGroup As String, strUser as String) As Integer
' Returns True if user is in group, False otherwise
' This only works if you're a member of the Admins group.
Dim ws As WorkSpace
Dim grp As Group
Dim strUserName as string

Set ws = DBEngine.Workspaces(0)
Set grp = ws.Groups(strGroup)
On Error Resume Next
strUserName = ws.groups(strGroup).users(strUser).Name
faq_IsUserInGroup = (Err = 0)
End Function

So in your startup routine:

If faq_IsUserInGroup("managers", CurrentUser) Then
DoCmd.OpenForm "managers options"
Else
DoCmd.OpenForm "users options"
End If

Any help is much appreciated

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com