Results 1 to 4 of 4
  1. #1
    wnicole is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    118

    Navigation Bar access to specific UserName

    THis is the code I'm currently using for my Login Form.
    My question is there a code I can to make sure each user see only a certain Navigation Bar as well. For example: This user below I only want to see the "Reports" Navigation Bar.

    UserName.SetFocus

    If UserName = "username" And Password = "password" Then
    DoCmd.Close
    DoCmd.Close , "F_Login", acSaveNo
    DoCmd.OpenForm "Switchboard"

    Can you assist please?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    You mean only show the Reports group in Navigation Pane? Why are users allowed to see any of the Navigation Pane? If they can see part, they can see all. Users should not work directly with tables or queries or the Navigation Pane. However, managing this is not easy.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    wnicole is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    118
    I agree. This was asked wasn't sure. Question: I as hoping to get the look where the buttons are lined up on the left if page and top but so when i click the form or report it appears on the screen.

    However I can only hit button and be taken to particular form or report. Is there a way I can setup a navigation pane to left and top much like a website setup?

    I know 2010 has the capability however I don't like the views

    Any suggestions would be helpful

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    I am not sure what you are talking about. The Navigation Pane lists all database objects and is positioned in the app at the left edge. If you are actually talking about a navigation form, that is entirely different issue. I don't like and don't use navigation form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 14
    Last Post: 08-17-2015, 02:32 AM
  2. Replies: 3
    Last Post: 05-03-2013, 12:57 AM
  3. Replies: 0
    Last Post: 03-13-2013, 08:00 AM
  4. Replies: 5
    Last Post: 09-01-2011, 07:04 AM
  5. Replies: 2
    Last Post: 08-31-2010, 08:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums