Modifying the Window menu - Microsoft Access / VBA

Tim Marshall

I'm trying to have a menu item in a custom menu that serves the same
purpose as the standard Windows built in menu with respect to the list
of forms that are open. However, I don't want to let the users have
access to menu items such as, for example:

Hide - someone will hide the main menu form by accident when poking
about and panic.

Unhide - I have one major form with hundreds of bizarre text boxes which
stores setings on various forms, criteria chosen on other forms, etc. I
definitely don't want to give users a heart attack if they accidentally
unhide this.

I can bring a copy of the Windows menu (holding ctrl key and dragging it
from the main built in menu bar or be dragging it from the commands tab
of the custom9ize dialog, but whenever I modify this, the changes appear
on the main Access menu bar. Using a couple of commands like (where
position 7 is the position of the windows menu on custom menu mnuC):

commandbars("mn uC").Controls(7 ).controls(8).v isible = false

Results in the same thing, ie, the menu item in the windows menu being
invisible in all further instances of Access opened.

Any suggestions? What I'm looking for is a menu that lists all open,
visible, non-dialog forms that can be used to chage the focus to the
forms listed.

TIA
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Jun 28 '06 #1

Subscribe Reply

2590

MGFoster

Tim Marshall wrote:

I'm trying to have a menu item in a custom menu that serves the same
purpose as the standard Windows built in menu with respect to the list
of forms that are open. However, I don't want to let the users have
access to menu items such as, for example:

Hide - someone will hide the main menu form by accident when poking
about and panic.

Unhide - I have one major form with hundreds of bizarre text boxes which
stores setings on various forms, criteria chosen on other forms, etc. I
definitely don't want to give users a heart attack if they accidentally
unhide this.

I can bring a copy of the Windows menu (holding ctrl key and dragging it
from the main built in menu bar or be dragging it from the commands tab
of the custom9ize dialog, but whenever I modify this, the changes appear
on the main Access menu bar. Using a couple of commands like (where
position 7 is the position of the windows menu on custom menu mnuC):

commandbars("mn uC").Controls(7 ).controls(8).v isible = false

Results in the same thing, ie, the menu item in the windows menu being
invisible in all further instances of Access opened.

Any suggestions? What I'm looking for is a menu that lists all open,
visible, non-dialog forms that can be used to chage the focus to the
forms listed.

TIA

You'll have to make your own menu bar w/ a Windows item and only the sub
menu items you want. Then attach that menu bar to all visible forms.
When the application closes, Access' menu bar should reappear.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Jun 28 '06 #2

Tim Marshall

MGFoster wrote:

You'll have to make your own menu bar w/ a Windows item and only the sub
menu items you want. Then attach that menu bar to all visible forms.
When the application closes, Access' menu bar should reappear.

That's the unfortunate thing - I'm doing this, but for the sub menu item
that shows open forms, I can't seem to find it anywhere on either the
customise dialog or the actual built-in windows menu when I'm in
customize menus mode...
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Jun 28 '06 #3

Similar topics

2468

"Open .Net Command Window Here" context menu for Windows Explorer

by: Tom Dacon | last post by:

"Open .Net Command Window Here" context menu for Windows Explorer: The reg file described below adds a new menu item to Windows Explorer's context menu when you right-click over a folder (or the drive root). The menu item text is "Open .Net Command Window Here". When you click it, it opens a command window positioned at that directory and runs the vsvars32.bat file to set the .Net Framework environment variable settings. This makes it...

.NET Framework

4286

Modifying the Back Button Function

by: Peter D. Dunlap | last post by:

Hello, I realize that this may not be the best place to ask this question, through the application is asp.net. I also realize that questions about disabling the back button are generally met with derision, so let me explain: (1) The site is actually a web-based application, not a "web site" per say, and is not accessable by the public. It is an application used internally by the company I work for, though it accessed by employees

ASP.NET

2258

MDI app and Window menu

by: Steve Barnett | last post by:

I've created a simple MDI application and have designated the Window menu to keep track of the mdi children. When I first load an mdi child, it's caption consists of "File: no file loaded" and this is what appears on the Window menu. Now, after the mdi child loads, I call a method to load a specifically named file. At this point, the child changes it's caption to reflect the new file name. Unfortunately, the Window menu does not update...

C# / C Sharp

6271

Is there a way to disable the F-11 key to prevent runtime installations from opening the database window?

by: MLH | last post by:

If I give someone a runtime app, they can open the database window by pressing the F-11 key. How to prevent???

Microsoft Access / VBA

2423

Modifying windows layout(title bar)

by: Jon Slaughter | last post by:

I'm tryign to display my own title bar. I've created a window without one but with a menu. The menu though is located in the upper left corner and I need to move it down. I need to set the client windows location but I can't seem to get the menu to move as it always starts at the upper left of the form. I want basically to have the form work exactly like its suppose to but implement my own title bar. i.e., I don't want to have to position...

C# / C Sharp

1822

Problems Appending Text to a Side Menu from Main Window

by: joecap5 | last post by:

I have a main window from which I want to open a separate side menu window. I then want to create a list of items on that side menu by clicking on the item names in the main window. So far I am able to click on "Open Menu" and have the side menu open. I can then click on Items and have them added to the side menu using the innerHTML method or the node method. The trouble comes in when I try to have the side menu opened automatically...

Javascript

1566

Closing a menu window dynamically.

by: cnsabar | last post by:

Hi I am having a problem in closing a menu window using TK module dynamically. I use the following program. use Tk; $mw = MainWindow->new; $mw->geometry("1024x768");

Perl

2364

Modifying the system menu

by: raj.indian.08 | last post by:

Hi all, I am trying to modify the system menu of all the applications in my machine. For example say - I am creating multiple desktops for windows - and I want to give every application the capability to be moved across different desktops. So I wanted to modify the basic system menu list to include the new options. The methods I could think of are - 1. Modify the basic windows set of system menu values (best option)

Python

1772

access 2003 generate window selectors

by: afromanam | last post by:

Hi I've been setting up a custom toolbar on start up for the application via VBA code. I've generated, for the custom menu bar, the drop-down menus File, Edit, Window and Help and successfully added controls to each of them except for Window. I can't seem to add the funcitionality where upon opening a form it will add itself to the Window menu as an item so when it has lost focus it can be selected again. I looped through a database...

Microsoft Access / VBA

10313

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9944

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8968

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7494

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6735

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5378

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4044

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3643

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2875

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General