Form Filter capture in subform

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

Guest

I need to capture the data selected by Access's Filter by form in a subform
and copy it to a word document. Can this be done with code?
 
Yes.
Automation is what you want to research - creating a new Word Doc from
Access VBA.

Then you can use the Clipboard property in VBA to past the records.
 
Mike,

I'm already using automation. Using Automation how would you copy and paste
using code from Access to Word? Again, I'm using a subform for this.

What I'd like to be able to do is use the menu option that Access uses to
create a temporary query from the Save Filter as query option. Is this
possible using code?
 
Back
Top