Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2005

Tip: Looking for answers? Try searching our database.

ClearForm in Protected Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sue - 14 Oct 2005 19:55 GMT
I'm trying to add a Command Button that will clear my form while at the same
time being protected.  Editing restrictions are Filling in Forms.  The button
works when I turn protection off, but will not work while on.

I also want to hide the button during printing.

Can anyone help?
Anne Troy - 14 Oct 2005 20:28 GMT
Sue: Why not save your form as a template instead? When you're done, you can
close and not save. If you use the form a lot, you could record a macro in
your normal.dot file to close and reopen for you, and add a button to your
toolbar.
************
Anne Troy
www.OfficeArticles.com

> I'm trying to add a Command Button that will clear my form while at the
> same
[quoted text clipped - 5 lines]
>
> Can anyone help?
Sue - 14 Oct 2005 20:47 GMT
I like the way the protected form works better than the template.  This is
going to be widely used, and I want it as simple as possible to use.  I'd
like the user to open the form and be able to tab to each field.  I also have
a bunch of calculations invoved.

> I'm trying to add a Command Button that will clear my form while at the same
> time being protected.  Editing restrictions are Filling in Forms.  The button
[quoted text clipped - 3 lines]
>
> Can anyone help?
Doug Robbins - 14 Oct 2005 21:13 GMT
You mis-understand, the form containing the formfields can be a template.
Each time it is needed, you just create a new document from the template and
that process can be automated by the use of a macro.  Then there is no need
to clear the fields in the form.

But, what are you doing with the data in the form?

Signature

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

>I like the way the protected form works better than the template.  This is
> going to be widely used, and I want it as simple as possible to use.  I'd
[quoted text clipped - 11 lines]
>>
>> Can anyone help?
Sue - 14 Oct 2005 21:23 GMT
OK.  So I can make the protected form itself a template?  I'm still new at
this stuff, so I'll play with it a little bit.  I never considered that.

For now I'm not doing anything with the data from the form.  It's basically
fill in and print out.  I want the user to be able to save the filled out
form as reference also.

> You mis-understand, the form containing the formfields can be a template.
> Each time it is needed, you just create a new document from the template and
[quoted text clipped - 18 lines]
> >>
> >> Can anyone help?
Anne Troy - 14 Oct 2005 21:39 GMT
If you want them to save the form, then a template is DEFINITELY the way to
go. It will also keep users from overwriting your "original". When you
double-click a template, or hit File-New, and choose a template, "document1"
is created, see? :)
When I distribute templates to multiple people, tho, I tend to send it as a
doc and tell THEM to open it, then File-->Save as, DOT, making sure they
don't change the folder to which it wants to save by default. That way, you
don't have to go through all the bother of figuring out where their other
templates are located, etc. If you want multiple users on the same network,
tho, you can just store the template on a shared drive.
************
Anne Troy
www.OfficeArticles.com

> OK.  So I can make the protected form itself a template?  I'm still new at
> this stuff, so I'll play with it a little bit.  I never considered that.
[quoted text clipped - 32 lines]
>> >>
>> >> Can anyone help?
Charles Kenyon - 14 Oct 2005 22:57 GMT
You definitely want a template of your online form. When you use the form,
you create a new document based on the template. That document can be filled
in and saved. Users will be forced to name the new document when they save
it. For more on the different kinds of templates, tabs on the file new
dialog, and locations of templates folders see
http://addbalance.com/usersguide/templates.htm.

What you are talking about is what Word calls an "online form." Check this
in help. 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. You may also want to look at
http://www.word.mvps.org/FAQs/TblsFldsFms/LinesInForms.htm.

Hope this helps,
Signature


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://word.mvps.org/FAQs/ 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.

> OK.  So I can make the protected form itself a template?  I'm still new at
> this stuff, so I'll play with it a little bit.  I never considered that.
[quoted text clipped - 32 lines]
>> >>
>> >> Can anyone help?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.