How to?.....

[Igor]

Hi,
I am not sure that this is a forum for my question, but may be somebody
could help me or direct me to the appropriate one.
I want to push button on Access form and to produce document that is text
with embedded fields from database.
It is a big document and I have its template in Word. I don't want to create
report, copy this template, etc.
Can I link somehow this template and feed it by database's data?
Thanks

 

[Dick Kusleika]

Igor

I do this very same thing and it's a real pain. Generally, I use this
technique

http://www.dicks-blog.com/archives/2004/08/13/automating-word/

Although, this example uses Excel, not Access, it was actually inspired by
an Access program I wrote. The Access program is not well documented, but
if you'd like to see it, go here

http://www.dicks-blog.com/excel/AutomateWord.txt

It uses the Tag property of the controls to determine where in Word it
should go and how it should be displayed. It's a semicolon separated list.
A control for the date has a tag like

scContractDay,scContractMonth,scContractYear;Day,Month,Year

where scX is a bookmark in Word.