Link to home
Start Free TrialLog in
Avatar of bnp6622
bnp6622

asked on

Confirmation page not appearing

Occasionaly I import an access database into frontpage.  I then build a form using the same field definitions.  Sometimes I have to export and then reimport the file.   It is on these occassions I lose the connection to the confirmation page.  When I test the form and hit the submit button it just returns another blank form.  

I go to form properties and and reselect the my custom confirmation form but it still will not appear.   I do have forms were it will appear but I do not know enough to trouble shoot forms where " onfirm" will not appear

Any help would be appreciated.

-bruce
Avatar of hhammash
hhammash
Are you using the default confirmation page?

If yes why don't you create your own page (any html page with any text that you want).

hhammash
Avatar of bnp6622
bnp6622

ASKER

hh,
I do create an asp confirmation page.  It works most of the time.  However on one of my forms when I test on the web I hit the the "submit button" and the blank form returns. Hitting the "back button" returns to the filled out form.   I was looking for away to trouble shoot why this was happening, so when I get this error I know where to look.   I have been doing custom confirmation forms for some time.   I seem only to get problem when I build db in access off line and import to my web.   (note I believe it was your instructions posted on this website.. about that it is better to build your db in access then import to FP as opposed to building the form and letting the form create the database.  It is puzzling why one form's confirmation page works and anothers does not.

any help would be appreciated.  

note I am the one who had the asprunner problems... with your I help I did solve ... however I am having them again and can not seem to find a solution... still getting that server path error looking for db...   but that is for another time

-bruce
Avatar of hhammash
hhammash
Hi bruce,

Yes of course I remember.

Yes I prefer to create the database and connect the form to it.  

Can you post the form code please?

Thanks
Avatar of bnp6622
bnp6622

ASKER

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Team Registration</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link REL="stylesheet" HREF="../../_themes/style.css" TYPE="text/css">
<style>
<!--
 li.MsoNormal
      {mso-style-parent:"";
      margin-bottom:.0001pt;
      font-size:12.0pt;
      font-family:"Times New Roman";
      margin-left:0in; margin-right:0in; margin-top:0in}
-->
</style>
<script language="Javascript" type="text/javascript" name="J-BotCountDown" ><!--
// Webs Unlimited's J-BOTS FrontPage 2004 JavaScript Generator version 4.0
// Copyright Webs Unlimited 1998, 1999, 2000, 2001, 2002, 2003, 2004 All rights reserved - http://WebsUnlimited.com
// make an array of length n Needed for older javascript browsers
function makearray(n) {
      this.length = n
      for (var i = 1; i <= n; i++) {
            this[i] = null;
}
return this;
}
function IsIn(value,search) {
      if(search.indexOf(value) != -1) {
        return 1;
 } else {
            return 0;
   }
}

function LeadZero(value) {
      if ( value < 10)
        document.write('0');
}
 function UntilFormat(format,twoplace,year,month,day) {
var operators = 'sSmMdDwWnNY%';
var value = '';
// get the numbers
var today = new Date;
var when = new Date(year,month-1,day);
var todayyear = today.getYear();
var whenyear = when.getYear();
if(todayyear > 99) { todayyear -= 1900; }
if(whenyear > 99) { whenyear -= 1900; }
var seconds = Math.floor((when.getTime() - today.getTime()) / 1000); // %s
if(seconds < 0) {
      document.write('The date must be in the future!');
      return;
}
var leaptoday = today.getYear() / 4 - Math.floor(today.getYear()/4);
if(leaptoday == 0 && today.getMonth() > 1) {
leaptoday = 1;
} else {
  leaptoday = 0;
}
var leapwhen =  when.getYear() / 4 - Math.floor(when.getYear()/4);
if(leapwhen == 0 && when.getMonth() > 1) {
  leapwhen = 1;
} else {
  leapwhen = 0;
}
var leapyears = leaptoday + leapwhen;
leapyears += Math.floor(((--whenyear - todayyear) / 4 - 1));
//check for Daylight savings time
var TestDate = new Date;
TestDate.setMonth(3);
TestDate.setDate(1);
TestDay = TestDate.getDay();
var SatFirst = 7 - TestDay;
TestDate.setMonth(9);
TestDate.setDate(31);
var SatLast = 31 - (TestDate.getDay()+1);
if((((month == 4) && (day > SatFirst)) || month > 4) && (month < 11 || ((month ==10) && day < SatLast))) {seconds += 60 *60;}
var minutes = Math.floor(seconds / 60); //%m
var hours = Math.floor(minutes / 60); // %h
var days = Math.floor(hours / 24); // %d
var weeks = Math.floor(days / 7); // %w
var yearsleft = Math.floor(days / 365); // %Y
if(when.getYear() == today.getYear()) { // %N
  var monthsleft = when.getMonth() - (today.getMonth());
  if(monthsleft >= 1 && (when.getDate() < today.getDate())) --monthsleft;
} else {
  if(yearsleft == 0) {
    monthsleft = when.getMonth() + (11 - today.getMonth());
    if(when.getDate() >= today.getDate()) ++monthsleft;
  } else {
    monthsleft = when.getMonth() + (11 - today.getMonth());
    if(when.getMonth() > today.getMonth()) {
      monthsleft = when.getMonth() - (today.getMonth());
      if(monthsleft >= 1 && (when.getDate() < today.getDate())) --monthsleft;
    } else {
      monthsleft = when.getMonth() + (11 - today.getMonth());
      if(when.getDate() > today.getDate()) ++monthsleft;
    }
  }
} // %N
var months = (yearsleft * 12) + monthsleft; // %n
var hoursleft = hours - (days * 24) - 1; // %H
if(hoursleft <= 0) hoursleft = 23;
var minutesleft = minutes - hours * 60; // %M
var todaymonth = today.getMonth() + 1;
if( todaymonth == 02) {
       var daysleft = 28 + leapyears - today.getDate();
}else {
      if(todaymonth ==  04 || todaymonth == 06 || todaymonth == 09 || todaymonth == 11) {
            daysleft = 30 - today.getDate();
      } else {
          daysleft = 31 - today.getDate();
      }
}
if(when.getDate() < today.getDate()) {
 daysleft += when.getDate()  - 1;
} else {
 daysleft = day - today.getDate() - 1;
 if(daysleft < 0) {++daysleft; }
}
var weeksleft = Math.floor(daysleft / 7); // %W
var secondsleft = seconds - minutes * 60; // %S
var pos = 0;
while (pos < format.length) {
      if( format.substring(pos,pos+1) != '%')
      {
            document.write(format.substring(pos,pos+1));
            pos++;
            continue;
      } else {
            if (!IsIn(format.substring(pos,pos+1), operators))            {
                  document.write(format.substring(pos,pos+1));
                  pos++;
                  continue;
            } else {
                  if ( format.substring(pos,pos+1) == '%')                   {
                        pos++; // look ahead
                        if (format.substring(pos,pos+1) == '%')
                        {
                              document.write('%');
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'd')
                        {
                              if(twoplace) LeadZero(days);
                              document.write(days);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'D')
                        {
                           if(twoplace) LeadZero(daysleft);
                           document.write(daysleft);
                           if( todaymonth == 02) { // reset daysleft if weeks was used.
                                    daysleft = 28 + leapyears - today.getDate();
                              }else {
                                    if(todaymonth ==  04 || todaymonth == 06 || todaymonth == 09 || todaymonth == 11) {
                                          daysleft = 30 - today.getDate();
                                    } else {
                                          daysleft = 31 - today.getDate();
                                    }
                              }
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 's')
                        {
                           if(twoplace) LeadZero(seconds);
                                 document.write(seconds);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'S')
                        {
                              if(twoplace) LeadZero(secondsleft);
                              document.write(secondsleft);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'h')
                        {
                           if(twoplace) LeadZero(hours);
                                 document.write(hours);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'H')
                        {
                           if(twoplace) LeadZero(hoursleft);
                           document.write(hoursleft);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'm')
                        {
                           if(twoplace) LeadZero(minutes);
                                 document.write(minutes);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'M')
                        {
                           if(twoplace) LeadZero(minutesleft);
                                 document.write(minutesleft);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'w')
                        {
                           daysleft = Math.ceil((days / 7 - Math.floor(days / 7)) * 7);
                           if(twoplace) LeadZero(weeks);
                                 document.write(weeks );
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'W')
                        {
                           daysleft = Math.ceil((daysleft - weeksleft * 7));
                           if(twoplace) LeadZero(weeksleft);
                                 document.write(weeksleft);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'n')
                        {
                           if(twoplace) LeadZero(months);
                                 document.write(months);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'N')
                        {
                           if(twoplace) LeadZero(monthsleft);
                                 document.write(monthsleft);
                              pos++;
                              continue;
                        } else {
                        if (format.substring(pos,pos+1) == 'Y')
                        {
                           if(twoplace) LeadZero(yearsleft);
                                 document.write(yearsleft);
                              pos++;
                              continue;
                        }                        
       pos++; // ignore the char
            }
} } } } } } } } } } } } } } } } }
//--></script>
</head>

