Showing the DATABASE Window

[Tom Ross]

Two questions.

If I elect not to show the database window on startup, is there a function
key combination that will open it?



Can the appearance of the database window be controled by the currentuser()
value? (some users will see it, others won't)


Thanks

Tom

 

[Brendan Reynolds \(MVP\)]

Two questions.

If I elect not to show the database window on startup, is there a function
key combination that will open it?
F11

Can the appearance of the database window be controled by the currentuser()
value? (some users will see it, others won't)

In the example below, I'm selecting the form behind which the code is
running in the database window. It doesn't matter what object you select, as
long as that object exists.

You may find it more flexible to use a group rather than an individual user
name. From memory, I *think* there's probably code showing how to determine
if a user is in a specific group at www.mvps.org/access.

If CurrentUser() = "Admin" Then
DoCmd.SelectObject acForm, Me.Name, True
DoCmd.Restore
End If