Cut and Paste contents of a field with a Macro

[mcraven]

Is it possible to have a control button that when clicked will cut the contents of a field and append them to another field using a macro? What I have is a current reporting period field that has to be cut and pasted each reporting period into the hisorical field. It's tedious and inefficient for the user.
Please guys - someone out there has to know how to do this!!!!!

 

[ted.martin]

Its all about what goes behind the button. How about setting focus to the initial field and make the value = to a variable. Then next line, set that field = "" and then make the other fieelds (1 by 1) = the the variable. Logical eh?

 

[boblarson]

Its all about what goes behind the button. How about setting focus to the initial field and make the value = to a variable. Then next line, set that field = "" and then make the other fieelds (1 by 1) = the the variable. Logical eh?

Definitely would be simpler than the code to access the clipboard.

 

[Jibbadiah]

Short answer Yes... but I doubt you are doing things correctly if this is what you need. Rather you should be storing the date in a table and referencing the previous date through a query. Likewise if this is referring to an excel spreadsheet you should be working on a function or logic that returns the correct value.

 

[Dreamweaver]

You could do this with a shortcut menu a function that uses the screen active form if ya needed it and field to get the data from.

That's just of the top of my head but it may be possible to be able to complete the whole task of copy past just needs working out.

mick