Access 2007/Word 2007 Mail Merge Opens Second Instance

I have an Access 2007 database where I can launch a Word 2007 merge
document whose data source is a query that looks back to a control on
the form for a parameter.

I am forced to use DDE to link the document to the query, but Word
then opens a second copy of the database (without the form showing)
and is prompting for the value of the control.

I have no database title specified.

What's more confusing is that this problem only occurs on users'
machines, not mine. All machines are Windows XP SP3.

I've been Googling now for about 8 hours with no success (only hits
tell me to remove the custom title from the database or use ODBC which
dosen't see the parameterized query).

AAAARRRRGGGHHHH!

btibbet wrote:
I have an Access 2007 database where I can launch a Word 2007 merge
document whose data source is a query that looks back to a control on
the form for a parameter.

I am forced to use DDE to link the document to the query, but Word
then opens a second copy of the database (without the form showing)
and is prompting for the value of the control.

I have no database title specified.

What's more confusing is that this problem only occurs on users'
machines, not mine. All machines are Windows XP SP3.

I've been Googling now for about 8 hours with no success (only hits
tell me to remove the custom title from the database or use ODBC which
dosen't see the parameterized query).

AAAARRRRGGGHHHH!

Just wondering, but what if you use Albert's Super Easy Word Merge code?
http://www.members.shaw.ca/AlbertKal.../msaccess.html

--
Message posted via http://www.accessmonster.com

Use spy++ to check the window title:
http://msdn.microsoft.com/en-us/libr...96(VS.60).aspx

Use DDESPY to check the DDE traffic.
If you don't have another version, use the Open Watcom
version:
http://www.openwatcom.org/index.php/Download

(david)


"btibbet" wrote in message
...
I have an Access 2007 database where I can launch a Word 2007 merge
document whose data source is a query that looks back to a control on
the form for a parameter.

I am forced to use DDE to link the document to the query, but Word
then opens a second copy of the database (without the form showing)
and is prompting for the value of the control.

I have no database title specified.

What's more confusing is that this problem only occurs on users'
machines, not mine. All machines are Windows XP SP3.

I've been Googling now for about 8 hours with no success (only hits
tell me to remove the custom title from the database or use ODBC which
dosen't see the parameterized query).

AAAARRRRGGGHHHH!

A demo of various Access to Word automation operations, including mail
merging, is at:

http://community.netscape.com/n/pfx/...g=ws-msdevapps


It's always worked fine for me in all versions up to Access 2007, and I've
had no feed-back from others to the contrary. The query in it also
references a form's control as a parameter, but the merge actually uses a
text file as its source document. This is created from the query at runtime.


Ken Sheridan
Stafford, England

btibbet wrote:
I have an Access 2007 database where I can launch a Word 2007 merge
document whose data source is a query that looks back to a control on
the form for a parameter.

I am forced to use DDE to link the document to the query, but Word
then opens a second copy of the database (without the form showing)
and is prompting for the value of the control.

I have no database title specified.

What's more confusing is that this problem only occurs on users'
machines, not mine. All machines are Windows XP SP3.

I've been Googling now for about 8 hours with no success (only hits
tell me to remove the custom title from the database or use ODBC which
dosen't see the parameterized query).

AAAARRRRGGGHHHH!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/201005/1

On May 26, 2:24*pm, btibbet wrote:
I have an Access 2007 database where I can launch a Word 2007 merge
document whose data source is a query that looks back to a control on
the form for a parameter.

I am forced to use DDE to link the document to the query, but Word
then opens a second copy of the database (without the form showing)
and is prompting for the value of the control.

I have no database title specified.

What's more confusing is that this problem only occurs on users'
machines, not mine. *All machines are Windows XP SP3.

I've been Googling now for about 8 hours with no success (only hits
tell me to remove the custom title from the database or use ODBC which
dosen't see the parameterized query).

AAAARRRRGGGHHHH!

Upon further review, and a sleepless night, I figured out what's
happening...If you map to the data source using an absolute path, but
open the database using a relative path, DDE doesn't resolve the
absolute path so it opens up another instance of the database.

Thanks to all of you for your suggestions.