 |
 | 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 2006ODBC Refresh
Hello, I`m using office 2000 now and we will migrate to office 2003. Now i`m checking the mailmerge connection between word 2k en access 2k and it`s a dde connection. In access 2k3 i would like to use ODBC but the only problem is: When i`m using ODBC and i setup a query in the mailmerge you won`t get any results till you click on the button to go to the next record or the record before this one. So when i have 3 records: Id, Name, Last name 1, John, Jansen 2, Piet, Albertes 3, Bert, Jansen When i`m standing on record 2 and put in the query i only want the Last name Jansen. The record Alberts is shown till you go to antoher record. The query works only when you go to another record. Does anyone has a soulution? Thnx Jos Hi Josvds, > I`m using office 2000 now and we will migrate to office 2003. > Now i`m checking the mailmerge connection between word 2k en access 2k [quoted text clipped - 17 lines] > The query works only when you go to another record. > I'm not sure I'm following... You're using Word 2003 and linking to Access 2003 as the data source, using ODBC. This means you've activated "Confirm conversions on open" and are selecting ODBC, is that correct? And the data source in the Access database, is it a table or a query? In the Word document, you want to merge to only one record, so you "put in the query". Exactly what steps/commands are you using to do this? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Hello, Thnx for your response.. Yes the database is connected to the word page I can see every record. Only when i`m setup a query option he still shows the old query. When i go to the next record from te query it works... But why must i first go to the next record before i see the efect of the query? Is there some solution? Thnx, Jos Cindy M. schreef: > Hi Josvds, > [quoted text clipped - 35 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) Hello, I have seen your website and still not found a solution on this problem. Do you have any idee what this could be? Grts, Jos Cindy M. schreef: > Hi Josvds, > [quoted text clipped - 35 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-)
|
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.