Form Filter capture in subform

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?
 
M

Mike

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.
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to capture the Filter By Form? 2
Pass Subform filter to subform in report 0
Filtering subforms via main form 2
Refreshing a subform 2
Capture Data Change in Subform Using a table as SourceObject 2
Filter main form to records with no related records in subform,maintain updateable recordset 4
Selecting current record in subform after removing filter 1
Controlling subform record source 6

Top