473,714 Members | 3,350 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Shortcut Menus

I recently discovered, that if you set the startup options for
"security", you will have alot of work do to get Access back to
"normal".

If you disable the built-in menus/toolbars you'll have to reconstruct
the one you want as a custom menu/shortcut(popup)/toolbar.

All this was a long journey in order to allow the user to sort/copy on
a datasheet view of a subform, with all the menus disabled in the
startup options.

I wanted to replace the built-in shortcuts when you right click on a
subform cell, row, or column and replace it with a custom menu. And I
discovered that there is more than one menu.

Following are the shortcut menus in question:

When Forms are used as Forms Only (Datasheet or Form View)
-------------------------------------------------
Datasheet View Column
Sort Ascending
Sort Descending
---------------
Copy
Paste
---------------
Column Widths
Hide Columns
Freeze Columns

Datasheet View Row
New Record
Delete Record
---------------
Cut
Copy
Paste
---------------
Row Height

Datasheet View Cell
Filter By Selection
Filter Excluding Selection
Filter For:
Remove Filter/Sort
---------------
Sort Ascending
Sort Descending
---------------
Cut
Copy
Paste
---------------
Insert Object
Hyperlink

When Forms are used as subforms Only
-------------------------------------------------------------------------
Datasheet View Subform Column (seem to replace "Datasheet View Column"
Subform Datasheet
---------------
Sort Ascending
Sort Descending
---------------
Copy
Paste
---------------
Column Widths
Hide Columns
Freeze Columns

Datasheet View Row (Same as above)
Datasheet View Cell (Same as above)

Now, if you disable shortcut menus in startup options and assign a
custom menu to a form, and if the form is used as a subform in
datasheet view, the custom menu will show only if you do row or cell
operations. Since it is a subform now, clicking on the column invokes
the "Datasheet View Subform Column", which it is disabled, so you will
not see a menu.

Using a form as a subform seems to revoke the "Datasheet View Column"
shorcut menu and points a column click to the "Datasheet View Subform
Column" shortcut menu.

This is confirmed by creating a simple form and viewing it in Datasheet
View, all the above shortcut menus are available except the "Datasheet
View Subform Column". Naturally, since the form is not being used as a
subform.

However, when you use the form as a subform in datasheet view the row
and cell menus are still available, but the "Datasheet View Column"
shortcut menu is now replaced with "Datasheet View Subform Column"
shortcut menu.

When shortcut menus are disabled with the startup options, and you've
assigned to the form your custom shortcut menu, row and cell operations
show the custom shortcut menu, however, since the built-in shortcuts
are now disabled a column click (which now points to "Datasheet View
Subform Column") does not work, in fact no shortcut is displayed.

So the question is, Is there a way to replace the "Datasheet View
Subform Column" with a custom menu and have it displayed appropriately?

This way, the user can right click on column, row, or cell and the
appropriate custome menu will show up. Users (IMHO) are more familiar
with right clicking columns to sort etc.

The subform doesn't have a shortcut menu bar property like the form, so
I am at a loss.

TIA

Nov 13 '05 #1
0 3547

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
2576
by: Lex | last post by:
I am writing a C# app that has a Menu. Some of the menu items will have short cuts that do not exist in the Shortcut enum. I would like the custom shortcuts to appear on the menu but as far as I can tell there is no way to add a short cut that is not in the Shortcut enum. I have my on keyboard hook so I am not worried about the custom shortcut magically working. I just want it to appear nicely formated on the menu. Anyone have any...
1
5902
by: deko | last post by:
I've found that the "Remove Filter/Sort" selection in the Shortcut menu (displayed on right click) produces ugly, untrappable errors, even though "Allow Filters" is set to No in the subform. However, the "Sort Ascending" and "Sort Descending" selections provide a helpful feature. Is there a way to get that "Remove Filter/Sort" out of the Shortcut menu? I've used this in some cases, but then I lose the Sort option:
3
2719
by: Terry Bell | last post by:
I have some code that adds entries to the "Module Compiled" popup menu. Works fine in A97. You can open a module, right click, and the new entries are there for you to click. I converted it to A2000, and reapplied the new entries. But now when you open a module and right click (in A2K), the new entries are nowhere to be seen. If (while in the database window) you click on View, Toolbars, Customize, Toolbars tab, tick the Shortcut Menus...
0
1387
by: MacDermott | last post by:
I have a main form with a subform in datasheet view. When I right-click anywhere on the subform, I would like to display a custom shortcut menu. I have created my shortcut menu, and have set the properties of each control, as well as the form, to display this custom form. This works fine if I click anywhere in the Detail section of the subform, or if I click on a RecordSelector. However, if I click on the header at the top of any column,...
2
3798
by: JMCN | last post by:
hi i'm having a problem with the customize a shortcut menu. i read the ms office assistance: customize a shortcut menu/delete a command or add to a shortcut menu and followed the simple directions. i tried both but for some reason i cannot delete the categories called "filter", "form", etc. eventually i would like to add commands to the "custom" category, ie commands "filter by form, "filter for:" and "filter by excluding" options and...
5
5178
by: Steven | last post by:
I have some text boxes on a form in MS Access 2000. When I right click in them I don't get any shortcut menu at all. I want the normal cut, copy, and past menu to come up. In the "Startup", I have the "Shortcut Menu Bar:" set to (default) The "Shortcut Menu Bar" property of the text boxes, is empty. So, where is my cut, copy, and past????? Thanks....
10
1950
by: Michael Maes | last post by:
Hi, I want to have a Button.Click event 'raise' a shortcut. If eg Button1 is Clicked, I want to have a shortcut 'CTRL + F12' activated. What's the best way to acchieve this. TIA, Michael
0
2912
by: ARC | last post by:
Hello all, For right-click (shortcut) menus in access 2007, I've been using a round-about method of opening access 97 on an old computer, modifying my own custom shortcut menus, then importing the menus only into my access 2007 project. This is proving cumbersome (especially since my old pc with access 97 likes to blue screen when running acc 97), and I was wondering if there's an easier way?
0
1723
by: Jim Devenish | last post by:
I have successfully added shortcut menus to Forms but I am now having difficulty when I attach a shortcut menu to a text control. I have a shortcut menu entitled 'CalendarEntries' with one command whose 'On action' is =showAbsence(). The control is on a Pop up Form called 'Calendar' that has a function: Public Function showAbsence() ...... End Function
0
8808
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8712
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9077
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9023
tracyyun
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...
0
7954
agi2029
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...
0
5959
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();...
0
4466
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...
1
3160
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
2
2525
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.