🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: comp.databases.ms-access
2 messages
2 total messages Started by Ant�nio Ferreira Thu, 09 Jul 1998 00:00
Word Automation from Access 2.0... HELP!!!!
#28
Author: 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
Re: Word Automation from Access 2.0... HELP!!!!
#33
Author: aa_1_2_3
Date: Sat, 11 Jul 1998 00:00
12 lines
1304 bytes
If you use mail merge wizard u should have no problems,bat there are some
other ways to do that

I: DDE
II: write to a text file your data
     open word basic it and putr in propewr places the fields

I've tried to do that using wizard - it works OK
I dont know why can't you

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads