G
Guest
HI,
I have a db that I created in Access 2000 on a windows 98 computer. I have
a form with a text box where the user can enter the name of a Word merge file
and a command button that uses the following code to do the merge from an
Access query
Set objWord = GetObject("c:\Mailing List\" & Forms![Transaction Report
Menu]![MergeFile] & ".doc", "Word.Document")
' Make Word visible.
objWord.Application.Visible = True
' Set the mail merge data source as Mailing List.
objWord.MailMerge.OpenDataSource _
Name:="c:\Mailing List\Mailing List.mdb", _
LinkToSource:=True, _
Connection:="QUERY MailMergeRenewal", _
SQLStatement:="SELECT * FROM [MailMergeRenewal]"
The merge works great on my windows 98 computer with Access 2000. When I
place it on a windows xp computer with Access 2002 the Word document comes up
and I get a "Select Table" window and there is no way to enter my query name.
I feel that I'm missing a library. In looking at the references the 2003
version has "Word 11.0 Object Library" where the 2000 verson has "Word 9.0
object Library". Also there was another difference in the libraries but I
didn't write it down and the xt computer is 26 miles away (sorry).
I did discover that when I open the form (on the xp computer) that has the
text box and command button that if I go to design view and then back to view
view the merge works fine. It's like some link needs to be set up and going
to design view and back makess the link. Strange....
Another strange thing.. On the 98 computer the merge document comes right
up. On the xp computer the bar just above the task bar displays "Waiting for
Microsoft Access to accept DDE Commands" for a bit and then displays
"Iniating DDE Link with Microsoft Access" While these messages are display
it takes about 10-15 seconds for before they go away and the "merge" icon in
the Word document to become active.
Any Ideas. It works great on the Win 98 with 2000......
I have a db that I created in Access 2000 on a windows 98 computer. I have
a form with a text box where the user can enter the name of a Word merge file
and a command button that uses the following code to do the merge from an
Access query
Set objWord = GetObject("c:\Mailing List\" & Forms![Transaction Report
Menu]![MergeFile] & ".doc", "Word.Document")
' Make Word visible.
objWord.Application.Visible = True
' Set the mail merge data source as Mailing List.
objWord.MailMerge.OpenDataSource _
Name:="c:\Mailing List\Mailing List.mdb", _
LinkToSource:=True, _
Connection:="QUERY MailMergeRenewal", _
SQLStatement:="SELECT * FROM [MailMergeRenewal]"
The merge works great on my windows 98 computer with Access 2000. When I
place it on a windows xp computer with Access 2002 the Word document comes up
and I get a "Select Table" window and there is no way to enter my query name.
I feel that I'm missing a library. In looking at the references the 2003
version has "Word 11.0 Object Library" where the 2000 verson has "Word 9.0
object Library". Also there was another difference in the libraries but I
didn't write it down and the xt computer is 26 miles away (sorry).
I did discover that when I open the form (on the xp computer) that has the
text box and command button that if I go to design view and then back to view
view the merge works fine. It's like some link needs to be set up and going
to design view and back makess the link. Strange....
Another strange thing.. On the 98 computer the merge document comes right
up. On the xp computer the bar just above the task bar displays "Waiting for
Microsoft Access to accept DDE Commands" for a bit and then displays
"Iniating DDE Link with Microsoft Access" While these messages are display
it takes about 10-15 seconds for before they go away and the "merge" icon in
the Word document to become active.
Any Ideas. It works great on the Win 98 with 2000......