Re: Locking form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve Lang (nowhere_at_Nohow.not)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 15:13:40 -0700

Depending on your environment, you could have the data from your form fields
uploaded to a database, which you can adequately secure. Any further
attempts to overwrite the data in the database could trigger alerts, create
additional datasets, or any number of things. This way, you could trust the
integrity of the data. The fact that it was created in Word would be
irrelevant.
Just a thought.

Steve

"rlampky" <rlampky@NOSPAM.hotmail.com> wrote in message
news:ueJpjj%23JEHA.3120@TK2MSFTNGP11.phx.gbl...
> Thanks,
>
> What about a VBA macro that disabled the form fields and would from that
> point on indicate that the form has been altered if it was edited or
> changed after saving?
>
> Along with teh VBA password, and other suggested options.
>
>
> "Charles Kenyon" <msnewsgroup@remove.no.spam.addbalance.com> wrote in
> message news:%234JGWR%23JEHA.1156@TK2MSFTNGP09.phx.gbl...
> > If a document can be view / read, it can be copied and altered.
> >
> > You could use an on-exit macro for your last field in a form that
disabled
> > text entry in all of the formfields. This would leave you with a
> > non-editable protected form. If you password protect your vba and use a
> > password for protecting the form this is tight. However, form protection
> is
> > easily defeated. It would take any of the MVPs or regular
> > contributors/readers here perhaps five-fifteen minutes. Steve Lang's
> > suggestion for converting to pdf is helpful but would leave you with the
> > original plus the pdf.
> >
> > My opening remark applies to pdf files as well. You can make it hard to
> make
> > changes, you can't make it impossible.
> >
> > What you are talking about is what Word calls an "online form." For more
> > about online forms, follow the links at <URL:
> > http://addbalance.com/word/wordwebresources.htm#Forms> or <URL:
> > http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm> especially
> Dian
> > Chapman's series of articles.
> >
> > 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.
> >
> > "rlampky" <rlampky@NOSPAM.hotmail.com> wrote in message
> > news:e0cMXW9JEHA.2884@TK2MSFTNGP12.phx.gbl...
> > > Is there a method using VBA that at the completion of a form, the
user
> > can
> > > lock the document so that no alterations can be made when it is
> reopened.
> > > (needs to be stronger than protect/unprotect)
> > >
> > > This would probable include deleting the attached macros or some other
> > > finalization via the toolbar so that the document can viewed, but not
> > > altered?
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Caching Problem in Form in IE7 only
    ... database product that's part of Office Professional. ... I'd suggest reposting your question to a newsgroup dealing with Internet ... I just typed doesn't appear in the form fields. ... information problem in IE7 only. ...
    (microsoft.public.access.forms)
  • Re: Filling PDF Forms
    ... >> Are there any Ruby utilities out there for filling out PDF forms? ... >> I have PDF form that I would like to populate from a database. ... I have a pre-existing PDF file which has various form ... defined form fields with data from a database and provide the completed ...
    (comp.lang.ruby)
  • Re: Protection Issue with Textboxes
    ... > database and wasn't sure that the forms text fields would work (as opposed ... > to the controls toolbox). ... Then you're definitely better off with form fields, ... This reply is posted in the Newsgroup; please post any follow question or ...
    (microsoft.public.word.docmanagement)
  • Re: Form on 2 pages
    ... Unless you are using a database, you will have to pass all the page one form fields to the page 2 form so the page 2 form can send ... To find the best Newsgroup for FrontPage support see: ...
    (microsoft.public.frontpage.client)
  • Re: Exporting Report from Access into PDF
    ... I have the module in my database. ... Double checked to make sure it was not set up to the Adobe PDF ... press the "Click Here to Save this Report as a PDF document" button I ... ' PDFNoFontEmbedding - Do not Embed fonts in PDF. ...
    (microsoft.public.access.externaldata)