Populating Word table with results of Access query

  • Thread starter Thread starter zenonk
  • Start date Start date
Z

zenonk

I am attempting to automate a process here and am having difficulty
figuring out how to do it. I have an Access database which produces a
report based on a query. Currently, people are printing this report,
then re-typing the info into a table in a Word document. Needless to
say, this is time consuming, error prone, and plain old silly. I need
automate this process. Is there any way that I can code a button to
run the query, open a Word document, create and populate a table in it?
I have figured out how to create a Word document and how to output the
query results to a csv file because I thought this intermediate step
might be necessary (though it probably isn't) but am now stuck. Any
ideas?

thanks
 
I am attempting to automate a process here and am having difficulty
figuring out how to do it. I have an Access database which produces a
report based on a query. Currently, people are printing this report,
then re-typing the info into a table in a Word document. Needless to
say, this is time consuming, error prone, and plain old silly. I need
automate this process. Is there any way that I can code a button to
run the query, open a Word document, create and populate a table in
it? I have figured out how to create a Word document and how to
output the query results to a csv file because I thought this
intermediate step might be necessary (though it probably isn't) but
am now stuck. Any ideas?

thanks

Here is a method I'm using for several reports and forms in an application
on a current record from a form. There are several other ways to do it but
this worked well for me.

http://support.microsoft.com/?kbid=210271
 
Back
Top