Macro for a Paste Append Command Button: Paste Append Option Disabled for Recording

[tatihulot]

Hello, I’d like to create a button on my form that enables the Paste Append option. I’m having difficulty doing this. I know how to create command buttons, but I’m not quite sure how to build the macro to perform this specific function.


I don’t see anything at all for Paste in the Action Catalog. Am I missing it?
Furthermore, when I’m in the Macro Builder, if I click the Home tab and then Paste, the Paste Append option is not available.
Is it possible to create a macro if this option is grayed out? What steps would be the most efficient to create such a command button?
Thank you.

[Welshgasman]

Very few people use macros.
Best start learning VBA. Dead easy then.

Alternatively try Google?

You could also set a Tempvar and then see if you can append that value to whatever control you are trying for.

Edit:
There are also is as below, but I would still use VBA.

[Micron]

By default the entire action list is filtered somehow. There is an option on the macro tab of the ribbon to show all. Have you selected that?
I agree with wgm about macros. They have their limitations.

[tatihulot]

Thank you for the responses.

[mosinjack]

If the "Paste Append" option is grayed out, it usually means there's no compatible data on the clipboard or the form isn't in a state where appending is possible. You might need to ensure the clipboard contains valid records that match the form’s data source. Unfortunately, Access macros don’t include a direct "Paste Append" action—you may need to use VBA with DoCmd.RunCommand acCmdPasteAppend instead. That gives more control and works reliably when the conditions are right.