Right-Click Access Runtime

[nkuebelbeck]

Hello,



I just noticed that Access runtime does not let users right click on highlighted text to copy/paste. Is there a way to enable this?

[NoellaG]

Hi,

a lot of functionalities of Access are not available in the runtime. You can program these in your application (use VBA) before converting it to a runtime app.

grNG

[Helen]

It's a pain in the neck, but the way I got around it was to create macros, one each for Date, Numbers, Text, and CheckBoxes, and in the properties sections under Other for Shortcut Menu Bar, type the name of the Macro - the drop list does NOT have the names of your macros ready to choose from.

For Dates, I have

ShortCutDateCommandsM, which has the commands.

Mine looks like this(the & goes before the letter you want the underline for)

Submacro: &Sort Oldest to Newest
   RunMenuCommand
      Command SortAscending
   End Submacro

Submacro: S&ort Newest to Oldest
   RunMenuCommand
      Command SortDescending
   End Submacro

Submacro: &Equals Current Value
   RunMenuCommand
      Command FilterBySelection
   End Submacro

Submacro: Does &Not Equal Current Value
   RunMenuCommand
      Command FilterExcludingSelection
   End Submacro

Submacro: Remove &Filter/Sort
   RunMenuCommand
      Command RemoveFilterSort
   End Submacro

Submacro: &Refresh Record
   RefreshRecord
   End Submacro

Submacro: Sa&ve Record
   RunMenuCommand
      Command SaveRecord
   End Submacro

Submacro: &Delete Record
   RunMenuCommand
      Command DeleteRecord
   End Submacro

The name of the macro that gets typed in the properties section is
ShortCutDateM, and looks like this:

AddMenu
   Menu Name ShortCutDateM
   Menu Macro Name ShortCutDateCommandsM
   Status Bar Text (I left this blank)

I could NOT see cut, copy, or paste in the available options, but I addressed that by changing my Quick Access Toolbar and added lots of things in there, and they WERE retained in the Runtime installed version - whew!
ALSO, the full filter/sort options are available in the Quick Access Toolbar too - it's the little funnel with = next to it. Click on it, then it opens into the full filter/sort options.

I made similar macros for the various data types, and had to add the appropriate macro name to every field, on every form. A total PAIN, and now I have to keep separate versions of my program - one with the macros, one without for me to use in Access. Any changes to the master, I then change on the "runtime version" and have to remake the installable version.

It seems an obvious thing to make available, just like the record filter/sort menus.

Hope this helps.