 |
 | 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 / April 2004ODBC Access-DB connection save-problem with the last DB-record
I have a mailmerge with fields from an ODBC Access-DB and Word. The DB has now more then 500 record. When I save the word-Document with the last record, the connection with the last record will not show again, when I open the Word-Document again, but it is connected with the record number 1. All is allright, if it is not the last record but the record before, the Word-Dokument opens after saving correctly with the connected record number before. This wrong behavior was first appearing, after the DB has more than 500 records. Is there a bug in Word when mailmerging with an ODBC-DB, that has more than 500 records? Hi Helga, Which versions of Word and Access are involved, here? > I have a mailmerge with fields from an ODBC Access-DB and Word. > The DB has now more then 500 record. [quoted text clipped - 10 lines] > Is there a bug in Word when mailmerging with an ODBC-DB, that has more > than 500 records? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) 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 :-) Access and Word version 2002 with SP-2 under Windows XP Home Edition Hi Helga, I've never heard of this problem, that I can recall. I'm trying to find something out, but even if I get a confirmation that it is a problem, I doubt it will get fixed for Word 2002. Best I can suggest, given that you know of a way to get around it, would be to use a macro that fires when the document is closed that will reset the active record. This might work Sub AutoClose 'Below should all be on one line, except "End Sub" ActiveDocument.MailMerge.DataSource.ActiveRecord = wdPreviousRecord End Sub > Access and Word version 2002 with SP-2 under Windows XP Home Edition > [quoted text clipped - 12 lines] > Is there a bug in Word when mailmerging with an ODBC-DB, that has more > than 500 records? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) 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 :-)
|
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.