If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Access 2007/Word 2007 Mail Merge Opens Second Instance
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 |
#3
|
|||
|
|||
Access 2007/Word 2007 Mail Merge Opens Second Instance
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! |
#4
|
|||
|
|||
Access 2007/Word 2007 Mail Merge Opens Second Instance
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 |
#5
|
|||
|
|||
Access 2007/Word 2007 Mail Merge Opens Second Instance
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. |
Thread Tools | |
Display Modes | |
|
|