Re: Access Menu Bar 'Window' option

From: david epsom dot com dot au (david_at_epsomdotcomdotau)
Date: 07/27/04

  • Next message: Ken Snell: "Re: Problem with Filter/Query" 
    Date: Tue, 27 Jul 2021 13:14:21 +1000

    >From the 'startup' menu item you can specify a startup
    form. You could put code into the load event of the form.

    Or you can put code into a module, and call it from
    a macro called 'autoexec'

    (david)

    "Berny" <BlancoB at MSN dot Com> wrote in message
    news:e8RwIF%23bEHA.3580@TK2MSFTNGP11.phx.gbl...
    > Thanks for the information, I think this should work.
    >
    > Question is were do I put this code to execute at start-up? in a module?
    how
    > do I get it to execute at start-up?
    >
    > Sorry for the elementary question but I'm still knew at this.
    >
    > Thank you
    >
    > "Stephen K. Young" <s k y @ stanleyassociates . com> wrote in message
    > news:%23AWzqgPaEHA.972@TK2MSFTNGP12.phx.gbl...
    > > You can copy the Access built-in Window menu to your own menu, and
    > > manipulate it while your application is running, and put it back when
    > > done.
    > >
    > > For example, you can do something like the following, based on a
    variable
    > > isAppRunning:
    > >
    > > ' The Window menu popup in mnuAppMenu uses the standard full Access
    > > Window menu in order to display the list of open windows
    > > ' The [&Hide] and [&Unhide] are retained but made invisible (removal
    > > affects the standard toolbars).
    > > With mnuAppMenu.Controls("&Window").Controls
    > > ![&Unhide...].Visible = Not isAppRunning
    > > ![&Hide].Visible = Not isAppRunning
    > > End With
    > >
    > > - Steve
    > >
    > > "Berny" <BlancoB at MSN dot Com> wrote in message
    > > news:%23qUTzRNaEHA.3888@TK2MSFTNGP10.phx.gbl...
    > >> Is it possible to reference only Open Documents part of the menu or do
    > >> you
    > >> have to reference the entire menu item?
    > >>
    > >>
    > >> "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
    > >> news:%23rOhwPKaEHA.2408@tk2msftngp13.phx.gbl...
    > >> > These are a bunch of hidden, invisible place holders, that are
    updated
    > > by
    > >> > Access when you open or close a window.
    > >> >
    > >> > So your two options are (a) add a reference to the original menu
    item,
    > > or
    > >> > (b) create your own place holders, and update them your self. The
    > > problem
    > >> > with (a) is that any change you make affects the menu item, and the
    > >> > problem
    > >> > with (b) is that any change Access makes does NOT affect the menu
    item.
    > > I
    > >> > don't think there is any solution: If you want the menu items to be
    the
    > >> > ones
    > >> > updated by Access, then they have to be the menu items updated by
    > > Access.
    > >> > sorry...
    > >> >
    > >> > (david)
    > >> >
    > >> >
    > >> >
    > >> > "Berny" <BlancoB at MSN dot Com> wrote in message
    > >> > news:%23JAJn5QZEHA.2488@tk2msftngp13.phx.gbl...
    > >> >> Does anyone know how to add the feature under the 'Window' menu
    option
    > >> > that
    > >> >> lists the currently open documents?
    > >> >>
    > >> >> I can't seem to find it under the Menu Customize...
    > >> >>
    > >> >> The problem I'm having is that when I add it from the Built-in Menus
    > >> >> (Menu
    > >> >> Customize) or if I copy it, any changes I make to the New or Copied
    > > 'Menu
    > >> >> Option' also changes the original 'Menu Option'
    > >> >>
    > >> >>
    > >> >> Any help would be greatly appreciated
    > >> >>
    > >> >>
    > >> >
    > >> >
    > >>
    > >>
    > >
    > >
    >
    >

  • Next message: Ken Snell: "Re: Problem with Filter/Query"