Help automating two queries

[Mary]

I have a query that pulls details for a customer activity. When that query
opens, I want to automate the process of copying the Customer_Name column,
close this query, open the second query (it's actually a datasheet form),
paste, the close. The form is already set to display results when it is
closed, I'm just not sure how to automate the copy and paste.

Thanks!
Mary

 

[Mary]

Or just help with using Sendkeys in a macro. I can open the query in a
macro, how do I select an entire column, right-click and copy?

Thanks! Mary

 

[Steve Schapel]

Mary,

Whereas it is technically possible to do what you are asking, it is
probably a bad idea. For one thing, SendKeys is notoriously
troublesome, and experienced Access developers avoid it rigorously. You
can probably achieve your purpose by using an Update Query. If you
could post back with some more details, with examples, of the tables,
queries, and fields concerned, with examples, someone may be able to
offer some more specific help.