Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2007

Tip: Looking for answers? Try searching our database.

DOCVARIABLES + BLANK

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JJ - 04 Oct 2007 11:03 GMT
OS - XP Prof SP2, Office 2003.
I have a VBA form where people choose how many people are party to an
agreement. If they select 2 then it must prompt twice for the 1st
Party name and 1st Party ID or Registration Number and prompt again
for 2nd Party and 2nd Party ID or Registration Number. If they choose
3 parties then it must prompt three times and assign to all different
variables. Then I have a word template which I would like to program
saying {DOCVARIABLE 1stParty} to insert the 1st party name, then
{DOCVARIABLE 1stPartyRegNo} the word "and" {DOCVARIABLE 2ndParty} to
insert the 2nd party name, then {DOCVARIABLE 2ndPartyRegNo}. However
if you have 3 parties it must do {DOCVARIABLE 1stPartyRegNo} to hard
returns (blank spaces) {DOCVARIABLE 2ndParty} to insert the 2nd party
name, then {DOCVARIABLE 2ndPartyRegNo} then the word "and" and
{DOCVARIABLE 3rdParty} {DOCVARIABLE 3rdPartyRegNo}. I know how to do
the form but I have no clue as to how to program the document for it
to know when to use 2 parties or when to use 3 parties. I thought of
something like "if docvariable parties = 2 then docvariable 1st Party,
docvariable 2nd party and docvariable 3rd party" but somehow I am not
managing to get the programming in the word template to understand my
commands. Unless I assign the whole toot to one variable and only
insert the one variable in my document. Any assistance or ideas will
be appreciated.
Doug Robbins - Word MVP - 05 Oct 2007 10:38 GMT
Just what type of form are you talking about?  It will be easier to give you
pertinent advice if you tell us that.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> OS - XP Prof SP2, Office 2003.
> I have a VBA form where people choose how many people are party to an
[quoted text clipped - 18 lines]
> insert the one variable in my document. Any assistance or ideas will
> be appreciated.
JJ - 25 Oct 2007 09:50 GMT
On Oct 5, 11:38 am, "Doug Robbins - Word MVP"
<d...@REMOVECAPSmvps.org> wrote:
> Just what type of form are you talking about?  It will be easier to give you
> pertinent advice if you tell us that.
[quoted text clipped - 31 lines]
>
> - Show quoted text -

I am talking about a VBA Userform where I have inserted a text box
where people enter "2" or "3" or "4" or how every many parties they
will have to the agreement. When they choose "2" then it will prompt
for two names. When they type a "3" it must prompt three times for the
names of the party.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.