Results 1 to 3 of 3
  1. #1
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388

    A Macro For VBA Diehards - Creating Shortcut Popup Menus

    RClickMacros-davegri-v02.zip

    I know, I know. "Macros are a waste of time, too limited, too constraining, only for lazy beginners who have not availed themselves of the power of VBA at their self inflicted loss." say the VBA pedantics. "I can't waste my time helping beginners with Macros. I know nothing of Macros. My advice for them is to learn VBA!"


    Well, maybe not always. What if some things are EASIER to accomplish with macros rather than with VBA?




    Shocking? But it's true. You can create right-click popup menus either way, but it's easier and a LOT more intuitive with macros.
    The attached DB has two familiar common forms for keeping track of people data. There are 2 short macros to create the right-click menus. One form uses both popups, and the other just one. Both macros do call simple VBA procedures but others could exist as pure macros. Run the demo and you can see the power of custom popup menus and can quickly imagine ways to improve user interfaces with little additional programming effort.

    Click image for larger version. 

Name:	rc1.png 
Views:	67 
Size:	23.6 KB 
ID:	51515 >?>?>?>?>?>?Click image for larger version. 

Name:	rc5.png 
Views:	61 
Size:	26.7 KB 
ID:	51519

    See the Macro

    Click image for larger version. 

Name:	rc3.png 
Views:	67 
Size:	14.7 KB 
ID:	51517>?>?>?>?>?Click image for larger version. 

Name:	rc4.png 
Views:	67 
Size:	39.1 KB 
ID:	51518
    Last edited by davegri; 02-16-2024 at 08:18 PM. Reason: Replaced v01 with v02. Cosmetic change.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I agree, nicely done.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 07-20-2017, 08:04 AM
  2. Replies: 3
    Last Post: 07-11-2017, 01:02 PM
  3. Another question regarding shortcut menus
    By lawdy in forum Programming
    Replies: 2
    Last Post: 05-27-2014, 04:25 PM
  4. Shortcut menus in A2010
    By John_G in forum Access
    Replies: 1
    Last Post: 12-03-2013, 02:52 PM
  5. Removing Shortcut menus on tables.
    By Desstro in forum Access
    Replies: 4
    Last Post: 11-04-2010, 12:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums