?
Solved

Opening a Word Document from MS Access 2010

Posted on 2014-09-15
2
Medium Priority
?
1,827 Views
Last Modified: 2014-09-15
I hope someone can help.

I have been using the following code successfully in a database that was written in Access 2003.  When I try to use it in an Access 2010 database I get a Run time Error 424 Object Required on line Set WordDoc.  I have checked references and Access 14.0 Object Library, Word Object Library 14.0 are both set.  Is there a different coding needed for 2010?

   'Open Word Document for Merge
   
   Dim WordApp, WordDoc As Object
   Set WordApp = CreateObject("Word.Application")
   
   Set WordDoc = WordApp.Documents.Open(Forms!HomePage_TaskList!DocumentsFolders & Me.Letters.Column(2))
   WordApp.Visible = True
0
Comment
Question by:PerksP
2 Comments
 
LVL 8

Accepted Solution

by:
Wilder_Admin earned 2000 total points
ID: 40322828
Use that instead:

Private Sub Command30_Click()
Application.FollowHyperlink "T:\G4\Maint\Fac Reports.doc"
End Sub
0
 

Author Comment

by:PerksP
ID: 40322856
Great, that worked.  Many thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question