Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Location
    Texas
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    I know that this topic has been covered quite extensively. But, I cannot get Word 2000 to spell check the form fields when protected. I used the code from the Word MVP site. I can get the spell check sample to work, but I cannot get the code to work for a new documents with form fields. Any help will be appreciated. The form fields that I am using are for a resume that our students with handicaps can click and type, not have to worry about formatting and other things.

    Thanks,
    Bookman21 <img src=/S/bow.gif border=0 alt=bow width=15 height=15><img src=/S/flags/Texas.gif border=0 alt=Texas width=30 height=18><img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    How are you trying to execute the code?

    It could be, that if you are trying to execute it from a button, that it cannot find code which is saved with another document.

    To check, put a display (MsgBox "Test") as the first statement, and see if the code is actually being executed.

    Are you familar with templates? If not, check them out on the MVP site. They're exactly what you need here.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    New Lounger
    Join Date
    Oct 2001
    Location
    Texas
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Geoff,

    Thanks for the help. Unfortunately, I cannot get the code to work even from the Normal.dot template. I can get the spell check example to work, but not my resume. Any help will be greatly appreciated. I like how the code works in the spell check example. I need the document to be protected when students are using the forms.

    Thanks,
    Bookman 21

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Bookman,

    Can you move your code to a document which looks like your resume, copy the code you are using into that document, and attach it? It might be easier to work out what's going on.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    New Lounger
    Join Date
    Oct 2001
    Location
    Texas
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Geoff,

    I have attached the document with the code that comes from the word mvp site. I still cannot get it to work with the field codes. Strange though, the spell check example works. I would like this sample to become a template for the students to use. I appreciate the help.

    Thanks,
    Bookman21
    Attached Files Attached Files

  6. #6
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Bookman,

    In the sample you've attached, the macro is in the "Class Modules" section, and cannot be seen from Word directly.

    Try this. In the VBA environment, click Incert, Modules- and then cut all code from "Class1" and put it into "Module1". Then, in Word, press Tools, Macro, Macros- "RunSpellcheck" will be available (it wasn't in the document you attached).
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  7. #7
    New Lounger
    Join Date
    Oct 2001
    Location
    Texas
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Geoff,

    I still cannot get Word to have the document locked and still get the code to spell check the form fields. I have attached a new document. Let me know if I have it right this time. I would really like to be able to have this feature usuable for the students who really do need to have a spell check, but locked document.

    Thanks,
    Bookman21
    Attached Files Attached Files

  8. #8
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Bookman21,

    When the document is protected, macros cannot normally be run. What you have to do is to do a customisation (spelling in my language <img src=/S/grin.gif border=0 alt=grin width=15 height=15>)

    What you have to do is to is to get the macro working when it's protected.

    First, make sure it's a template, and not a document. You've posted a doc- so select File, Save As, and select the option "document template (*.dot}". The directory will have changed- switch it back to where it belongs.

    So, while it's unprotected, select from the menu Tools, Customoze (their spelling!). Click on the command tab, and select the category "Macros". There will be an item in there, like "Project.Module1.RunSpellCheck". (NMote that if you have a document instead of a template, that option may not appear). before doing anything else, make sure that the "Save In" option ant the bottom of the dialog box is set to your template, and not normal.dot.


    Select the "RunSpellCheck" macro, and drag it onto the toolbar, next to the spell check option. It will create a button which says something like "Project.Module1.RunSpellCheck". DON"T close the customose dialog- Right click on that new button. Select the "Default style" option.

    Right click on the normal spell check button. and select the "copy button image". Right click on your new button, and slect the "paste button image". Then drag the old spell check button out of the way.

    Reprotect your form, and save and close it.

    When a student needs a new form, they can double click on the "form.dot" template from Windows Explorer- or they can create from the "File New" dialog if the template is saved in the right place- but that's another lesson.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  9. #9
    New Lounger
    Join Date
    Oct 2001
    Location
    Texas
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Geoff,

    A million million thanks to you. I finally got the resume to work as a template. The code works beautifully. I need the code to be seemless to the users. You have to keep in mind that teachers and students will be using the resume format. The students range from deaf to our higher functioning mentally handicap. The resume will be needed to help them get jobs. So, thank you for helping me help them.

    Bookman21
    Eric Bowman
    Instructional Technology Specialist
    North East Independent School District
    San Antonio, TX

  10. #10
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Eric,

    Thanks for the real name <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

    I'm glad I could help.

    And thanks for the feedback. A thank you like that makes it worth while for all who contribute to the forum.

    If ever I can make it your way, I'd like to see the work which you are doing.

    I wish all your students the very best in their search for jobs.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  11. #11
    New Lounger
    Join Date
    Oct 2001
    Location
    Texas
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spellcheck form fields is not working with VB (Office 2000 Win 98 SE)

    Geoff,

    I wanted to let you know that my teachers in my district are using the resume that I created. They were impressed with the fact that document was locked and you can still spell check. I gave you the credit for that part. I know the opportunity to customize the resume for each of the schools (all together 7 high schools). I appreciate the help in getting me to make the technology work easier for both the teachers and students.

    Thanks,
    Eric <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    <img src=/S/flags/Texas.gif border=0 alt=Texas width=30 height=18>

Posting Permissions

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