Article View: comp.databases.ms-access
Article #31Re: Word Automation from Access 2.0... HELP!!!!
From: bgubrud
Date: Fri, 10 Jul 1998 00:00
Date: Fri, 10 Jul 1998 00:00
61 lines
3235 bytes
3235 bytes
Hi Antonio, I've accomplished something similiar by writing the data to a text file. I then wrote an AutoOpen macro in Word that read the text file and put the data in the desired places in the Word document. The Word macro had logic that deleted the text file after it had applied the data. It only attempts to apply the data if the text file was found. (This is so it doesn't reapply the same data everytime the document opens). I realize this isn't an elegant solution, or a correct one, but it works. In the absence of better advice, it might be an interim solution to help you meet your deadline. Good Luck Bart In article <35a623ab.6618279@news.telepac.pt>, amjferreira@mail.telepac.pt (Ant�nio Ferreira) wrote: > Hi, > > What I want to do is: > > From Access 2 call winword 6, open a pre-defined document and > write the contents of a table in that same document. > Each Field of the Table must be placed in a precise location of the > document, for this I Defined Several bookmarks!!! > > or > > From Access 2 call winword 6, open a pre-defined document and > make word merge the data from the Record that is selected in the Table > of Access! > > Ex: Access-> Table Clients > 1 | Antonio Ferreira | Portugal > +------> 2 | John Peter | England > | 3 | Mario Andretti | Italy > | > When I Press a Button that is placed somewhere in the form > I want to call word, open the document and merge the data from > this record directly to the Word Document, Print That Page, > and return the control to the Access's form! > > Is it possible?! > The best I done was call winword6, and open the document!! > When I Try to goto a determined bookmark Access gives the > following message "invalid bookmark name", since I Couldn't do > these I try to Call the "Merge Data" that would show the record!! > I failed also!!! :( > > I must deliver a solution to this problem until Saturday, so please If > you know how to make such a thing, please tell me, by follow-up the > solution to this newsgroup or to my E-Mail Adress: > "amjferreira@mail.telepac.pt" > > Thanks for any answer to this problem, > > Best Regards, > Ant�nio Ferreira > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Technical Details
Message-ID:
<6o5bm2$bvt$1@nnrp1.dejanews.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35a623ab.6618279@news.telepac.pt>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 101bdd,a037d49c859bdcd0 X-Google-Attributes: gid101bdd,public X-Google-Thread: 1668c5,a037d49c859bdcd0 X-Google-Attributes: gid1668c5,public X-Google-Thread: fe218,a037d49c859bdcd0 X-Google-Attributes: gidfe218,public X-Google-Thread: ff0ac,a037d49c859bdcd0 X-Google-Attributes: gidff0ac,public From: bgubrud@my-dejanews.com Subject: Re: Word Automation from Access 2.0... HELP!!!! Date: 1998/07/10 Message-ID: <6o5bm2$bvt$1@nnrp1.dejanews.com> X-Deja-AN: 370204216 References: <35a623ab.6618279@news.telepac.pt> Organization: Deja News - The Leader in Internet Discussion X-Article-Creation-Date: Fri Jul 10 15:23:46 1998 GMT Newsgroups: comp.databases.ms-access,at.fido.msaccess,microsoft.public.access.forms,microsoft.public.access.formscoding X-Http-User-Agent: Mozilla/4.05 [en] (WinNT; I ;Nav)