WORD

[Pat G]

I have a query that uses a control on a form as one of
its criteria.

This seems to cause problems when I attempt to import the
values from the query into Word. I realize the form needs
to be open and the control has to have a value in it.

Whats the right approach to do this?

 

[John Nurick]

Hi Pat,

I'd do this by using VBA to automate Word from Access (or possibly by
automating Access from Word). The eneral idea is to start up an instance
of Word, create a new document from the appropriate template, and do the
mailmerge (or put the information in the document some other way). These
articles show the general idea:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209976
http://support.microsoft.com/default.aspx?scid=kb;en-us;159328
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;209882
http://support.microsoft.com/default.aspx?scid=kb;en-us;170988

And of course there's the Word FAQ at http://www.mvps.org/word

ACC: Sending the Current Record to Word 97 with Automation (Q131583)
http://support.microsoft.com/?id=131583

Using Microsoft Access as an Automation Server
http://support.microsoft.com/?id=147816
http://support.microsoft.com/?id=210111 (Access 2000 and later)

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

http://www.mvps.org/access/modules/mdl0043.htm
Opening a new Word document based on a template through Automation

There's a white paper and code samples including tutorials available
from Microsoft at
http://support.microsoft.com/?id=253235



Also, search www.mvps.org/access