Copy - paste function

[sven2]

Hello,

I try to get the module written by Terry Kreft to implement in access but I can't get it running. I have made a new module but I can't figure out how to put the function behind a button.

Can somebody take a look at the example that I made?

Thanks in advance,
Sven.

 

[Poppa Smurf]

Sven

In your example you are trying to assign data to a command button, it must be assigned to a field.

In your form make the following changes as highlighted

Private Sub Knop3_Click()
'copy the data
ClipBoard_SetText (Tekst0)
End Sub

Private Sub Knop4_Click()
'paste the data
Me!Tekst2 = ClipBoard_GetText
End Sub

In the Knop3_Click() event the data is copied to memory (Clipboard) using the function Clipboard_setText. This function requires a parameter (see module) in this case the data in field Tekst0

In Knop4_Click() event you are copying from memory (Clipboard) to paste into a field, so you must assign a field in this case Tekst2.