[AccessD] Questions on Access 2007 Controlling Word with Windows Automation

Brad Marks BradM at blackforestltd.com
Wed Feb 29 14:07:22 CST 2012


All,

This is our first "adventure" of using Windows Automation with Access
and Word.

Here is what we are trying to accomplish...

We have a purchased application that stores data in SQL Server.  We
cannot change how the data is stored.

There is one memo field in the database that contains a long string of
text.  

We can easily pull this field into a small test Access 2007 application.

We would like to use Windows Automation to control Word from Access and
add formatting such as changing some select words in the memo field to
be Bold on the generated Word document.

Is this possible?

In other words, can we parse through a single field in Access and add
formatting to the generated Word Document.  

An example or a link to an example on the web would be wonderful.

Thanks,
Brad  



More information about the AccessD mailing list