I am at the moment working on a database application for my own use. I have a word template used to compile Engineering technical reports with header data including title, date, reference number etc, followed by the main body. The header data is text information that can be easily stored and maintained in an access table and I am using some code to transfer this header data to my Word Template header which works fine, no problem there.
The main body of the template report will include edited pictures showing various things like graphs, edited images and other technical information. The compilation of the main body of the report cannot be done in an access database and has to be done using MS.Word.
Once the whole report is complete on the word application I would like to save the word template automatically, by clicking the save button for instance to an attachment field in a table called "CompleteReports" but unfortunately I cannot achieve this.
I was thinking to approach the problem as follows:
As soon as the Word Document containing the header information is generated this is saved automatically in the "Completereports" attachment field table. Then I would re-open this Word Document form the attachment table in order to continue with the work on the report so when I click save, the word document is saved in the attachment field directly.
Any ideas and VBA code samples how to do this would be greatly appreciated.