Showing the DATABASE Window

  • Thread starter Thread starter Tom Ross
  • Start date Start date
T

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
 
Tom Ross said:
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)
Click to expand...

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
 
Back
Top