Launch a Word document from Access 2003

Launch a Word document from Access 2003

Post by RGF2ZU » Sat, 30 Apr 2005 00:20:03

I'm converting an Access 2000 application to Access 2003. The application
uses the 'CreateOject' method to create a reference to MS Word and then opens
a document in Word prefilling a template with name and address information
stored in the Access database. This method works properly in Access 2000.
However, when I try to execute the same procedure in Access 2003 I receive
the message 'Requested object is not available'. Why am I getting this
message and how do I correct it?

Launch a Word document from Access 2003

Post by Albert D. » Sat, 30 Apr 2005 16:52:41

Hum, hard to tell. It is possible that some security issue here...

I would try to make the word merge manually at first..and see if any new
dialog prompts pop up.

I have a working same that does a mail merge, and it does work for a2003.
You can give it a try..and at least you will it is "possible" that your new
setup can work. And, you might even enjoy my template word merge sample. You
can find it here:

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada


Launch a Word document from Access 2003

Post by RGF2ZU » Sat, 16 Jul 2005 03:07:08

I've tried your method and modules within my application but can't seem to get
past the Word Merge Template dialog box referencing the query where my data
is located. I added the query name following the call to "MergeSingleWord"
but it's not picking up this query.

The form that I placed the button on to execute the procedure is a tabbed
form that gets its data from one of my primary tables. How do I get the
template to recognize the query as its data source?