WORD

  • Thread starter Thread starter Pat G
  • Start date Start date
P

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?
 
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
 
Back
Top