• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 662
  • Last Modified:

Custom Popup Menu in Access

I have a form with two list boxes. One box lists positions (bartender, floor, bus, door, etc.) and the other lists employees. Right now I click the positions box and then the employee box and it puts that employee in the selected position. What I want to develop is a popup menu that appears when I right click a record in the employee's box that contains the "positions". When a position is selected I want the code to run that executes the update query. Any help is greatly appreciated.
0
EMCIT
Asked:
EMCIT
  • 3
  • 2
1 Solution
 
nathana21Commented:
Yes, see the custom popup menu section on this page..http://www.jamiessoftware.tk/articles/menubars.html
0
 
EMCITAuthor Commented:
I Googled this page earlier. It doesn't address what I want. I can get it to execute a macro or load a form, table, query, report, etc. but I need the popup to display a list of positions that, when clicked, runs the update query.
0
 
wiswalldCommented:
Tools-Customize

Create a menu using macros to perform the designated task. Go to properties and allow shortcut menu and set to the menu you created.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
EMCITAuthor Commented:
<<Create a menu using macros to perform the designated task>>
How will this create a list of positions that will appear in the popup?
0
 
wiswalldCommented:
What exactly do you want to do? Sorry for the earlier comment. You need to create a module and base the macro on that.
0
 
EMCITAuthor Commented:
I have two tables. Employees and Positions. Right now I have each table populating a list box so that I click a position in box one and then click an employee in box two and it assigns that employee to that position through an update query. I want to skip the first box. When you right-click a name in the employees box I want a popup menu that contains the list of positions. When you left click a position it stores the position and fires the update query. Same results, different process. I can create a popup that will open a form or report or table, query, etc. but I can't get the positions list to populate the popup.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now