L
L.A. Lawyer
I am trying to create a VBA macro (using Access 2000 and Word 2000) which
will:
1. loop through all of the fields of the currently displayed record in
the Access Activeform and grab those that have values
2. Open Word
3. Open a pre-fab document with a number of named {Ref } fields which
have the same name as the Access fields and insert the Access data as the
new value for that field and then, if possible,
4. Delete the Word field itself, but keep the value in that place as
normal text.
I can do Nos. 1 and 2, but I can't get anything about dealing with these
Word fields.
will:
1. loop through all of the fields of the currently displayed record in
the Access Activeform and grab those that have values
2. Open Word
3. Open a pre-fab document with a number of named {Ref } fields which
have the same name as the Access fields and insert the Access data as the
new value for that field and then, if possible,
4. Delete the Word field itself, but keep the value in that place as
normal text.
I can do Nos. 1 and 2, but I can't get anything about dealing with these
Word fields.