Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / March 2005

Tip: Looking for answers? Try searching our database.

Changing Shortcut Menu options

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FBxiii - 30 Mar 2005 08:59 GMT
Hi,

Is it possible to change the Shortcut Menu options for a list box, depending
on what is being displayed in the list box?

e.g.

Shortcut Menu looks a bit like this:

Copy
Update Status > *** Options to be changed on this sub menu ***
Move to Queue > *** Options to be changed on this sub menu also ***

Cheers,
Steve.
Alex Dybenko - 30 Mar 2005 09:53 GMT
Hi,
yes, you can use MouseUp event instead of Shortcut Menu property. first
check there that right button was clicked, then get a listbox value, and
depends on it show corresponding menu as:

commandbars("mymenu").showpopup

HTH
Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hi,
>
[quoted text clipped - 12 lines]
> Cheers,
> Steve.
FBxiii - 30 Mar 2005 10:45 GMT
Thanks for the reply Alex but what I want to do is change the properties of
the Items on the menu.  The items shown in the List box depend on what is
selected in a Combo Box (Work Queues).  Different Status' can be applied to
the items shown depending on the queue.

e.g.

Queue displayed = Invoice
Shortcut Menu Name = MPR_Queue_Menu

Menu items should be:

Copy
Update Status > Invoice Complete
               Query
               Pending

Queue displayed = Reads
Shortcut Menu Name = MPR_Queue_Menu

Menu items should be:

Copy
Update Status > Read Input
               Read Already Input
               Query
               Pending

I need to be able to add and remove options as necessary and pass the
selection to a Module to process the selection accordingly.

I hope this makes sense?

Cheers,
Steve.

> Hi,
> yes, you can use MouseUp event instead of Shortcut Menu property. first
[quoted text clipped - 20 lines]
> > Cheers,
> > Steve.
Alex Dybenko - 30 Mar 2005 16:56 GMT
Hi,
the idea is the same. just after you get listbox value - then you can hide
some items on same commandbar, using visible property

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Thanks for the reply Alex but what I want to do is change the properties
> of
[quoted text clipped - 58 lines]
>> > Cheers,
>> > Steve.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.