🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #28

Word Automation from Access 2.0... HELP!!!!

#28
From: Ant�nio Ferreira
Date: Thu, 09 Jul 1998 00:00
41 lines
2575 bytes
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
Technical Details
Message-ID: <35a51ee1.5391463@news.telepac.pt>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 101bdd,a037d49c859bdcd0,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: ff0ac,a037d49c859bdcd0,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f962e,a037d49c859bdcd0,start
X-Google-Attributes: gidf962e,public
X-Google-Thread: 10644a,a037d49c859bdcd0,start
X-Google-Attributes: gid10644a,public
X-Google-Thread: 1668c5,a037d49c859bdcd0,start
X-Google-Attributes: gid1668c5,public
X-Google-Thread: fe218,a037d49c859bdcd0,start
X-Google-Attributes: gidfe218,public
X-Google-Thread: fedcf,a037d49c859bdcd0,start
X-Google-Attributes: gidfedcf,public
From: amjferreira@mail.telepac.pt (Ant�nio Ferreira)
Subject: Word Automation from Access 2.0... HELP!!!!
Date: 1998/07/09
Message-ID: <35a51ee1.5391463@news.telepac.pt>
X-Deja-AN: 369969636
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=ISO-8859-1
Mime-Version: 1.0
Newsgroups: comp.databases.ms-access,at.fido.msaccess,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.vb.ole,microsoft.public.vb.ole.automation,microsoft.public.word.oleinterop,microsoft.public.word.OLEinterop