 |
 | 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 / May 2004merge with Access
after re-installation of office because error in SP3, the error comes. i can see the query result in Access. i can open the query in Word. But there is no record in query result by Word. Everything seems fine. Other queries in Word seems fine. What's wrong. Thanks a lot for your assistance. What is the query? Does it have any wild cards in it, i.e. "*" or "?". If so, try changing them to "%" or "_".  SignaturePeter Jamieson > after re-installation of office because error in SP3, the error comes. > [quoted text clipped - 9 lines] > > Thanks a lot for your assistance. Thanks Peter there is problem with "abc*" but there is no problem with "abcd" Both have result in Access but abc* fail in Word. Is it bug in Word? thx. "Peter Jamieson" <pjj@KillmapSpjjnet.demon.co.uk> ???g???l???s?D :OOWPfv2NEHA.1004@TK2MSFTNGP10.phx.gbl... > What is the query? Does it have any wild cards in it, i.e. "*" or "?". If [quoted text clipped - 16 lines] > > > > Thanks a lot for your assistance. I have been fighting the same problem. The best resolution that I have found is to set the Option "Confirm Conversion at Open" to checked and selecting to use Access with DDE. Word XP defaults to OLE. It is a little slower but does not get fried the way it does with OLE. Thanks a lot Joe "Joe Brazell" <joe.brazell@valero.com> ???g???l???s?D :024BC22C-77AD-4565-8630-4CF17C6D13E2@microsoft.com... > I have been fighting the same problem. The best resolution that I have found is to set the Option "Confirm Conversion at Open" to checked and selecting to use Access with DDE. Word XP defaults to OLE. It is a little slower but does not get fried the way it does with OLE. Apart from the approach Joe Brazell has mentioned, you may find that the query works in Word if you use % instead of *, but not in Access. Having both versions, one for use in Access and one for use from Word, could be a solution. You should also be able to change your database so that it recognises % instead of * by using Access|Tools|Options|Tables/Queries|"SQL Server Compatible Syntax (ANSI 92)"|"This database". However, if you are going to make that change, proceed with caution because it could affect an awful lot of things and involve a lot of work. SignaturePeter Jamieson > Thanks Peter > [quoted text clipped - 25 lines] > > > > > > Thanks a lot for your assistance. I agree with Joe. That's how I solved my problem merging a word source (template) doc with my access database after we converted to XP It also corrected another problem - everytime I merged to a specified Access ID, the query always linked to the first record, not the one specified! . >-----Original Message----- >Apart from the approach Joe Brazell has mentioned, you may find that the [quoted text clipped - 18 lines] >> >> "Peter Jamieson" <pjj@KillmapSpjjnet.demon.co.uk> ¼¶¼g©ó¶l¥ó·s»D >> :OOWPfv2NEHA.1004@TK2MSFTNGP10.phx.gbl... >> > What is the query? Does it have any wild cards in it, i.e. "*" or "?". [quoted text clipped - 19 lines] > >. |
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.