Enabling right click

[livvie]

Unlike everyone else I want to enable right click but ticking the allow Default Shortcuts Menu won't work for me as I am using Access .adp which runs on machines that don't have Access installed (therefore they cannot have shortcut menus). How do I get around this or do I have to find another way to delete records.

 

[ghudson]

Does this command not work in ADP?

DoCmd.RunCommand acCmdDeleteRecord

 

[livvie]

It does I was just hoping to avoid putting in a button as it's not suitable on some of my forms. Think I'll have to go with that.

 

[livvie]

Does this command not work in ADP?

DoCmd.RunCommand acCmdDeleteRecord

ghudson

I am now using this method but how do I deal with it when the user hits No. On a machine where Access is not installed it just crashes. I have tried the following butthis just gives me 2 MsgBoxes the access one and my own. Any ideas ?

Dim Msg, Style, Title, Response
DoCmd.RunCommand acCmdDeleteRecord
Msg = "You are about to delete a line. Do you really want to do this?" ' Define message.
Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons.
Title = "Warning" ' Define title.
' Display message.
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then ' User chose Yes.
Else ' User chose No.
DoCmd.Hourglass False
Exit Sub
End If

 

[livvie]

- I need Access installed to run an .adp. Why do you think that you don't?

I have been using Access .adp and Packages to deploy the app on a PC without Access installed (thus reducing no of licences required) as far as I was aware that was the purpose of them.

 

[livvie]

Access is still installed. It is just the runtime version rather than the full retail version but it is Access never the less. No Access database can run with out either the retail or runtime version of Access installed.

Yes sorry it is Access runtime that is installed with .adp packages. Does this mean that right click etc should work so on these machines.

 

[livvie]

I'm not sure whether the problem is related to using an .adp (I NEVER use them) or the Access runtime (which I have only used once). Are you saying that the option isn't available on a form in an .adp? If so, you'll need to simulate the feature by using the double click event of a control.

Yes right click does not pop a menu like it does when you have full Access. So it is possible to simulate it.