<body marginwidth="10" marginheight="10" topmargin="10" bottommargin="10" leftmargin="10" rightmargin="10">

<div align="center">
  <center>
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber1">
    <tr>
      <td width="100%" height="30" class="footer" valign="middle" align="center">
      <!--webbot bot="Navigation" S-Orientation="horizontal" S-Rendering="html" S-Bar="Bars" S-Btn-Nml="&lt;A HREF=&quot;#URL#&quot; TARGET=&quot;#TARGET#&quot; STYLE=&quot;{text-decoration: none;}&quot;&gt;#LABEL#&lt;/A&gt;" S-Btn-Sel="#LABEL#" S-Btn-Sep="&amp;nbsp;|&amp;nbsp;" S-Type="parent" B-Include-Home="TRUE" B-Include-Up="FALSE" --></td>
    </tr>
  </table>
  </center></div>
<div align="center">
  <center>
  <table border="1" cellpadding="8" cellspacing="0" style="border-collapse: collapse" width="707" id="AutoNumber1">
    <tr>
      <td width="162" class="leftside" align="left" valign="top">
      <p>
      <!--webbot bot="Navigation" S-Orientation="vertical" S-Rendering="graphics" S-Type="parent" B-Include-Home="TRUE" B-Include-Up="FALSE" --></p>
            <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>
      <img border="0" src="../../images/design_elements/spacer.gif" width="160" height="1"></p>
      </td>
      <td width="323" class="middle" align="left" valign="top">
      <form method="POST" action="--WEBBOT-SELF--" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">
            <!--webbot bot="SaveDatabase" SuggestedExt="asp" U-ASP-Include-Url="../../_fpclass/fpdbform.inc" S-DataConnection="PlayerREG" S-RecordSource="Players" U-Database-URL="../fpdb/Player_reg.mdb" U-Confirmation-Url="../testconfirm.asp" S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER" S-Builtin-DBFields="Browser_type Remote_computer_name Timestamp User_name" S-Form-Fields="grade street school position firstname hphone email lastname teamid graduate zip city state" S-Form-DBFields="grade street school position firstname hphone email lastname teamid graduate zip city state" startspan -->
            <!--webbot bot="SaveDatabase" endspan -->
                  <p align="center"><font face="Arial" size="2"><b>Player Registration
            Form <br>
            Team Challenge - Big Shot Lacrosse<br>
            July 24th - 27th, 2005</b></font></p>
                  <table border="0" width="285" height="415" style="border-collapse: collapse" cellpadding="2" cellspacing="2">
                        <tr>
                              <td height="18" width="97"><b><font size="2" face="Arial">Team Information: </font>
                              </b></td>
                              <td width="231" height="18"><b>
                    <font size="2" color="#FF0000" face="Arial">&nbsp;Look up Team ID
                    [<a target="_blank" href="Teams_Registered.asp"> click here</a> ] </font></b></td>
                        </tr>
                        <tr>
                              <td width="97" height="22">
                    <p align="right"><font size="2" face="Arial">Team ID </font></td>
                              <td width="231" height="22">
                    <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put Team ID Number" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="4" --><input type="text" name="teamid" size="8" tabindex="1" maxlength="4"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="18"><font face="Arial"><font size="2"><b>Player</b></font><b><font size="2">
                              Information: </font></b></font></td>
                              <td width="231" height="18"><b>
                    <font size="2" color="#FF0000" face="Arial">all fields required</font></b></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <p align="right"><font size="2" face="Arial">First Name: </font></td>
                              <td width="231" height="22">
                              <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put your first name" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="15" --><input type="text" name="firstname" size="12" tabindex="2" maxlength="15"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">Last Name</font></td>
                              <td width="231" height="22">
                              <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put your last name" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="20" --><input type="text" name="lastname" size="12" tabindex="3" maxlength="20"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">Street</font></td>
                              <td width="231" height="22">
                    <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put your street address" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="30" --><input type="text" name="street" size="30" tabindex="4" maxlength="30"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">Town</font></td>
                              <td width="231" height="22">
                    <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put city or town" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="20" --><input type="text" name="city" size="15" tabindex="5" maxlength="20"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">State</font></td>
                              <td width="231" height="22">
                              <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put state abbreviation" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="3" --><input type="text" name="state" size="2" tabindex="6" maxlength="3"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">Zip</font></td>
                              <td width="231" height="22">
                              <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put 5 digit zipcode" b-value-required="TRUE" i-minimum-length="5" i-maximum-length="5" --><input type="text" name="zip" size="5" tabindex="7" maxlength="5"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">Email</font></td>
                              <td width="231" height="22">
                    <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put email or type &quot;none&quot; without quotes" b-value-required="TRUE" i-minimum-length="5" i-maximum-length="45" --><input type="text" name="email" size="40" tabindex="8" maxlength="45"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">Phone</font></td>
                              <td width="231" height="22">
                              <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put home phone" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="15" --><input type="text" name="hphone" size="12" tabindex="9" maxlength="15">
                    <font size="2">e.g 412 571 2501</font></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="15" align="right">
                    <font size="2" face="Arial">School</font></td>
                              <td width="231" height="15">
                              <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please put school name" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="25" --><input type="text" name="school" size="20" tabindex="10" maxlength="25"></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">Position</font></td>
                              <td width="231" height="22">
                              <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="Please make position selection" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="position" tabindex="11">
                    <option selected value="Please select one position">Please select one position
                    </option>
                    <option value="Attack">Attack</option>
                    <option value="Midfield">Midfield</option>
                    <option value="A/M">Attack/Midfield</option>
                    <option value="D mid">D-Middie</option>
                    <option value="LSM">LSM</option>
                    <option value="Defense">Defense</option>
                    <option value="Goalie">Goalie</option>
                    </select></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="22" align="right">
                    <font size="2" face="Arial">Grade</font></td>
                              <td width="231" height="22">
                    <font face="Arial">
                    <!--webbot bot="Validation" s-display-name="please make proper grade selection" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="grade" tabindex="12">
                    <option value="Grade?">Grade?</option>
                    <option value="9">9</option>
                    <option value="10">10</option>
                    <option value="11">11</option>
                    <option value="12">12</option>
                    <option value="12+">12+</option>
                    </select><font size="2"> </font> <b><font size="2">as of
                    Sept 1, 2005</font></b></font></td>
                        </tr>
                        <tr>
                              <td width="97" height="32" align="right">
                    <font face="Arial" size="2">Year graduate)</font></td>
                              <td width="231" height="32">
                              <font size="2" face="Arial">
                    <!--webbot bot="Validation" s-display-name="Year graduating" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="graduate" tabindex="13">
                    <option>Please select year</option>
                    <option value="2005">2005</option>
                    <option value="2006">2006</option>
                    <option value="2007">2007</option>
                    <option value="2008">2008</option>
                    </select> </font></td>
                        </tr>
                        <tr>
                              <td width="97" height="32" align="right">
                    &nbsp;</td>
                              <td width="231" height="32">
            <input type="submit" value="click this button to submit your registration" name="B1" tabindex="14"></td>
                        </tr>
                        <tr>
                              <td width="97" height="32" align="right">
                    &nbsp;</td>
                              <td width="231" height="32">
                              <input type="reset" value="Reset" name="B2">&nbsp; </td>
                        </tr>
                        </table>
            <p style="margin-top: 0; margin-bottom: 0" align="center">&nbsp;</p>
            </form>
            </td>
      <td width="170" class="rightside" align="left" valign="top">
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
        <tr>
          <td width="100%" class="textboxtop2">Note - Please read this</td>
        </tr>
        <tr>
          <td width="100%" class="textbox2"><font face="Arial" size="2">Players:</font><p>
          <font face="Arial" size="2">Your coach or team representative may or
          may not have registered your team at this time.&nbsp; To check to see
          if your team is registered please use this link [ find my team ]<br>
          <br>
          If your team is not yet registered just put &quot;TBA&quot; (without quotes) in
          the team ID field.&nbsp; You may then email me [<a href="mailto:bnphillips@verizon.net?subject=Team Challenge: my team ID is">
          email </a>]<br>
          <br>
          They
                  will need to use the ID number you've entered above.</font></p>
          <p>
          <font size="2" face="Arial">If you need to make changes in your information, please contact
                  us as soon as possible at<br>
                  &nbsp;</font><font size="2"><a href="mailto:bnphillips@verizon.net?subject=Team challenge: registration changes">[
          email registration changes ]</a></font><br>
          <br>
          &nbsp;</td>
        </tr>
        <tr>
          <td width="100%">&nbsp;</td>
        </tr>
      </table>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>
      <font face="Arial" size="2">
      <img border="0" src="../../images/design_elements/spacer.gif" width="170" height="1"></font></p>
      </td>
    </tr>
  </table>
  </center></div>
<!--webbot bot="Include" U-Include="../../include_bot.htm" TAG="BODY" --></body></html>
Avatar of hhammash
hhammash
Hi bruce,

Why does the form action shows:
action="--WEBBOT-SELF--"

Change the form action to the confirmation page that you created.
Avatar of bnp6622
bnp6622

ASKER

hh,

?? my other forms have the same statement and they work.   I think it is something else.   I had copied this form from another location and it appears not to have proper code.   I will try a new form.

-bruce
Avatar of hhammash
hhammash
Create a totally new form
Avatar of bnp6622
bnp6622

ASKER

hh,

did this and it worked
-bruce
ASKER CERTIFIED SOLUTION
Avatar of hhammash
hhammash
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial