Macro SendKeys

[Guest]

I´m trying to do a macro for copy and paste based on query. I should copy a
value from a form field and paste in to a table field by using SenKeys
commands ^C and ^V. Everything else works (query, opening the form and the
table) but copy and paste does not. How can I do this, or is that possible at
all?

 

[Steve Schapel]

Mark,

SendKeys is not a recommended approach. And in any case, copy/paste is
not an appropriate way to manage data in a database.

One approach would be to use an append query or an update query
(depending on whether you are writing the data to a new or existing
record in the table.

The other approach would be to bind the from control to the table field.

Without knowing more details about what you are doing and what you are
trying to achieve, I can't comment for sure, but... your very need to do
this type of operation in the first place is indicative of an incorrect
database design, in that it sounds like the result of this will be to
store the same data in more than one place, which is against database
design principles.