Shortcut for "Paste Append" (1 Viewer)

[Andrew Thorpe]

I often use Ctrl+V for Paste. Is there a shortcut for PasteAppend?

 

[NauticalGent]

Doesn't appear to be, I think that is a MS/right click thingy.

Try this:
https://support.microsoft.com/en-us/help/12445/windows-keyboard-shortcuts

 

[Andrew Thorpe]

Thank you for the link - there are certainly lots of useful shortcuts there. For PasteAppend, I have tried using a docmd action as described in another thread. It works fine, but a standard shortcut would have been even better. Thanks again.

 

[missinglinq]

You don't say how you're accomplishing this...with a Command Button, perhaps? You can create your own custom shortcut to do this, using an unassigned combination of keys. To use <Ctrl> + <Z>:

In the Properties Pane, for the Form itself, go to Events and (at the very bottom of the events) and set KeyPreview to YES. Then use this code

Private Sub Form_Keydown(KeyCode As Integer, Shift As Integer)

 If Shift = acCtrlMask And KeyCode = vbKeyZ Then
 
   DoCmd.RunCommand acCmdSelectRecord
   DoCmd.RunCommand acCmdCopy
   DoCmd.GoToRecord , , acNewRec
   DoCmd.RunCommand acCmdPasteAppend

 End If

End Sub

Linq ;0)>

 

[Andrew Thorpe]

Great stuff! That's working very well, thank you. I had previously put code into the On Double-Click event. Thanks again.

 

[missinglinq]

Glad we could help!

Linq ;0)>