Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754

    navagation pane to turn on depending on user level

    Hi all,


    Is there a way to turn on and off the navigation pane on the db programically? I havent been able to find out a lot of support for that on the web? I will turn if off for certain security levels and turn it on for ohters.
    Anyone point me in the right direction?
    thanks
    Dave

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Its not On/Off, more like Hide/Unhide

    Code:
    Private Sub HideNavP()
    
    
        DoCmd.SelectObject acTable, , True
    
    
        DoCmd.RunCommand acCmdWindowHide
    
    
    End Sub
    
    
    Private Sub UnHideNavP()
    
    
        DoCmd.SelectObject acTable, , True
    
    
    End Sub
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I have an example app that shows how to show/hide any or all of the nav pane, ribbon, taskbar or whole application interface.
    See http://www.mendipdatasystems.co.uk/c...ace/4594365418.

    Add select case statements to manage the appearance for different user levels
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Thank you, I will work with that!
    Youre awsome!

  5. #5
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Isladogs,
    That is really awsome stuff on that page.
    Thank you for sharing.
    Dave

  6. #6
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Gu Isladogs
    I love the site you have and thank you for all the info. I was looking at your login db and very well written
    Thanks for sharing.
    If in the future you make updates to it, would love to see the following:
    Case Sensitive Passwords
    Reset Password
    Forgot password
    And what about delete user?
    Thanks
    Dave

  7. #7
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    And what about delete user?
    Dont delete users. Mark them as inactive.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  8. #8
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Yes, good idea... I love your icon of the dog and message!
    Thanks
    Dave

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by d9pierce1 View Post
    Gu Isladogs
    I love the site you have and thank you for all the info. I was looking at your login db and very well written
    Thanks for sharing.
    If in the future you make updates to it, would love to see the following:
    Case Sensitive Passwords
    Reset Password
    Forgot password
    And what about delete user?
    Thanks
    Dave
    Thanks for the positive feedback.
    The password app is also very popular and I get lots of requests for additional features.
    I'll add yours to the request list but its unlikely I will be updating it soon.

    However, the app already includes code to deactivate users and to reset passwords
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #10
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I find the question interesting. Isn't it the norm to hide the pane from all users in a "finished" db and enforce the use of forms to navigate through the db? The only db that ought to have the pane visible is the main db that is strictly the development master?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by Micron View Post
    I find the question interesting. Isn't it the norm to hide the pane from all users in a "finished" db and enforce the use of forms to navigate through the db? The only db that ought to have the pane visible is the main db that is strictly the development master?
    Generally, that is my policy as well.
    However, some of my commercial apps are distributed with ACCDB FEs. With those apps, the idea is that the designated program admins have access to the nav pane & ribbon. Standard users do not.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #12
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    However, some of my commercial apps are distributed with ACCDB FEs.
    So they don't use that as the master and hide stuff (create accde) from the users in a production version? Then I guess they're not developers; rather they themselves are just users of a sort. I'm surprised that you would release any of your apps with everything discoverable by anyone but I guess you have your reasons.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  13. #13
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    For over 15 years, two of my apps for schools have effectively been 'open source' in the sense that once a network license had been purchased, individual schools were free to modify the app to suit their own purposes.
    Having said that the apps were very tightly locked down for standard users. No nav pane, no ribbon, strong security etc.
    For those users, code was inaccessible anyway despite the FEs being ACCDB files (the BEs are in SQL Server).
    As many of my clients have an increasing number of users on 64-bit, I have to ensure the code works in both bitnesses. One advantage of this approach was I didn't need to release 32-bit & 64-bit ACCDE files

    However, very few schools take advantage of this open code facility as it means that their versions are no longer be eligible to install the free updates released on the website (as those would overwrite any changes they had made). Instead, I am usually asked to implement extra features which are then done for an agreed price.
    The system has worked well for both them & me for many years but I no longer use this approach for any new apps.

    Most of my other commercial apps are released as ACCDE files with the exception of those written specifically for use by developers e.g. JSON Analyse & Transform for Access (JATFA)
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  14. #14
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Thank you isladogs
    I will review it more in the coming days as i really thought that log in was special!
    Fantastic code i could only dream of writing and actually knowing how to write it!
    Have a great day, will check back often!
    Thanks
    Dave

  15. #15
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    @d9pierce1, I think if you can dream it, you can achieve it. While I dont consider myself to be a vba guru, I think I have a solid grasp of the fundamentals. But I do recall in my early days asking a mentor how to raise a message box. Not sure if that helps because you would need to understand how far I have come on my own.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-08-2014, 06:37 PM
  2. Replies: 13
    Last Post: 11-18-2013, 02:20 PM
  3. Replies: 1
    Last Post: 08-13-2011, 04:44 AM
  4. Turn off Navigation Pane
    By newtoAccess in forum Access
    Replies: 9
    Last Post: 08-01-2011, 11:32 AM
  5. Replies: 8
    Last Post: 06-30-2010, 10: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