0

Hello, I'm writing a thesis and in order to interrogate the text have written a small programme in vba which allows me to run from a form boolean searches on the chapters which I've entered in an underlying table. The results are pasted to another table and can be viewed and edited in a subsidiary form, the edits then being written back to the original parent table. Unfortunately, it's also sometimes convenient to edit and work on the original word documents upon which each record is based. I'm new to programming and wondered whether there was a relatively simple way of synchronizing the document with its record and vice versa?

Many thanks for any help.

Plec

2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by AndreRet
0

I would suggest that you use the InStr function every time that you change anything to the Word document. This will compare text from the document to text in the database and you can then add code to change the database accordingly.

Just google InStr, plenty of tutorials and code samples. Use InStr in VBA to narrow your search.

Let us know if you found what you were looking for.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.