Results 1 to 11 of 11
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Using Microsoft Forms in Word?? (2000)

    We are investigating several possibilities for collection of information to be subsequently extracted into an Access database. One of those possibilities is to use a Word template and Forms to capture the data and validate it. What sort of experience have Word users had in building Word applications that use forms, either good or bad? Thanks for your feedback.
    Wendell

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    The only parts I don't like are: (1) you have very restricted access to the document, due to the protection; you can read the .Result of the FormField objects, but that's about it; (2) MacroButtons require a double-click (or you can tab into them, but they can't retain focus, so the screen can jerk around), Toolbars can hide, so unlike a UserForm, it requires a bit of training on "how it works"; I've never tried the ActiveX controls, but I imagine they have their own issues.

  3. #3
    Star Lounger
    Join Date
    Aug 2002
    Location
    Orlando, Florida, USA
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    I like the forms in word, we use them a lot at our firm. A few gliches here and there but overall pretty nice. I also don't like the limits that are put on you with the protection, I think there should be a way to just protect the template but allow others to make changes to the .doc that is created off of the template. Like I said though they work for us. we use them for our check request, vacation request and several others.

  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    Wendell,

    I use Word forms (fill-in as opposed to UserForms) to capture data for Access. It allows us to send the forms to various regions and then import them into Access locally. All the validation is done in Access.

    I've got a sample on my website the first item under Access, Import Data from a Word Fill-In form into Access, that show how I have done it. I'd post it here, but it's too big (245K) to post.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    Thanks everyone - I appreciate the feedback. I think the option of doing things via the web is the best option in this case, but if the client says no to that approach, then I think the Word forms approach will be my backup. Thanks again.
    Wendell

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    Well, the client insisted on using Word (for a variety of reasons), so this topic is of considerable interest. And I'm confused:

    What is the difference between UserForms, Microsoft Forms and Fill-In Forms? In the Word (2002) help it seems to imply that UserForms and Microsoft Forms are the same thing - but the prior responses made a distinction. And I've used what I think of as Fill-In forms using the {ASK} field - but is that what people meant here?

    To complicate this, I have to make this work in Word97, Word 2000 and XP at a minimum - they would like 95 as well (and probably Star Office, WP, etc.), but I think I can draw the line at 97. Then I have to import data into an Access database for analysis and record-keeping, and create a Word output document. Fun, huh! Thanks in advance.
    Wendell

  7. #7
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    Wendell,

    My working assumption regarding terminology is that 'UserForms' (built in the Visual Basic Editor) are the implementation of Windows Forms that is available in Office - userforms providing a subset of the functionality available in Windows forms.

    Fill-in forms commonly refer to form fields used in a Word document that is protected for forms - go to View > Toolbars and make the Forms toolbar visible - this will give you access to Word's palette of form fields that you can insert into a document. The fields don't become active as form fields until the document has been protected with "forms" protection.

    As mentioned earlier in the thread, userforms provide a lot more functionality than protected form fields, but if you need to provide for different versions of Word including 95, I think you would be safer using a protected form/form fields.

    Gary

  8. #8
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    Wendell,

    In my reply above I used UserForm and Fill-In Form.

    To me a UserForm is a form in the Windows sense. It is a separate window that pops up, along the same lines as an Access Form.

    A Fill-In form is as Gary said. Just a "plain" Word document with some designated areas to enter data. Think of a Fill-In form in terms of an actual paper form. There are specific areas to write the information in. Well, In Word, those areas would be Form Fields.

    Now for Microsoft Forms. They as just another name for a UserForm. You may also see MSForms in the Word Object Model. That's just another name for a UserForm.

    To see how I got data from a Word Fill-In form, have a look at the page I mentioned in <post#=237877>post 237877</post#>

    Then for going from Access back out to Word, have a look at the two articles that I wrote on automating Word from Access at http://www.databaseadvisors.com/newsletters.htm. There is also a part 3 to those articles that haven't been posted yet. I can probably dig the unedited, unpolished version up if you want/need.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    Thanks to both Gary and Bryan - my planned approach at this point is to use "User Forms" since I need to ask the user to make several selections where they need to pick from a set of fairly long text string choices. What I envision is a document that has some basic instruction, and a command button that kicks off the process. That process would build a separate document with lots of numbers representing their choices along with some entered text strings, and would be emailed as an attachment to the headquarters location. One possible glitch I see is that the process is fairly complex, and probably needs to be pausable and restartable. I think that entails saving the draft document on command, and being able to reload and resume in the middle, but that's a ways down the road. Thanks again for the clarifications - if you see anything in what I'm suggesting that worries you, please let me know.
    Wendell

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    Thanks especially for the references to the DatabaseAdvisors site - I visited your site yesterday and looked at your page using the Fill-In form. I feel fairly comfortable with the process of going from Access to Word as I've done that before, but it never hurts to have some backup. Also see my response to Gary above.
    Wendell

  11. #11
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Microsoft Forms in Word?? (2000)

    Wendell,

    Here is another thought. If all you are going to be "saving" in the Word document that gets sent back is just a series of numbers and text strings, why not just use a plain ascii text file? It will cut down on the file size, since you won't have the overhead of Word's file format.

    An added benefit is that, depending on how you set up the text file, you might possible be able to send more than one "record" at a time in the text document.

    Just another thought off the top of my head. Otherwise, I don't see anything that raises any flags for me.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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