Help automating two queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top