Re: Userform to Doc to Access by Doug
Doug
Sat Jun 14 01:43:45 PDT 2008
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" <SoCalRick@discussions.microsoft.com> wrote in message
news:EC185296-3C39-4CEC-8E2F-090A0774BB58@microsoft.com...
> 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