[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details

Creating Menu's with Macro's and Supressing Pertinent Options in Code

Asked by mlcktmguy in Microsoft Access Database

Tags: Access 2003

My questions has two parts:
1. How to create a menu using macro's.
2. How to dynamically suppress or disable options on that menu using VBA code in the Current Event of a From.

I want to create a menu that will come up when a user right clicks on specific line of a continuous form.  For example purposes say continuous form name is 'frmOrders' and each line on the form contain information pertaining to an order for a client.  The right click menu will be called  'OrderOptions'  (which I would like to build with a macro will have options such as:
View Client Address Record
Send Late Notice
Mark as Paid
Re-Print Original Invoice

I will set up frmOrders' to have 'OrderOptions' specified as the ShortcutMenuBar

Depending on the specific line the user is on, certain options are not pertinent and I don't want the user to see them when the righ click menu comes up.  For example if the order has been paid in full there is no reason for the user to see the options 'Send Late Notice' or 'Mark as Paid'.

I envision code in the in the current event of the form such as the following (Pseudo code):
Private Sub Form_Current()
if me.status=paidinfull
      suppress option 'Send Late Notice' in Menu 'OrderOptions'
      suppress option 'Mark as Paid' in Menu 'OrderOptions'
else
      show option 'Send Late Notice' in Menu 'OrderOptions'
      show option 'Mark as Paid' in Menu 'OrderOptions'
endif
end sub

any suggestions?

[+][-]11/01/09 04:21 AM, ID: 25713475Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/02/09 02:26 PM, ID: 25724454Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/02/09 07:07 PM, ID: 25725773Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 07:04 AM, ID: 25750174Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 08:15 AM, ID: 25750987Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 09:28 AM, ID: 25751787Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 12:35 PM, ID: 25753695Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/09/09 05:33 PM, ID: 25781746Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625