Share via

Paste Append

Anonymous
2015-02-08T13:12:12+00:00

I want to automate the process which would allow a user to copy the content of a field on a form and PasteAppend it another form/table.  I have set up a command button and tried to build a macro but after selecting GoToControl I am unable to find Copy or PasteAppend in the list of actions.

It may of course be better to write some code to achieve this but unfortunately I am not good at writing code.

Would appreciate your help or advice.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-02-12T15:08:34+00:00

    Thank you so much Ken, this is just brilliant and works beautifully.

    I added Me.Refresh after Execute SQL line so if a field is added to the Names table it shows up in the list in the next record - without refresh it did not appear in the list but was accepted without triggering the MsgBox.

    Once again my grateful thanks for your help, I would not have been able to accomplish this without it.

    Was this answer helpful?

    0 comments