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
|
|||
|
|||
Merging from an Access Query
My company has recently moved to word 2002 on XP. When I try and merge a
Query from ACCESS into Word if I have set a crieria on Access, word will no longer allow me to select this query to merge. However if the Query has no criterias set I can merge no problem. I never had this problem pre 2002/XP. What used to happen was that i opened the word document and this automayically opened Access asking me to insert mt criteria and then the mailmerge worked as normal. I desperatly need to keep this function for the job I am doing |
#2
|
|||
|
|||
Merging from an Access Query
Check Word Tools|Options|general confirm conversions at open, then go
through the process of selecting your query as a data source again. You should see a new dialog box that lets you select a "connection method". Choose DDE (which is what older versions of Word used by default - Word 2002/2003 use OLEDB by defualt, and an OLEDB connection can't use Access "parameter" queries). -- Peter Jamieson "Sandra" wrote in message ... My company has recently moved to word 2002 on XP. When I try and merge a Query from ACCESS into Word if I have set a crieria on Access, word will no longer allow me to select this query to merge. However if the Query has no criterias set I can merge no problem. I never had this problem pre 2002/XP. What used to happen was that i opened the word document and this automayically opened Access asking me to insert mt criteria and then the mailmerge worked as normal. I desperatly need to keep this function for the job I am doing |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Access License In Terminal Server | JIM.H. | General Discussion | 9 | July 19th, 2004 12:32 AM |
Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Retrieving Count of rows returned from MS Access Query | Don | General Discussion | 2 | June 27th, 2004 07:54 PM |