Reply
 
Thread Tools Display Modes
  #1   Report Post  
tjmax
 
Posts: n/a
Default Opening a word merged document from Access code doesn't update

I am using a Access list box to selecdt first a group then select a word
merged document. The code is as follows where strDocName is the full path &
name for the Word mail merge document.

Sub OpenWordDoc(strDocName As String)
'Opens word document selected in frmExportInfo
Dim objApp As Object

'Opens the document
Set objApp = CreateObject("Word.Application")
objApp.Visible = True
objApp.Documents.Open strDocName

End Sub

The Word document opens OK but doesn't update to the selected group (which
update a table than the Word merged document is based on). If I open Word
then open the same mail merge document it update correctly. But it first ask
me if I want to run query that links to the updated Access table - I don't
get this message if I when I open this Word doc from Access.
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
hard space between words. Sandy L Microsoft Word Help 7 May 5th 06 08:25 PM
Envelope Address GR New Users 5 April 24th 05 09:48 PM
Locking Two Words Together to Make a Proper Compound Noun in Word WorkingWoman Microsoft Word Help 2 April 7th 05 02:33 PM
1st word in heading flush left second word flush right Elin New Users 9 April 4th 05 08:44 PM
WordPerfect keyboard macro>Word equivalent? Anty New Users 2 March 13th 05 06:23 PM


All times are GMT +1. The time now is 05:35 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"