I have a State goverment defined Word document with LOTS of form
fields, spanning 26 pages. Probably 1000 fields as a good guess. The
data is in an Access database in 12 different tables, each table
corresponding to one or m ore pages.
I have completed the load of data via DAO into the first page, about
50 fields. It seems rather slow.
I am already aware of the benefits of not
having the document visible when doing such updates and only make it
visible once the updates are complete.
My code tends to follow this format for assignments into the form
fields:
If inrec.Fields(“1LocAccessHome”) Then ActiveDocument.FormFields
(“LocAccessHome”).CheckBox.Value = True
ActiveDocument.FormFields(“mentaltexta”).Result = inrec.Fields
(“1mentaltexta”)
Everything seems to work it is just a lot of assignments and in tests
seems to take several seconds for this one page. Some of the later
pages are even more complex swith many more form fields.
I am planning to store the macro in the word document itself rather in
the Normal dot.
Any suggestions to speed up the processing?
Bob Alston
bobalston9 AT yahoo D O T com
