 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2004Merging MS Word document with MS Access 2002 criteria query
I have created a document to pull data from my Access database. If I leave the query in Access as a Select query with no criteria, Word pulls in the data, but if I add a criteria statement to the query, Word cannot locate the query to execute it. I have changed my general option to "confirm conversion on open" to try to use DDE and that changes nothing. HELP!!!!!!!!!!!!!!!!!!!!! What is the criteria that you are using? I use select queries with criteria on a daily basis without problems.  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP >I have created a document to pull data from my Access database. If I leave > the query in Access as a Select query with no criteria, Word pulls in the [quoted text clipped - 4 lines] > on open" to try to use DDE and that changes nothing. > HELP!!!!!!!!!!!!!!!!!!!!! > What is the criteria that you are using? I use select queries with criteria > on a daily basis without problems. > > -- Each offering of a course is called a section, and each section has a unique section number in my database. I want my user(s) to be able to pull the data for just a specific section, so the criteria statement is [type section no] and then the query pulls only the students who took that section. Shawnee > Please respond to the Newsgroup for the benefit of others who may be > interested. Questions sent directly to me will only be answered on a paid [quoted text clipped - 10 lines] > > on open" to try to use DDE and that changes nothing. > > HELP!!!!!!!!!!!!!!!!!!!!! Any ideas yet? I want my users to open Word, open a document, the document as a merge will open my database, the query in my database will ask for the section number as criteria, then forward the pertinent data to the word document. If I leave the criteria statement out of the query, Word and Access merge beautifully. If I put the criteria statement back in the query, the query is no longer visible. I have many documents created prior to Access 2002 that use this process and work fine. > > What is the criteria that you are using? I use select queries with criteria > > on a daily basis without problems. [quoted text clipped - 16 lines] > > > on open" to try to use DDE and that changes nothing. > > > HELP!!!!!!!!!!!!!!!!!!!!! From the Tools menu in Word, select Options and then go to the General tab and check the box against Confirm Conversions at Open and then when you attach the data source, use DDE as the connection method. SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > Any ideas yet? I want my users to open Word, open a document, the > document [quoted text clipped - 36 lines] >> > > on open" to try to use DDE and that changes nothing. >> > > HELP!!!!!!!!!!!!!!!!!!!!! As I exlained in my original post, I have already used this suggestion and it didn't change a thing, other than ask me to select the connection, and when I select DDE Word and Access still won't communicate as long as I have a parameter in the Access query. Shawnee > From the Tools menu in Word, select Options and then go to the General tab > and check the box against Confirm Conversions at Open and then when you [quoted text clipped - 40 lines] > >> > > on open" to try to use DDE and that changes nothing. > >> > > HELP!!!!!!!!!!!!!!!!!!!!! You replied that you use parameter queries every day with no problem--are you using them to populate a Word document? I use parameter queries all the time in my database and the Word documents I created before Office XP that get populated by parameter queries still work even after my XP installation, but any documents created since the XP installation cannot find parameter queries in my database. > From the Tools menu in Word, select Options and then go to the General tab > and check the box against Confirm Conversions at Open and then when you [quoted text clipped - 40 lines] > >> > > on open" to try to use DDE and that changes nothing. > >> > > HELP!!!!!!!!!!!!!!!!!!!!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.