Form Issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am really starting to dislike Word. I am much more accustomed to using
Excel and have had great success using the information from discussion
threads in Excel, but not so in Word.

I am 0 for 3 here. Starting with cross-referencing fields in a form. I was
able to cross-reference the field, but when I protect the document and fill
in the bookmarked field it pops up some sort of fill in box when I try to
exit the field. I have to cancel out of this box twice and am sure my users
will not be interested in doing that for each field throughout this form.

Moving on to using hyperlinks in protected forms. I followed the
instruction from the MVP article and can link to the website using the macro
when the form is not protected, but cannot when the form is protected. I
can't tell from the discussion threads if this is really something that can
be done. No one seems to have had success.

I have completely given up on my final request, for information on writing a
macro to send a Word Form as an attachment to an email. I was very
successful with this in Excel, but after countless attempts cannot seem to
get it to work in Word.

I'm sorry if I sound frustrated, but frankly I am. I thank anyone in
advance who can shed some light on my Word woes.

Holly
 
I have been having the same trouble. I have followed the same instructions
for using hyperlinks in protected froms without success. I wonder if it can
really be done.
 
See responses to multiple questions in-line.

What you are talking about is what Word calls an "online form." They are
clutzy but can be used. For more about online forms, follow the links at
http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian
Chapman's series of articles.

These forms must be protected or locked for fields to work appropriately.

hnyb1 said:
I am really starting to dislike Word. ***

I am 0 for 3 here. Starting with cross-referencing fields in a form. I was
able to cross-reference the field, but when I protect the document and fill
in the bookmarked field it pops up some sort of fill in box when I try to
exit the field. I have to cancel out of this box twice and am sure my users
will not be interested in doing that for each field throughout this form.
Click to expand...

It looks to me as if you are inserting a drop-down field rather than a text
field.
Regardless, you need the "calculate on exit" property checked for REF fields
to pick up the contents.
Moving on to using hyperlinks in protected forms. I followed the
instruction from the MVP article and can link to the website using the macro
when the form is not protected, but cannot when the form is protected. I
can't tell from the discussion threads if this is really something that can
be done. No one seems to have had success.
Click to expand...

The macros on the MVP FAQ page on this
(http://word.mvps.org/FAQs/TblsFldsFms/HLinksInForms.htm) work for me, just
fine. I am using Word 2003 but they work in Word 97 just as well. I just
retried it before posting to make sure. I expect that you will need to be
more specific in what it is that you are doing and what happens when you use
the macrobutton field in the locked form.
I have completely given up on my final request, for information on writing a
macro to send a Word Form as an attachment to an email. I was very
successful with this in Excel, but after countless attempts cannot seem to
get it to work in Word.
Click to expand...

I just tried to do this using File > Send To. It worked. What are you trying
to do through a macro that is not handled by this procedure? I would suggest
that you post a separate question on that with the macro you are trying. I
would suggest posting in the vba.beginners newsgroup rather than in this one
(about managing documents). Generally it is helpful (even if a bit
cumbersome) to limit each post to a single question or problem rather than a
littany of complaints. If you give the subject line a meaningful topic
related to that single issue you are even more likely to get good
assistance.
I thank anyone in
advance who can shed some light on my Word woes.

Holly
Click to expand...

Hope this helps,
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 
In response to your response.

On the first issue, I am not using a drop down field. I am using a text
field with "calculate on exit" checked. I re-did it to make sure.

On the second issue, I had previously followed the directions in the article
you supplied the link for and not been able to get it to work. Specifically,
the hyperlink works, using the macro button it is embedded to, when the
document is not protected. The reasons I know it is using the macro is (a) I
have to double-click the hyperlink and (b) if I cancel out of the warning box
it gives me a Run-Time Error. But, as soon as I protect the document and
double click the hyperlink it sends me to another field in the form and does
not connect me to the site.

I am using Word 2003 on Windows 2000. I appreciate your suggestion on
limiting issues in posts, but thought perhaps these issues all pointed to
something larger, i.e., I am using some "trimmed-down" version of the
software.

Thanks, anyways.
 
I am using Word 2003 on Windows 2000. I appreciate your suggestion on
limiting issues in posts, but thought perhaps these issues all pointed to
something larger, i.e., I am using some "trimmed-down" version of the
software.
Click to expand...
I don't believe a "trimmed-down" version of Word is marketed. Even as a part
of the Works package, Word is the full version. You can disable features
during install, but that takes work and special effort.

I know how frustrating this can be; Word is a very complex program.
Nevertheless, if you use the macros from the FAQ site and properly write the
fields, it does work. I suspect that the problem is in the writing of the
fields.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 
Back
Top