Userform to Doc to Access

[SoCal Rick]

Hi,
First let me tell you I really appreciate Doug, Jean-Guy and all the other
MVPs. You've already made my life much easier.
Now I have a question. I have a Word Template that has text boxes, check
boxes and option buttons. The file is sent via email to hundreds of users.
[Should they receive this as a Template or a Document?]
When the user finishes filling out the user forms, they run a macro that
transfers the data to {DOCVARIABLE} fields in Word Template. The user prints
the document, saves it and emails it back. I thought I could also save it as
a "Fields" text document to get the answers, but the {DOCVARIABLE} fields
don't save.
What is the most efficient way to get the user's answers so they can be
loaded into Access?
I am sorry to have to ask you all for help here, but I am simply lost.
Thank you
SoCal Rick

 

[Doug Robbins - Word MVP]

You can use the .Value attribute of the variables in the document to get the
data that is stored in them.

For example

MsgBox ActiveDocument.Variables("varname").Value

will display the data stored in the variable "varname"

Reur question about whether the users should receive a document or a
template, I think it would be best if you could redesign the form so that it
used formfields and did not require any code to be run by the user. That
way you can avoid problems with macro security at the user end.

In place of the option buttons, you may need to use DropDown formfields for
the user to select the item for which they would otherwise have clicked an
option button.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[SoCal Rick]

Hi Doug,
Thank you for the advice. I am going to follow your suggestions.
SoCal Rick