Fill a Word document from Access and protect it

[Joop]

Hi All,

I have build a correspondence management system in Access. From the Access
VBA app a document is opend in Word with the right template and on a number
of bookmarks data from Access is filled-in so all the user has to do is
write the letter.

My question:

Is there a way I can protect the data, that was entered from Access, from
editing by the user (lock it)

So far I can't find a way in the Word object model, I have tried Formields
and looked at using subforms but I haven't found the answer yet

Any Ideas?

 

[Tom Wickerath]

I'm not a Word VBA expert, but can you protect these fields by using the menu system in Word? If
so, then turn on the macro recorder in Word and carry out the necessary steps. Stop the macro
recorder when you are finished. The resulting VBA code should provide a good starting point. You
can copy this code and paste it into an Access module. It will probably need small tweaks to make
it work right as automation code.

Tom
________________________________________


Hi All,

I have build a correspondence management system in Access. From the Access
VBA app a document is opend in Word with the right template and on a number
of bookmarks data from Access is filled-in so all the user has to do is
write the letter.

My question:

Is there a way I can protect the data, that was entered from Access, from
editing by the user (lock it)

So far I can't find a way in the Word object model, I have tried Formields
and looked at using subforms but I haven't found the answer yet

Any Ideas?