Right Click Menu

[sstreet]

Right Click Menu (RESLOVED)

Does anyone know how to create a right-click menu in access 2002. In VB you can trap the right click like this:

Private Sub lstdocs_MouseUp(Button As Integer, Shift As Integer,
 X As Single, Y As Single)
If Button = vbRightButton Then
'Code for Menu
End If

Any Ideas?

Steve

 

[ghudson]

Does anyone know how to create a right-click menu in access 2002. In VB you can trap the right click like this:

Private Sub lstdocs_MouseUp(Button As Integer, Shift As Integer,
 X As Single, Y As Single)
If Button = vbRightButton Then
'Code for Menu
End If

Any Ideas?

Steve

Are you sure you want your users right clicking in your db? Most programmers disable that option for that allows the users to do things we do not want.

 

[Rich]

You can of course create your own ShortCut menu

 

[sstreet]

Right Click (RESOLVED)

Thanks, I have sorted the problem now by creating a shortcut menubar and using macros for the commands.

 

[Rich]

I wouldn't use Macros though, there's no error handling

 

[sstreet]

All the macros are doing is calling a Function in a module, which does have error checking.

 

[Rich]

Then just replace the redundant Macros with = FunctionName()