Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    spellchecking protected forms (2002)

    (Edited by HansV to provide link to post - see <!help=19>Help 19<!/help>)

    I have read all of the posts that talk about spellchecking in protected forms. I am trying to do that very thing. We have many forms that we use that are protected with form fields that the users tab from field to field to fill in. anyone can do it. We wanted to make it as easy as possible for them. However, you can't spellcheck once it's protected. Our users type quite a bit of information into these forms. Some of these grow to be 2-3 pages long. No longer a form in my opinion, but you can't tell them that.

    Anyway, I tried the formspeller but that only checks the part of the document that is not in fields. I need to check the fields for errors. I have been working with the VB code that I got off of the threads through the original <post#=432175>post 432175</post#>. I cannot get it to check the form fields. When I use the example form that they give you, it works fine. However, when I copy the VB code to my form, it does not work. What am I missing? Can't you copy VB code from one file to another?

    I not a programmer. I don't know a lot about VB, but I can fake it pretty good. I can't figure out why it won't work. Any help would be appreciated.

    djbooks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: spellchecking protected forms (2002)

    Yes, you can copy VBA code from one document or template to another. But by default, form fields are set to be skipped when checking spelling and grammar. Try the following:

    Unprotect your document.
    Select the entire document.
    Select Tools | Language | Set Language...
    Click the "Do not check spelling and grammar" check box a few times until it is clear.
    Click OK.
    Reprotect your document for forms.

    Enter some text in the form fields, including some errors, then try the macro again.

  3. #3
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spellchecking protected forms (2002)

    Hi Hans,

    I tried that. It did not work. I am attaching both documents for you to look at. Like I said, I don't see anything different in them as far as the code goes. If you look at the working document, the spellcheck is available as soon as you open the form. You don't even have to run the macro. The not working document cannot be spellchecked unless you unlock the form which we are trying to avoid because they always forget to lock it again and the print and lose everything. What a nightmare!

    Thanks again for your help

    djbooks
    Attached Files Attached Files

  4. #4
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spellchecking protected forms (2002)

    it would only let me attach one so here is the second one.
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: spellchecking protected forms (2002)

    There is some confusion here, I think. The "working document" has not been protected, so you can use the standard spell-checking menu option and toolbar button. However, nothing prevents the user from messing with the document, since it is not protected.

    The second document is protected, and the macro works, but you haven't provided a way to run it. I have attached a modified version (zipped) with a custom toolbar that lets the user check the spelling.
    Attached Files Attached Files

  6. #6
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spellchecking protected forms (2002)

    that works great! thanks so much for your help. You're the best!

    djbooks

  7. #7
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: spellchecking protected forms (2002)

    Hi Hans

    Sorry to bother you again with this, but I am now trying to copy that code to my other forms and it does not work. If I go through the organizer and try and copy the toolbar, the copy button is grayed out (although it will let me copy it to another document but not a template). If I try to copy the VB code, it copies but when the spellcheck runs, it skips the form fields. What am I doing wrong?

    djbooks

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: spellchecking protected forms (2002)

    You must unprotect the document before trying to copy toolbars etc. If I do that, I don't have problems copying the toolbar to either another document or to a template. You did select (click on) the SpellCheck toolbar in the Organizer, didn't you? If you haven't selected it, the Copy button will remain disabled.

    And have you cleared the "Do not check spelling or grammar" check box for the entire document/template, as suggested in an earlier reply?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •