Not shure which query have to use

[ANSWER]

Hi,

I want to make, or is is possible to make database with function to update
words in saved document.
For example, in my database I enter word in German and English, and when
when I press update I want to German word replace English word in Selected
document (.doc, .html):
| No | German word | English word |
| 1. | Wagen | Car |
| 2. | Volks | Folks |

......

If this is possible please tell me how should I do this.
Thanks

 

[Joseph Meehan]

Hi,

I want to make, or is is possible to make database with function to
update words in saved document.
For example, in my database I enter word in German and English, and
when when I press update I want to German word replace English word
in Selected document (.doc, .html):
| No | German word | English word |
| 1. | Wagen | Car |
| 2. | Volks | Folks |

.....

If this is possible please tell me how should I do this.
Thanks

You could use the access database as the source for a mail merge. You
could have a table with two fields, one English and one German. Then you
would only need to chose which record you wanted to merge, or you could
merge both and just print one.

 

[John Vinson]

I want to make, or is is possible to make database with function to update
words in saved document.

You cannot do this in a Query. You'll need some rather complicated VBA
code to open the Word document using automation, and use Word macros
to find and replace the text.

John W. Vinson[MVP]