Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

MenuBar

Discussion in 'Information Technology' started by Frank H, Jul 28, 2006.

Tags:
  1. Frank H

    Frank H
    Expand Collapse
    Guest

    Can anybody assist ?
    I want to prevent the menu bar from displaying for specific forms / reports
    only.

    According to Access help:

    'If you set the MenuBar property to a value that is not the name of an
    existing menu bar or menu bar macro, the form or report will not have a menu
    bar (the default menu bar will not be shown).'

    If I set the menubar property to a non existent value, I get an error
    message.

    Is there another simple way to turn the menu bar off "

    I have experimented with 'DoCmd.ShowToolbar "Menu Bar", acToolbarYes/No",
    but this applies to the whole app, and I don't want this.

    TIA

    Frank H
     
  2. default105

    default105
    Expand Collapse
    Guest

    I have never done this for only a few forms because I usually apply it to the
    whole database but couldn't you apply DoCmd.ShowToolbar with the Open and
    Close events respectively

    "Frank H" wrote:

    > Can anybody assist ?
    > I want to prevent the menu bar from displaying for specific forms / reports
    > only.
    >
    > According to Access help:
    >
    > 'If you set the MenuBar property to a value that is not the name of an
    > existing menu bar or menu bar macro, the form or report will not have a menu
    > bar (the default menu bar will not be shown).'
    >
    > If I set the menubar property to a non existent value, I get an error
    > message.
    >
    > Is there another simple way to turn the menu bar off "
    >
    > I have experimented with 'DoCmd.ShowToolbar "Menu Bar", acToolbarYes/No",
    > but this applies to the whole app, and I don't want this.
    >
    > TIA
    >
    > Frank H
    >
    >
     
  3. Frank H

    Frank H
    Expand Collapse
    Guest

    Thanks for the reply, probably no real reason to not do it like that, cheers

    "default105" wrote:

    > I have never done this for only a few forms because I usually apply it to the
    > whole database but couldn't you apply DoCmd.ShowToolbar with the Open and
    > Close events respectively
    >
    > "Frank H" wrote:
    >
    > > Can anybody assist ?
    > > I want to prevent the menu bar from displaying for specific forms / reports
    > > only.
    > >
    > > According to Access help:
    > >
    > > 'If you set the MenuBar property to a value that is not the name of an
    > > existing menu bar or menu bar macro, the form or report will not have a menu
    > > bar (the default menu bar will not be shown).'
    > >
    > > If I set the menubar property to a non existent value, I get an error
    > > message.
    > >
    > > Is there another simple way to turn the menu bar off "
    > >
    > > I have experimented with 'DoCmd.ShowToolbar "Menu Bar", acToolbarYes/No",
    > > but this applies to the whole app, and I don't want this.
    > >
    > > TIA
    > >
    > > Frank H
    > >
    > >
     

Share This Page