Looping in a Form

I have Office XP with Front Page 2002. I have a form
with 18 questions. Question 18 is a radio button
response. I need to know where/what to code in the page
that if the YES option is selected, the user is returned
to questions 12-18 for each occurrence of a YES in
question 18 (up to 10 loops). I also want to store the
results of each occurrence/respones to questions 12-18 in
its own cell in an Excel spreadsheet.

I have the form page built for the first occurrence, but
not the looping. I am totally stuck. I don't find IF
THEN ELSE, DO WHILE, etc. options in FrontPage help
files, are they there?

Steve
Wed Jan 26 13:36:23 CST 2005

With the page open Click Tools scroll down to Macro and then select Microsoft script editor and work
on your script there.

That said, might there be an easier way instead of looping through the form 18 times??
I can see myself, somewhere around the 3rd or 4th "loop," heading for the X in the upper right
corner.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
.......................with a computer

"Pam" <anonymous@discussions.microsoft.com> wrote in message
news:089201c503cf$0585b710$a401280a@phx.gbl...
> I have Office XP with Front Page 2002. I have a form
> with 18 questions. Question 18 is a radio button
> response. I need to know where/what to code in the page
> that if the YES option is selected, the user is returned
> to questions 12-18 for each occurrence of a YES in
> question 18 (up to 10 loops). I also want to store the
> results of each occurrence/respones to questions 12-18 in
> its own cell in an Excel spreadsheet.
>
> I have the form page built for the first occurrence, but
> not the looping. I am totally stuck. I don't find IF
> THEN ELSE, DO WHILE, etc. options in FrontPage help
> files, are they there?

Jens
Wed Jan 26 14:57:05 CST 2005

This is a multi-part message in MIME format.

------=_NextPart_000_0037_01C503F1.F9974810
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

No you wont find those there. You can find them in an ASP tutorial.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

> -----Original Message-----
> From: Pam [mailto:anonymous@discussions.microsoft.com]
> Posted At: 26. januar 2005 18:47
> Posted To: microsoft.public.frontpage.programming
> Conversation: Looping in a Form
> Subject: Looping in a Form
>
>
> I have Office XP with Front Page 2002. I have a form with 18
> questions. Question 18 is a radio button response. I need
> to know where/what to code in the page that if the YES option
> is selected, the user is returned to questions 12-18 for each
> occurrence of a YES in question 18 (up to 10 loops). I also
> want to store the results of each occurrence/respones to
> questions 12-18 in its own cell in an Excel spreadsheet.
>
> I have the form page built for the first occurrence, but not
> the looping. I am totally stuck. I don't find IF THEN ELSE,
> DO WHILE, etc. options in FrontPage help files, are they there?
>

------=_NextPart_000_0037_01C503F1.F9974810
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7036.0">
<TITLE>Re: Looping in a Form</TITLE>
</HEAD>
<BODY>


No you wont find those there. You can find them in an =
ASP tutorial.


Regards Jens Peter Karlsen. Microsoft MVP - =
Frontpage.


> -----Original Message-----

 > From: Pam [<A =
HREF=3D"mailto:anonymous@discussions.microsoft.com">mailto:anonymous@disc=
ussions.microsoft.com</A>] 

 > Posted At: 26. januar 2005 18:47

 > Posted To: =
microsoft.public.frontpage.programming

 > Conversation: Looping in a Form

 > Subject: Looping in a Form

 > 

 > 

 > I have Office XP with Front Page 2002.  I =
have a form with 18 

 > questions.  Question 18 is a radio button =
response.  I need 

 > to know where/what to code in the page that if =
the YES option 

 > is selected, the user is returned to questions =
12-18 for each 

 > occurrence of a YES in question 18 (up to 10 =
loops).  I also 

 > want to store the results of each =
occurrence/respones to 

 > questions 12-18 in its own cell in an Excel =
spreadsheet.

 > 

 > I have the form page built for the first =
occurrence, but not 

 > the looping.  I am totally stuck.  I =
don't find IF THEN ELSE, 

 > DO WHILE, etc. options in FrontPage help files, =
are they there?

 > 


</BODY>
</HTML>
------=_NextPart_000_0037_01C503F1.F9974810--

Pam
Thu Jan 27 06:32:33 CST 2005

Thanks Steve

I would be right there with you at the "X", however, the
user insists that the looping is imperative.

>-----Original Message-----
>With the page open Click Tools scroll down to Macro and
then select Microsoft script editor and work
>on your script there.
>
>That said, might there be an easier way instead of
looping through the form 18 times??
>I can see myself, somewhere around the 3rd or
4th "loop," heading for the X in the upper right
>corner.
>
>
>--
>Steve Easton
>Microsoft MVP FrontPage
>95isalive
>This site is best viewed............
>........................with a computer
>
>"Pam" <anonymous@discussions.microsoft.com> wrote in
message
>news:089201c503cf$0585b710$a401280a@phx.gbl...
>> I have Office XP with Front Page 2002. I have a form
>> with 18 questions. Question 18 is a radio button
>> response. I need to know where/what to code in the
page
>> that if the YES option is selected, the user is
returned
>> to questions 12-18 for each occurrence of a YES in
>> question 18 (up to 10 loops). I also want to store the
>> results of each occurrence/respones to questions 12-18
in
>> its own cell in an Excel spreadsheet.
>>
>> I have the form page built for the first occurrence,
but
>> not the looping. I am totally stuck. I don't find IF
>> THEN ELSE, DO WHILE, etc. options in FrontPage help
>> files, are they there?
>
>
>.
>

Pam
Thu Jan 27 06:33:39 CST 2005

Thanks Jens Peter

Do you have a link for a GOOD ASP tutorial? I normally
work with web pages in Dreamweaver, and find Front Page a
little less intuitive, however, would like to become
proficient in both formats.

>-----Original Message-----
>No you wont find those there. You can find them in an
ASP tutorial.
>
>Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
>
>> -----Original Message-----
>> From: Pam [mailto:anonymous@discussions.microsoft.com]
>> Posted At: 26. januar 2005 18:47
>> Posted To: microsoft.public.frontpage.programming
>> Conversation: Looping in a Form
>> Subject: Looping in a Form
>>
>>
>> I have Office XP with Front Page 2002. I have a form
with 18
>> questions. Question 18 is a radio button response. I
need
>> to know where/what to code in the page that if the YES
option
>> is selected, the user is returned to questions 12-18
for each
>> occurrence of a YES in question 18 (up to 10 loops).
I also
>> want to store the results of each occurrence/respones
to
>> questions 12-18 in its own cell in an Excel
spreadsheet.
>>
>> I have the form page built for the first occurrence,
but not
>> the looping. I am totally stuck. I don't find IF
THEN ELSE,
>> DO WHILE, etc. options in FrontPage help files, are
they there?
>>
>

Looping in a Form

Re: Looping in a Form by Steve

Re: Looping in a Form by Jens

Re: Looping in a Form by Pam

Re: Looping in a Form by Pam