How to "Paste Append" by Default?

[DeMarcus]

Here's the situation.

For data entry purposes, instead of typing out every single record, the user wants to copy and paste from Excel.

This is, of course, possible by copying from Excel and using Paste Append in Access.

HOWEVER, the average user will not know what Paste Append is and will have a hard time figuring out how to copy and paste from Excel. So how do I set my form, which is in datasheet view, to have it Paste Append by default?

The problem is compounded that Paste Append does not show up when you right click, and it is something you have to pick from the Edit menu at the top.

 

[DeMarcus]

As for temporary solution:

Instruct user to either:

1) Drag it into Access from Excel.
2) Pick Paste Append from the Edit menu.


Just looking for ways to make it more user friendly is all.

 

[boblarson]

Put a button on your form and set the event code to be:

docmd.RunCommand acCmdPasteAppend

 

[DeMarcus]

Put a button on your form and set the event code to be:

docmd.RunCommand acCmdPasteAppend

Thanks for the tip. However, as far as I know, you can't put controls onto a form that opens up in datasheet view.

I was wondering if there's a way to hijack Ctrl-V and make it paste append?