 |
 | 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 / December 2005updating source data
Good day All, Does anyone know how to update the data in a (.mdb) data-source from a Word document - it seems most of the properties are read-only? I would like to have a Word document with named fields that users type data, then, with a button/code update the data-source. MS Access will probably not be available. thanks. Hi =?Utf-8?B?TkpT?=, > Does anyone know how to update the data in a (.mdb) data-source from a Word > document - it seems most of the properties are read-only? I would like to > have a Word document with named fields that users type data, then, with a > button/code update the data-source. MS Access will probably not be available. there is absolutely nothing at all in Word that supports this. Excel, yes. But in Word you'd have to program every scrap of it. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 :-) Thanks Cindy, I realize this. Maybe my question should read 'which object model is used to program the source data'? (Because the Word/Mailmerge model does not have an 'update -data' method?) If it is mdb, can one assume a partial Access object library? > Hi =?Utf-8?B?TkpT?=, > [quoted text clipped - 13 lines] > This reply is posted in the Newsgroup; please post any follow question or reply > in the newsgroup and not by e-mail :-) Hi =?Utf-8?B?TkpT?=, > Maybe my question should read 'which object model is used to program the > source data'? (Because the Word/Mailmerge model does not have an 'update > -data' method?) > If it is mdb, can one assume a partial Access object library? Record a macro while connecting to a data source and you'll see how the object model handles it. It uses a technology (DDE, ODBC or OLEDB) to connect to the data and pull it in. There's nothing, really, you can hook into. Word doesn't care what database program is at the other end. If you're asking what data source Word mail merge creates when you ask it to create one for you, that depends on the version of Word. In Word 2002/2003 by default it's a *.mdb (Access database). Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 :-) Thanks Cindy, I was wasting too much time trying to determine what Access objects were available on a machine with no Access, so I have solved the problem by using a Word merge source and addressing the columns in the second row. > Hi =?Utf-8?B?TkpT?=, > [quoted text clipped - 19 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.