Solved

Data from doc properties wiped out when accepting all changes in Word 2010

Posted on 2014-07-28
3
112 Views
Last Modified: 2015-01-15
In an .mdb database originally running in Office 2003, I have Access VBA code that writes data to doc properties in documents created from Word .dot format templates.  The templates are set up to track changes.  When the documents are created, the user accepts changes (clicking the Accept All Changes button in the toobar), which changes the red underlined data displayed in DocProperty fields to black, non-underlined text.  The user may also change some text in the document, and then click Accept All Changes again.  This works fine.  But I recently upgraded the database to Access 2010 format (making a brand-new .accdb database, importing all objects into it, and making various changes as needed).  I also upgraded the templates to .dotx or .dotm format, as needed.  Now, when a new document is created from a template, the data from the doc properties is initially displayed (red, underlined), but when the user clicks Accept All Changes, the data disappears.  It is still in the doc properties -- I can see it in the Custom Properties dialog -- but it doesn't display on the document.  How can I prevent this data from disappearing?
0
Comment
Question by:Helen_Feddema
  • 3
3 Comments
 
LVL 31

Author Comment

by:Helen_Feddema
ID: 40225788
I just made a little test database and template to post here, and they did not have the problem, so I suspect it may be a result of updating the old .dot template to .dotx format.  This is an extremely complex template, so I hope it can be fixed without having to recreate it from scratch.  I can't post the actual template, because it has sensitive data.
0
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 0 total points
ID: 40551757
I figured it out myself -- the solution was to select all and update fields before accepting all changes.
0
 
LVL 31

Author Closing Comment

by:Helen_Feddema
ID: 40551760
This is more of a workaround than a solution, but it does the job.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Like many others, we try and discourage users from printing documents unnecessarily and instead send or share them electronically. However, this doesn't always work and documents are still printed. With this simple solution, if the user tries to …
When creating Microsoft Word-based forms there may be a need to have a form field repeated throughout the whole document. For instance, with a company name, you may want this information repeated automatically throughout the document rather than man…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now