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