Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2005
    Posts
    5

    Unanswered: Hide Menu - Secure DB

    We are running access 97 and have set up a secured database. We want to hide all menu bars so users cannot see them, especially on reports. We went to the Customize option and unclicked Menu Bar. As soon as we unclick it, the Menu Bar disappears but reappears when we re-open it.
    On a non-secure db it stays hidden. How do we keep it hidden in a secured database?
    Thanks
    Steven B.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    there are some subtle approaches, but i have switched to a catch-all sledgehammer approach in Form_Load:
    Code:
        Dim cbar As Object
    
        '   /// kill the menus (will error so need the resume next)
        On Error Resume Next
        For Each cbar In Application.CommandBars
            cbar.Visible = False
        Next
        Set cbar = Nothing
        
        '   /// standard error handling
        On Error GoTo err_Form_Load
    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    and if you put =1 in the menu bar properties

    it will hide the "file edit view"

    then in the Caption I say CTRL+P to print it
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •