Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Anyone using MS Word 'Forms' as input documents?
Message
From
25/09/2006 13:14:39
 
 
To
25/09/2006 09:25:41
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01156885
Message ID:
01156986
Views:
13
You can use Word VBA to post the field information to a web site.

Sorry, I don't have any of the code I used before as it was for a previous employer.

I used webconnect and modified some vb code from Rick Strahl's vbhttp.cls (I think) VB code that he used to distribute with early versions of webconnect.



Ken




>NOTE: I am repeating this in the VFP forum and the Office forum.
>
>I have a requirement that would be best addressed by using MS Word's "Forms" capability (or possibly a similar feature of MS Excel if it exists) as the input method for the users.
>
>I believe that Word's "Forms" feature allows output to a .CSV file that I could pick up and process. I suppose that I might even be able to simply scan through all of the form 'fields' and pick up the content that way.
>
>I am a complete NOVICE when it comes to this stuff... I don't know the characteristics/limitations of Word's "Forms" especially.
>
>I have 4 basic requirements:
>1) The user must be able to revise the general layout of the document without changing the 'content' of the "fileds" defined.
> - I am prepared to simply tell them that "fields" are sacrosanct as regards content (names, defaults, lists content, etc)
>2) I must be able to transfer any "fields" 'answered' into my database.
>3) I must be able to fill in their (prior) 'answers' if they re-display the form.
>4) I must be able to display the form and its 'answers' but PREVENT further changes if they have "signed off" the form in question.
>
>Note, too, that this "form" would be used multiple times for either the same 'entity' of the database or different entities.
>
>What are my chances? ... Is this worthy of further development or are there some gotchas that preclude this approach?
>
>Thanks
Previous
Reply
Map
View

Click here to load this message in the networking platform