How can i hide menu bar & restore it again?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • moonrb
    New Member
    • Nov 2013
    • 23

    How can i hide menu bar & restore it again?

    How can i hide menu bar & restore it again IN MS ACCESS DB ?
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32662

    #2
    You can use :
    Code:
    Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarNo)
    & :
    Code:
    Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarYes)

    Comment

    • moonrb
      New Member
      • Nov 2013
      • 23

      #3
      Thanks to you friend. Actually I am new in MS ACCESS. I want whenever I enter in my database, menu bar should not show. Please tell me where should I place this code provided by you.....
      Last edited by NeoPa; Nov 12 '13, 05:51 PM. Reason: Please don't use upper case (shouting) or text-style abbreviations.

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32662

        #4
        Originally posted by NeoPa
        You can use :
        Code:
        Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarNo)
        & :
        Code:
        Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarYes)
        This can be done, but only if you have something starting automatically when the database opens.

        I never use or recommend the use of macros, so that leaves a form. Each form can potentially have an Open event handler. Put the code in there.
        Last edited by NeoPa; Nov 14 '13, 02:27 AM. Reason: Added quote of other post to include all in Best Answer.

        Comment

        • moonrb
          New Member
          • Nov 2013
          • 23

          #5
          Thanks a lot friend. Now it works.....
          Last edited by NeoPa; Nov 14 '13, 02:26 AM. Reason: New questions must be asked in separate threads.

          Comment

          Working...