No right-click on datasheets in run-time?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, I'm stumped. Here' this nice little form with a subform that displays
only the datasheet. When I open the application in Access, I have right-click
functions for the columns in the datasheet. When I open the form in run-time,
right-clicking a column has no effect at all. What gives? And is there a
workaround?

Thanks very much.
 
Reliza said:
Okay, I'm stumped. Here' this nice little form with a subform that
displays only the datasheet. When I open the application in Access, I
have right-click functions for the columns in the datasheet. When I
open the form in run-time, right-clicking a column has no effect at
all. What gives? And is there a workaround?

Thanks very much.
Click to expand...

If by "open the form in run-time..." you mean with the Access runtime or
simulating same with the /runtime command line argument then what gives is that
no built in menu or toolbars are supported in the runtime (including righ-click
menus). You have to provide all of your own.

If you creat your own shortcut menu and assign it to that form then it will work
in the runtime.
 
Sorry. By "open in run-time" I mean open without holding down the shift key.

We have a custom menu for the application, but I'm not sure where to find
the command for allowing right-click functions for the datasheet. The
Shortcut Menu property is set to Yes for both the form and the subform.
 
Reliza said:
Sorry. By "open in run-time" I mean open without holding down the
shift key.

We have a custom menu for the application, but I'm not sure where to
find the command for allowing right-click functions for the
datasheet. The Shortcut Menu property is set to Yes for both the form
and the subform.
Click to expand...

You set the "Shortcut Menu Bar" property of the form on the {other} tab to the
name of your custom shortcut menu. If you haven't created a custom shortcut
menu then the normal built in shortcut menu should be available on all forms
where the ShortcutMenu is set to Yes (again providing you are using full Access
and not the Runtime).
 
To the OP, try this:
- Be sure Tools>Startup> "Allow Default Shortcuts" is *checked*. Then
open the app again.
- If that doesn't work search your startup code to see if
"AllowShortcutMenus = True" (or = anything other than zero) appears.
Comment it out. Save. Close & reopen.
If you haven't created a custom shortcut menu then the normal built in
shortcut menu should be available on all forms where the ShortcutMenu is
set to Yes (again providing you are using full Access and not the
Runtime).
Click to expand...

Unless Tools>Startup>"Allow Default Shortcuts" has been unchecked (or there
is startup code that has the same effect).
(The OP says that when he opens the file without holding down Shift, that he
*does* have shortcuts, so *something* is going on during startup).

Per Help for ShortcutMenuBar: "Shortcut menus aren't available to any object
if the AllowShortcutMenus property is set to False". Although the entry
*should* specify "built-in shortcut menus", (since AllowShortcutMenus
doesn't effect Custom menus), it does sound like this may be the problem.

HTH,
 
Back
Top