Is there a way to use an existing document in Word as a report template that I can add fields from Access to it?
Is there a way to use an existing document in Word as a report template that I can add fields from Access to it?
No you can't add Access controls to a Word document. Nor can you add Word form fields to an Access form or report.
What you can do is populate Word form fields from Access, but I'm pretty sure the only way is via Automation. That may not be for the faint of heart. You could also
a) replicate the document as an Access report and eliminate the .doc
b) export Access data in one of a few formats (such as RTF, pdf, xls and a few others).
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Micron is correct, no can do BUT you can merge with Word. No worries about automation just see Albert Kalllal's Word Main Merge...
http://www.kallal.ca/msaccess/msaccess.html
Thanks. I forgot about that.
That's why there's more than one of us!
That is what I was afraid of. Maybe an option for future. Thank you very much for the additional resources, I will check those out.