Access Menu Bar 'Window' option

  • Thread starter Thread starter Berny
  • Start date Start date
B

Berny

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
 
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)
 
Is it possible to reference only Open Documents part of the menu or do you
have to reference the entire menu item?
 
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
 
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 said:
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 said:
Is it possible to reference only Open Documents part of the menu or do
you
have to reference the entire menu item?
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
Is it possible to reference only Open Documents part of the menu or do
you
have to reference the entire menu item?


These are a bunch of hidden, invisible place holders, that are
Click to expand...
updated
by
Access when you open or close a window.

So your two options are (a) add a reference to the original menu
Click to expand...
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
Click to expand...
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
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
Click to expand...
Click to expand...
Click to expand...
 
Thank You

david epsom dot com dot au said:
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 said:
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 said:
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
Is it possible to reference only Open Documents part of the menu or do
you
have to reference the entire menu item?


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
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top