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 07 query and merg to Word 07
I've created a query to using some criteria to filter out some records that i
would like to merg into a document. But when I select that query to merg into a word document, none of the records apear. When I remove all the criteria, the records show up in the merg. Any suggestions? |
#2
|
|||
|
|||
Access 07 query and merg to Word 07
Change the method of connecting to the data source to DDE. To get that
option, in Word, click on the Office button, then click on Word Options and then on Advanced and scroll down to the General section of the dialog and check the box against "Confirm file format conversion at open." Alternatively, with the result of you query displayed in Access, initiate the merge from Access. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Rick" wrote in message ... I've created a query to using some criteria to filter out some records that i would like to merg into a document. But when I select that query to merg into a word document, none of the records apear. When I remove all the criteria, the records show up in the merg. Any suggestions? |
#3
|
|||
|
|||
Access 07 query and merg to Word 07
It makes no sence to me, becasue i have used other queries with criteria to
merg with no problems. I did as u suggested by "confirm file format" but it had no effect. It seem that certin types of criteria are not acceptable to word, like 0 or Like. "Doug Robbins - Word MVP" wrote: Change the method of connecting to the data source to DDE. To get that option, in Word, click on the Office button, then click on Word Options and then on Advanced and scroll down to the General section of the dialog and check the box against "Confirm file format conversion at open." Alternatively, with the result of you query displayed in Access, initiate the merge from Access. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Rick" wrote in message ... I've created a query to using some criteria to filter out some records that i would like to merg into a document. But when I select that query to merg into a word document, none of the records apear. When I remove all the criteria, the records show up in the merg. Any suggestions? |
#4
|
|||
|
|||
Access 07 query and merg to Word 07
Is your database a .accdb format database created in Access 2007 or a .mdb
created in an earlier version? Are you using wilcard characters in your "LIKE" clauses? If so, are you using * and ?, or % and _, and do the quesries work when you use them in Access? Are you definitely selecting the Access via DDE option? In Word 2007, you also have to check "Show all" in the "COnfirm data source dialog" if the database is in accdb format. -- Peter Jamieson http://tips.pjmsn.me.uk "Rick" wrote in message ... It makes no sence to me, becasue i have used other queries with criteria to merg with no problems. I did as u suggested by "confirm file format" but it had no effect. It seem that certin types of criteria are not acceptable to word, like 0 or Like. "Doug Robbins - Word MVP" wrote: Change the method of connecting to the data source to DDE. To get that option, in Word, click on the Office button, then click on Word Options and then on Advanced and scroll down to the General section of the dialog and check the box against "Confirm file format conversion at open." Alternatively, with the result of you query displayed in Access, initiate the merge from Access. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Rick" wrote in message ... I've created a query to using some criteria to filter out some records that i would like to merg into a document. But when I select that query to merg into a word document, none of the records apear. When I remove all the criteria, the records show up in the merg. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|