a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Access DB Populated Drop Down (Frontpage)

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Access DB Populated Drop Down (Frontpage) 		Page: [1]
 
dezeptus

 

Posts: 11
Joined: 9/8/2005
Status: offline

  		Access DB Populated Drop Down (Frontpage) - 9/8/2005 13:32:45   
Hello all...

I currently have a submission form that sends info to a db I have in access. I then have an editor for it (created via Frontpage wizard) that goes to the db and brings back the values for editing. What I want to do now is have certain fields on my forms (both submission and editor) to be populated by a lookup reference I have in access... example:

Access has a drop down field on a table that looks up certain values. I want these values to appear as a dropdown on my frontpage forms.. Here's a copy of my submission form. 
<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
	Err.Clear

	Set fp_conn =  Server.CreateObject("ADODB.Connection")
	FP_DumpError strErrorUrl, "Cannot create connection"

	Set fp_rs = Server.CreateObject("ADODB.Recordset")
	FP_DumpError strErrorUrl, "Cannot create record set"

	fp_conn.Open Application("Resolution_ConnectionString")
	FP_DumpError strErrorUrl, "Cannot open database"

	fp_rs.Open "resolution", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
	FP_DumpError strErrorUrl, "Cannot open record set"

	fp_rs.AddNew
	FP_DumpError strErrorUrl, "Cannot add new record set to the database"
	Dim arFormFields0(17)
	Dim arFormDBFields0(17)
	Dim arFormValues0(17)

	arFormFields0(0) = "branch"
	arFormDBFields0(0) = "branch"
	arFormValues0(0) = Request("branch")
	arFormFields0(1) = "date_received"
	arFormDBFields0(1) = "date_received"
	arFormValues0(1) = Request("date_received")
	arFormFields0(2) = "reviewed_by"
	arFormDBFields0(2) = "reviewed_by"
	arFormValues0(2) = Request("reviewed_by")
	arFormFields0(3) = "worktype"
	arFormDBFields0(3) = "worktype"
	arFormValues0(3) = Request("worktype")
	arFormFields0(4) = "client_code"
	arFormDBFields0(4) = "client_code"
	arFormValues0(4) = Request("client_code")
	arFormFields0(5) = "reject_reason"
	arFormDBFields0(5) = "reject_reason"
	arFormValues0(5) = Request("reject_reason")
	arFormFields0(6) = "case_number"
	arFormDBFields0(6) = "case_number"
	arFormValues0(6) = Request("case_number")
	arFormFields0(7) = "date_completed"
	arFormDBFields0(7) = "date_completed"
	arFormValues0(7) = Request("date_completed")
	arFormFields0(8) = "resolution_specialist"
	arFormDBFields0(8) = "resolution_specialist"
	arFormValues0(8) = Request("resolution_specialist")
	arFormFields0(9) = "date_created"
	arFormDBFields0(9) = "date_created"
	arFormValues0(9) = Request("date_created")
	arFormFields0(10) = "submitted_by"
	arFormDBFields0(10) = "submitted_by"
	arFormValues0(10) = Request("submitted_by")
	arFormFields0(11) = "reject_number"
	arFormDBFields0(11) = "reject_number"
	arFormValues0(11) = Request("reject_number")
	arFormFields0(12) = "auditor"
	arFormDBFields0(12) = "auditor"
	arFormValues0(12) = Request("auditor")
	arFormFields0(13) = "audit_reject_code"
	arFormDBFields0(13) = "audit_reject_code"
	arFormValues0(13) = Request("audit_reject_code")
	arFormFields0(14) = "closed_unresolved"
	arFormDBFields0(14) = "closed_unresolved"
	arFormValues0(14) = Request("closed_unresolved")
	arFormFields0(15) = "reject_date"
	arFormDBFields0(15) = "reject_date"
	arFormValues0(15) = Request("reject_date")
	arFormFields0(16) = "client_turnaround"
	arFormDBFields0(16) = "client_turnaround"
	arFormValues0(16) = Request("client_turnaround")

	FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0


	fp_rs.Update
	FP_DumpError strErrorUrl, "Cannot update the database"

	fp_rs.Close
	fp_conn.Close

	FP_FormConfirmation "text/html; charset=windows-1252",_
						"Form Confirmation",_
						"Thank you for submitting the following information:",_
						"submission_form.asp",_
						"Return to the form."

End If
End If

%>


<% Response.Buffer = True %>
<!--#include File='Login_Check.asp'-->
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Submission Form</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<HEAD>

<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
// Check browser version
var isNav4 = false, isNav5 = false, isIE4 = false
var strSeperator = "/"; 
// If you are using any Java validation on the back side you will want to use the / because 
// Java date validations do not recognize the dash as a valid date separator.
var vDateType = 3; // Global value for type of date format
//                1 = mm/dd/yyyy
//                2 = yyyy/dd/mm  (Unable to do date check at this time)
//                3 = dd/mm/yyyy
var vYearType = 4; //Set to 2 or 4 for number of digits in the year for Netscape
var vYearLength = 2; // Set to 4 if you want to force the user to enter 4 digits for the year before validating.
var err = 0; // Set the error code to a default of zero
if(navigator.appName == "Netscape") {
if (navigator.appVersion < "5") {
isNav4 = true;
isNav5 = false;
}
else
if (navigator.appVersion > "4") {
isNav4 = false;
isNav5 = true;
   }
}
else {
isIE4 = true;
}
function DateFormat(vDateName, vDateValue, e, dateCheck, dateType) {
vDateType = dateType;
// vDateName = object name
// vDateValue = value in the field being checked
// e = event
// dateCheck 
// True  = Verify that the vDateValue is a valid date
// False = Format values being entered into vDateValue only
// vDateType
// 1 = mm/dd/yyyy
// 2 = yyyy/mm/dd
// 3 = dd/mm/yyyy
//Enter a tilde sign for the first number and you can check the variable information.
if (vDateValue == "~") {
alert("AppVersion = "+navigator.appVersion+" \nNav. 4 Version = "+isNav4+" \nNav. 5 Version = "+isNav5+" \nIE Version = "+isIE4+" \nYear Type = "+vYearType+" \nDate Type = "+vDateType+" \nSeparator = "+strSeperator);
vDateName.value = "";
vDateName.focus();
return true;
}
var whichCode = (window.Event) ? e.which : e.keyCode;
// Check to see if a seperator is already present.
// bypass the date if a seperator is present and the length greater than 8
if (vDateValue.length > 8 && isNav4) {
if ((vDateValue.indexOf("-") >= 1) || (vDateValue.indexOf("/") >= 1))
return true;
}
//Eliminate all the ASCII codes that are not valid
var alphaCheck = " abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ/-";
if (alphaCheck.indexOf(vDateValue) >= 1) {
if (isNav4) {
vDateName.value = "";
vDateName.focus();
vDateName.select();
return false;
}
else {
vDateName.value = vDateName.value.substr(0, (vDateValue.length-1));
return false;
   }
}
if (whichCode == 8) //Ignore the Netscape value for backspace. IE has no value
return false;
else {
//Create numeric string values for 0123456789/
//The codes provided include both keyboard and keypad values
var strCheck = '47,48,49,50,51,52,53,54,55,56,57,58,59,95,96,97,98,99,100,101,102,103,104,105';
if (strCheck.indexOf(whichCode) != -1) {
if (isNav4) {
if (((vDateValue.length < 6 && dateCheck) || (vDateValue.length == 7 && dateCheck)) && (vDateValue.length >=1)) {
alert("Invalid Date\nPlease Re-Enter");
vDateName.value = "";
vDateName.focus();
vDateName.select();
return false;
}
if (vDateValue.length == 6 && dateCheck) {
var mDay = vDateName.value.substr(2,2);
var mMonth = vDateName.value.substr(0,2);
var mYear = vDateName.value.substr(4,4)
//Turn a two digit year into a 4 digit year
if (mYear.length == 2 && vYearType == 4) {
var mToday = new Date();
//If the year is greater than 30 years from now use 19, otherwise use 20
var checkYear = mToday.getFullYear() + 30; 
var mCheckYear = '20' + mYear;
if (mCheckYear >= checkYear)
mYear = '19' + mYear;
else
mYear = '20' + mYear;
}
var vDateValueCheck = mMonth+strSeperator+mDay+strSeperator+mYear;
if (!dateValid(vDateValueCheck)) {
alert("Invalid Date\nPlease Re-Enter");
vDateName.value = "";
vDateName.focus();
vDateName.select();
return false;
}
return true;
}
else {
// Reformat the date for validation and set date type to a 1
if (vDateValue.length >= 8  && dateCheck) {
if (vDateType == 1) // mmddyyyy
{
var mDay = vDateName.value.substr(2,2);
var mMonth = vDateName.value.substr(0,2);
var mYear = vDateName.value.substr(4,4)
vDateName.value = mMonth+strSeperator+mDay+strSeperator+mYear;
}
if (vDateType == 2) // yyyymmdd
{
var mYear = vDateName.value.substr(0,4)
var mMonth = vDateName.value.substr(4,2);
var mDay = vDateName.value.substr(6,2);
vDateName.value = mYear+strSeperator+mMonth+strSeperator+mDay;
}
if (vDateType == 3) // ddmmyyyy
{
var mMonth = vDateName.value.substr(2,2);
var mDay = vDateName.value.substr(0,2);
var mYear = vDateName.value.substr(4,4)
vDateName.value = mDay+strSeperator+mMonth+strSeperator+mYear;
}
//Create a temporary variable for storing the DateType and change
//the DateType to a 1 for validation.
var vDateTypeTemp = vDateType;
vDateType = 1;
var vDateValueCheck = mMonth+strSeperator+mDay+strSeperator+mYear;
if (!dateValid(vDateValueCheck)) {
alert("Invalid Date\nPlease Re-Enter");
vDateType = vDateTypeTemp;
vDateName.value = "";
vDateName.focus();
vDateName.select();
return false;
}
vDateType = vDateTypeTemp;
return true;
}
else {
if (((vDateValue.length < 8 && dateCheck) || (vDateValue.length == 9 && dateCheck)) && (vDateValue.length >=1)) {
alert("Invalid Date\nPlease Re-Enter");
vDateName.value = "";
vDateName.focus();
vDateName.select();
return false;
         }
      }
   }
}
else {
// Non isNav Check
if (((vDateValue.length < 8 && dateCheck) || (vDateValue.length == 9 && dateCheck)) && (vDateValue.length >=1)) {
alert("Invalid Date\nPlease Re-Enter");
vDateName.value = "";
vDateName.focus();
return true;
}
// Reformat date to format that can be validated. mm/dd/yyyy
if (vDateValue.length >= 8 && dateCheck) {
// Additional date formats can be entered here and parsed out to
// a valid date format that the validation routine will recognize.
if (vDateType == 1) // mm/dd/yyyy
{
var mMonth = vDateName.value.substr(0,2);
var mDay = vDateName.value.substr(3,2);
var mYear = vDateName.value.substr(6,4)
}
if (vDateType == 2) // yyyy/mm/dd
{
var mYear = vDateName.value.substr(0,4)
var mMonth = vDateName.value.substr(5,2);
var mDay = vDateName.value.substr(8,2);
}
if (vDateType == 3) // dd/mm/yyyy
{
var mDay = vDateName.value.substr(0,2);
var mMonth = vDateName.value.substr(3,2);
var mYear = vDateName.value.substr(6,4)
}
if (vYearLength == 4) {
if (mYear.length < 4) {
alert("Invalid Date\nPlease Re-Enter");
vDateName.value = "";
vDateName.focus();
return true;
   }
}
// Create temp. variable for storing the current vDateType
var vDateTypeTemp = vDateType;
// Change vDateType to a 1 for standard date format for validation
// Type will be changed back when validation is completed.
vDateType = 1;
// Store reformatted date to new variable for validation.
var vDateValueCheck = mMonth+strSeperator+mDay+strSeperator+mYear;
if (mYear.length == 2 && vYearType == 4 && dateCheck) {
//Turn a two digit year into a 4 digit year
var mToday = new Date();
//If the year is greater than 30 years from now use 19, otherwise use 20
var checkYear = mToday.getFullYear() + 30; 
var mCheckYear = '20' + mYear;
if (mCheckYear >= checkYear)
mYear = '19' + mYear;
else
mYear = '20' + mYear;
vDateValueCheck = mMonth+strSeperator+mDay+strSeperator+mYear;
// Store the new value back to the field.  This function will
// not work with date type of 2 since the year is entered first.
if (vDateTypeTemp == 1) // mm/dd/yyyy
vDateName.value = mMonth+strSeperator+mDay+strSeperator+mYear;
if (vDateTypeTemp == 3) // dd/mm/yyyy
vDateName.value = mDay+strSeperator+mMonth+strSeperator+mYear;
} 
if (!dateValid(vDateValueCheck)) {
alert("Invalid Date\nPlease Re-Enter");
vDateType = vDateTypeTemp;
vDateName.value = "";
vDateName.focus();
return true;
}
vDateType = vDateTypeTemp;
return true;
}
else {
if (vDateType == 1) {
if (vDateValue.length == 2) {
vDateName.value = vDateValue+strSeperator;
}
if (vDateValue.length == 5) {
vDateName.value = vDateValue+strSeperator;
   }
}
if (vDateType == 2) {
if (vDateValue.length == 4) {
vDateName.value = vDateValue+strSeperator;
}
if (vDateValue.length == 7) {
vDateName.value = vDateValue+strSeperator;
   }
} 
if (vDateType == 3) {
if (vDateValue.length == 2) {
vDateName.value = vDateValue+strSeperator;
}
if (vDateValue.length == 5) {
vDateName.value = vDateValue+strSeperator;
   }
}
return true;
   }
}
if (vDateValue.length == 10&& dateCheck) {
if (!dateValid(vDateName)) {
// Un-comment the next line of code for debugging the dateValid() function error messages
//alert(err);  
alert("Invalid Date\nPlease Re-Enter");
vDateName.focus();
vDateName.select();
   }
}
return false;
}
else {
// If the value is not in the string return the string minus the last
// key entered.
if (isNav4) {
vDateName.value = "";
vDateName.focus();
vDateName.select();
return false;
}
else
{
vDateName.value = vDateName.value.substr(0, (vDateValue.length-1));
return false;
         }
      }
   }
}
function dateValid(objName) {
var strDate;
var strDateArray;
var strDay;
var strMonth;
var strYear;
var intday;
var intMonth;
var intYear;
var booFound = false;
var datefield = objName;
var strSeparatorArray = new Array("-"," ","/",".");
var intElementNr;
// var err = 0;
var strMonthArray = new Array(12);
strMonthArray[0] = "Jan";
strMonthArray[1] = "Feb";
strMonthArray[2] = "Mar";
strMonthArray[3] = "Apr";
strMonthArray[4] = "May";
strMonthArray[5] = "Jun";
strMonthArray[6] = "Jul";
strMonthArray[7] = "Aug";
strMonthArray[8] = "Sep";
strMonthArray[9] = "Oct";
strMonthArray[10] = "Nov";
strMonthArray[11] = "Dec";
//strDate = datefield.value;
strDate = objName;
if (strDate.length < 1) {
return true;
}
for (intElementNr = 0; intElementNr < strSeparatorArray.length; intElementNr++) {
if (strDate.indexOf(strSeparatorArray[intElementNr]) != -1) {
strDateArray = strDate.split(strSeparatorArray[intElementNr]);
if (strDateArray.length != 3) {
err = 1;
return false;
}
else {
strDay = strDateArray[0];
strMonth = strDateArray[1];
strYear = strDateArray[2];
}
booFound = true;
   }
}
if (booFound == false) {
if (strDate.length>5) {
strDay = strDate.substr(0, 2);
strMonth = strDate.substr(2, 2);
strYear = strDate.substr(4);
   }
}
//Adjustment for short years entered
if (strYear.length == 2) {
strYear = '20' + strYear;
}
strTemp = strDay;
strDay = strMonth;
strMonth = strTemp;
intday = parseInt(strDay, 10);
if (isNaN(intday)) {
err = 2;
return false;
}
intMonth = parseInt(strMonth, 10);
if (isNaN(intMonth)) {
for (i = 0;i<12;i++) {
if (strMonth.toUpperCase() == strMonthArray.toUpperCase()) {
intMonth = i+1;
strMonth = strMonthArray;
i = 12;
   }
}
if (isNaN(intMonth)) {
err = 3;
return false;
   }
}
intYear = parseInt(strYear, 10);
if (isNaN(intYear)) {
err = 4;
return false;
}
if (intMonth>12 || intMonth<1) {
err = 5;
return false;
}
if ((intMonth == 1 || intMonth == 3 || intMonth == 5 || intMonth == 7 || intMonth == 8 || intMonth == 10 || intMonth == 12) && (intday > 31 || intday < 1)) {
err = 6;
return false;
}
if ((intMonth == 4 || intMonth == 6 || intMonth == 9 || intMonth == 11) && (intday > 30 || intday < 1)) {
err = 7;
return false;
}
if (intMonth == 2) {
if (intday < 1) {
err = 8;
return false;
}
if (LeapYear(intYear) == true) {
if (intday > 29) {
err = 9;
return false;
   }
}
else {
if (intday > 28) {
err = 10;
return false;
      }
   }
}
return true;
}
function LeapYear(intYear) {
if (intYear % 100 == 0) {
if (intYear % 400 == 0) { return true; }
}
else {
if ((intYear % 4) == 0) { return true; }
}
return false;
}
//  End -->
</script>

</head>

<body bgcolor="#FFFFFF" background="../Images/reso800600bmp.jpg" 

<table width="100%" align=left>
  <tr>
    <td width="15%">

<table width="100%" align=left style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
  <tr>
    <td width="50%">
	  <b><font face="Verdana" size="1">Submission Form</font></b></td>
    <td width="50%" align=right>
      <table align="right">
        <tr>
          <td>
		<p align="left"><font face="Verdana" size="1">
		<a href="querieshome.asp">Queries</a> | 
Submission Form
 | <a target="_top" href="database_editor.asp">Database Editor</a> </font> 

          </td>
        </tr>
      </table>
	</td>
  </tr>
</table>


	</td>
  </tr>
</table>


<p align="left">
<font face="Verdana" size="1">
<br clear="all">
</font>
<hr align="left">
<p align="left">

  <form METHOD="POST" action="--WEBBOT-SELF--" onsubmit="return FrontPage_Form1_Validator(this)" name="FrontPage_Form1">

<!--webbot bot="SaveDatabase" suggestedext="asp" u-asp-include-url="../../_fpclass/fpdbform.inc" s-dataconnection="Resolution" s-recordsource="resolution" u-database-url="../../fpdb/submission_form.mdb" s-form-fields="branch date_received reviewed_by worktype client_code reject_reason case_number date_completed resolution_specialist date_created submitted_by reject_number auditor audit_reject_code closed_unresolved reject_date client_turnaround" s-form-dbfields="branch date_received reviewed_by worktype client_code reject_reason case_number date_completed resolution_specialist date_created submitted_by reject_number auditor audit_reject_code closed_unresolved reject_date client_turnaround" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="43152" --><font face="Verdana" size="1">
</font>

<p align="left"><b><font size="1" face="Verdana"><br>
</font><font size="1" face="Verdana" style="font-size: 8pt"> <br>
</font></b>
</p>

<div align="center">
  <center>
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
    <tr>
      <td width="15%"><font size="1" face="Verdana">Work Type </font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <!--webbot bot="Validation" s-display-name="Worktype" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="worktype">	
<option> </option>
	<option>ADD/TERM JUR</option>
	<option>AMEND/EXCEPT</option>
	<option>BANK CHANGES</option>
	<option>REACTIVATE/REINSTATE</option>
	<option>TRACER</option>
	<option>YEAR END</option>
	<option>RERUN/ADJ</option>
</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Case 
Number</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <!--webbot bot="Validation" s-display-name="case number" s-data-type="String" b-allow-digits="TRUE" s-allow-other-chars="-" b-value-required="TRUE" i-minimum-length="13" i-maximum-length="13" --><input name="case_number" size="20" value="" maxlength="13"></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Branch</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <!--webbot bot="Validation" s-display-name="Branch" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="branch">	
<option> </option>
	<option>10</option>
<option>16</option>
</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font size="1" face="Verdana">Client Code</font><b><font size="1" face="Verdana"> </font></b>
      </td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <!--webbot bot="Validation" s-display-name="Client Code" s-data-type="String" b-value-required="TRUE" i-minimum-length="3" i-maximum-length="3" --><input name="client_code" size="8" value="" maxlength="3" onChange="javascript:this.value=this.value.toUpperCase();"></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Date Case Created</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <!--webbot bot="Validation" s-display-name="Date case created" s-data-type="String" b-value-required="TRUE" i-minimum-length="9" i-maximum-length="10" --><input name="date_created" size='10' maxlength="10" onFocus="javascript:vDateType='1'" onKeyUp="DateFormat(this,this.value,event,false,'1')" onBlur="DateFormat(this,this.value,event,true,'1')"></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Submitted 
By</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <!--webbot bot="Validation" s-display-name="Submitted by" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="submitted_by">	
<option> </option>
<option>ABRAHAM AWAD</option>
<option>ADAM HARVEY</option>
<option>ANGELA BAKER</option>
<option>ANGELA GARCIA</option>
<option>ANGELA MORENO</option>
<option>ANGELA WESTON</option>

</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font size="1" face="Verdana">Date Received</font><b><font size="1" face="Verdana"> </font></b>
      </td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="9" i-maximum-length="10" --><input name="date_received" size='10' maxlength="10" onFocus="javascript:vDateType='1'" onKeyUp="DateFormat(this,this.value,event,false,'1')" onBlur="DateFormat(this,this.value,event,true,'1')"></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Reviewed 
By</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <select size="1" name="reviewed_by">	
<option> </option>
	<option>BRENDA AGUILAR</option>
	<option>TAMMY MUSSER</option>
	<option>JOY GILL</option>
	<option>MARTHA TISCARENO</option>
	<option>JULIAN CORREA</option>
	<option>LUSSANDRA WESLEY</option>
	<option>THERESA SEBBEN</option>
	<option>SYLVIA JACQUES</option>
	<option>ERNESTINA SARINANA</option>
	<option>KELLIE FRITTS</option>
<option>KENNY SOTO</option>
</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Reject 
Date  </font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <input name="reject_date" size='10' maxlength="10" onFocus="javascript:vDateType='1'" onKeyUp="DateFormat(this,this.value,event,false,'1')" onBlur="DateFormat(this,this.value,event,true,'1')"></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Reject 
Reason</font><b><font size="1" face="Verdana"> </font></b>
      </td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <select size="1" name="reject_reason">	
<option> </option>
	<option>GK1 - INCOMPLETE TEMPLATE</option>
	<option>GK2 - NO AUTHORIZATION</option>
	<option>GK3 - PAPERWORK NOT SENT</option>
	<option>GK4 - INVALID REQUESTS</option>
	<option>GK5 - NON RESOLUTION WORK TYPE</option>
	<option>GK6 - INCONSISTANT INFO</option>
	<option>GK7 - MISSING INFO</option>
	<option>GK8 - INCORRECT TEMPLATE</option>
	<option>GK9 - CURRENT QTR NOT UPDATED</option>
</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Reject Number</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <select size="1" name="reject_number">	
<option> </option>
	<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Resolution 
Specialist</font><b><font size="1" face="Verdana"> </font></b>
      </td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <select size="1" name="resolution_specialist">	
<option> </option>
<option>ABRAHAM AWAD</option>
<option>ADAM HARVEY</option>
<option>ANGELA BAKER</option>
<option>ANGELA GARCIA</option>
<option>ANGELA MORENO</option>
<option>ANGELA WESTON</option>

</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Auditor</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <select size="1" name="auditor">	
<option> </option>
	<option>BRENDA AGUILAR</option>
	<option>TAMMY MUSSER</option>
	<option>JOY GILL</option>
	<option>MARTHA TISCARENO</option>
	<option>JULIAN CORREA</option>
	<option>LUSSANDRA WESLEY</option>
	<option>THERESA SEBBEN</option>
	<option>SYLVIA JACQUES</option>
	<option>ERNESTINA SARINANA</option>
<option>KENNY SOTO</option>
</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font size="1" face="Verdana">Audit Reject Code</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <select size="1" name="audit_reject_code">	
<option> </option>
	<option>FU1 - DIDNT FOLLOW INSTRUCTIONS</option>
	<option>FU2 - LACKING OUTCOME VERIFICATION</option>
	<option>FU3 - INCOMPLETE PAPERWORK</option>
	<option>FU4 - MISSING STEPS - BILLING</option>
	<option>FU5 - MISSING STEPS - BANKING</option>
	<option>FU6 - MISSING STEPS - TAX</option>
	<option>FU7 - MISSING STEPS - COMP OPS</option>
	<option>FU8 - MISSING STEPS - AS400</option>
</select></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Date Completed </font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <input name="date_completed" size='10' maxlength="10" onFocus="javascript:vDateType='1'" onKeyUp="DateFormat(this,this.value,event,false,'1')" onBlur="DateFormat(this,this.value,event,true,'1')"></font></b></td>
    </tr>
    <tr>
      <td width="15%"><font face="Verdana" size="1">Closed/Unresolved</font></td>
      <td width="50%" align="left"><b><font size="1" face="Verdana">
      <input name="closed_unresolved" size='10' maxlength="10" onFocus="javascript:vDateType='1'" onKeyUp="DateFormat(this,this.value,event,false,'1')" onBlur="DateFormat(this,this.value,event,true,'1')"></font></b></td>
    </tr>
    <tr>
      <td width="15%"> </td>
      <td width="50%" align="left"> </td>
    </tr>
    <tr>
      <td width="15%"> </td>
      <td width="50%" align="left"><b><font size="1" face="Verdana"> </font></b></td>
    </tr>
    <tr>
      <td width="15%"><b><font size="1" face="Verdana">   </font></b>
      </td>
      <td width="50%" align="left"><b><font size="1" face="Verdana"> <input type="submit" value="    OK    "> <input type="reset" value=" Reset "></font></b></td>
    </tr>
  </table>
  </center>
</div>

</form>

</body>

</html>


And here's a copy of my Editor form.. 

<!--#include File='Login_Check.asp'-->

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>resolution -- Edit</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body bgcolor="#FFFFFF">
<p style="margin-top: -1; margin-bottom: -1">
<font face="Verdana" size="1">
<!--webbot bot="PurpleText" PREVIEW="-Important-  If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work.  If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->
</p>

<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,worktype,case_number,branch,client_code,date_created,submitted_by,date_received,reviewed_by,reject_date,reject_reason,reject_number,resolution_specialist,auditor,audit_reject_code,date_completed,closed_unresolved,turnaround_days,client_turnaround" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202" s-dataconnection="Resolution" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE" i-ListFormat="5" b-makeform="FALSE" s-RecordSource="resolution" s-displaycolumns="ID,worktype,case_number,branch,client_code,date_created,submitted_by,date_received,reviewed_by,reject_date,reject_reason,resolution_specialist,auditor,audit_reject_code,date_completed,turnaround_days,client_turnaround" s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM resolution WHERE ID = ::ID::" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="ID=0" s-NoRecordsFound="No records returned." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" Tag="BODY" BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM resolution WHERE ID = ::ID::"
fp_sDefault="ID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Resolution"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=17
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-CheckSum="28502" --> </font><form METHOD="POST" action="update.asp" onsubmit="return FrontPage_Form1_Validator(this)" name="FrontPage_Form1">
	<table BORDER=0 width="764" style="border-collapse: collapse" bordercolor="#111111">

<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Work Type:</font></b></td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana"><select size="1" name="worktype">	
<option selected value="<%=FP_FieldHTML(fp_rs,"worktype")%>"><%=FP_FieldHTML(fp_rs,"worktype")%>
</option>
<option> </option>
	<option>ADD/TERM JUR</option>
	<option>AMEND/EXCEPT</option>
	<option>BANK CHANGES</option>
	<option>REACTIVATE/REINSTATE</option>
	<option>TRACER</option>
	<option>YEAR END</option>
	<option>RERUN/ADJ</option>
</select></font></b></td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Reject Date:</font></b></td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana">
<!--webbot bot="Validation" s-display-name="reject_date" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input type="TEXT" name="reject_date" size="30" value="<%=FP_FieldHTML(fp_rs,"reject_date")%>" maxlength="255"></font></td>
</tr>
<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Case Number:</font></b></td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana">
<!--webbot bot="Validation" s-display-name="case_number" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input name="case_number" size="30" value="<%=FP_FieldHTML(fp_rs,"case_number")%>" maxlength="255"></font></td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Reject Reason:</font></b></td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana"><select size="1" name="reject_reason">	
<option selected value="<%=FP_FieldHTML(fp_rs,"reject_reason")%>"><%=FP_FieldHTML(fp_rs,"reject_reason")%>
</option>
<option> </option>
	<option>GK1 - INCOMPLETE TEMPLATE</option>
	<option>GK2 - NO AUTHORIZATION</option>
	<option>GK3 - PAPERWORK NOT SENT</option>
	<option>GK4 - INVALID REQUESTS</option>
	<option>GK5 - NON RESOLUTION WORK TYPE</option>
	<option>GK6 - INCONSISTANT INFO</option>
	<option>GK7 - MISSING INFO</option>
	<option>GK8 - INCORRECT TEMPLATE</option>
<option>GK9 - CURRENT QTR NOT UPDATED</option>
</select></font></b></td>
</tr>
<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Branch:</font></b></td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana">
<!--webbot bot="Validation" s-display-name="branch" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input type="TEXT" name="branch" size="30" value="<%=FP_FieldHTML(fp_rs,"branch")%>" maxlength="255"></font></td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font face="Verdana" size="1">Reject Number:</font></b></td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana"><select size="1" name="reject_number">	
<option selected value="<%=FP_FieldHTML(fp_rs,"reject_number")%>"><%=FP_FieldHTML(fp_rs,"reject_number")%>
</option>
<option> </option>
	<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
</select></font></b></td>
</tr>
<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Client Code:</font></b></td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana">
<!--webbot bot="Validation" s-display-name="client_code" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input type="TEXT" name="client_code" size="30" value="<%=FP_FieldHTML(fp_rs,"client_code")%>" maxlength="255"></font></td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Resolution Specialist:</font></b></td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana"><select size="1" name="resolution_specialist">	
<option selected value="<%=FP_FieldHTML(fp_rs,"resolution_specialist")%>"><%=FP_FieldHTML(fp_rs,"resolution_specialist")%>
</option>
<option> </option>
<option>ABRAHAM AWAD</option>
<option>ADAM HARVEY</option>
<option>ANGELA BAKER</option>
<option>ANGELA GARCIA</option>
<option>ANGELA MORENO</option>
<option>ANGELA WESTON</option>

</select></font></b></td>
</tr>
<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Date Created:</font></b></td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana">
<!--webbot bot="Validation" s-display-name="date_created" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input type="TEXT" name="date_created" size="30" value="<%=FP_FieldHTML(fp_rs,"date_created")%>" maxlength="255"></font></td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Auditor: </font></b></td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">
      <select size="1" name="auditor">	
<option selected value="<%=FP_FieldHTML(fp_rs,"auditor")%>"><%=FP_FieldHTML(fp_rs,"auditor")%>
</option>
<option> </option>
	<option>BRENDA AGUILAR</option>
	<option>TAMMY MUSSER</option>
	<option>JOY GILL</option>
	<option>MARTHA TISCARENO</option>
	<option>JULIAN CORREA</option>
	<option>LUSSANDRA WESLEY</option>
	<option>THERESA SEBBEN</option>
	<option>SYLVIA JACQUES</option>
	<option>ERNESTINA SARINANA</option>
	<option>KELLIE FRITTS</option>
<option>KENNY SOTO</option>
</select></font></b><font size="1" face="Verdana"> </font></td>
</tr>
<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Submitted By:</font></b></td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">
      <select size="1" name="submitted_by">	
<option selected value="<%=FP_FieldHTML(fp_rs,"submitted_by")%>"><%=FP_FieldHTML(fp_rs,"submitted_by")%>
</option>
<option> </option>
<option>ABRAHAM AWAD</option>
<option>ADAM HARVEY</option>
<option>ANGELA BAKER</option>
<option>ANGELA GARCIA</option>
<option>ANGELA MORENO</option>
<option>ANGELA WESTON</option>


</select></font></b></td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font face="Verdana"><font size="1"><b>A</b></font><b><font size="1">udit 
Reject Code:</font></b></font></td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana"><select size="1" name="audit_reject_code">	
<option selected value="<%=FP_FieldHTML(fp_rs,"audit_reject_code")%>"><%=FP_FieldHTML(fp_rs,"audit_reject_code")%>
</option>
<option> </option>
	<option>FU1 - DIDNT FOLLOW INSTRUCTIONS</option>
	<option>FU2 - LACKING OUTCOME VERIFICATION</option>
	<option>FU3 - INCOMPLETE PAPERWORK</option>
	<option>FU4 - MISSING STEPS - BILLING</option>
	<option>FU5 - MISSING STEPS - BANKING</option>
	<option>FU6 - MISSING STEPS - TAX</option>
	<option>FU7 - MISSING STEPS - COMP OPS</option>
	<option>FU8 - MISSING STEPS - AS400</option>
</select></font></b></td>
</tr>
<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Date Received:</font></b></td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana">
<!--webbot bot="Validation" s-display-name="date_received" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input name="date_received" size="30" value="<%=FP_FieldHTML(fp_rs,"date_received")%>" maxlength="255"></font></td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">
Date Completed:</font></b></td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana">
<!--webbot bot="Validation" s-display-name="date_completed" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input name="date_completed" size="30" value="<%=FP_FieldHTML(fp_rs,"date_completed")%>" maxlength="255"></font></td>
</tr>
<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana">Reviewed By:</font></b></td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font size="1" face="Verdana"><select size="1" name="reviewed_by">	
<option selected value="<%=FP_FieldHTML(fp_rs,"reviewed_by")%>"><%=FP_FieldHTML(fp_rs,"reviewed_by")%>
</option>
<option> </option>
	<option>BRENDA AGUILAR</option>
	<option>TAMMY MUSSER</option>
	<option>JOY GILL</option>
	<option>MARTHA TISCARENO</option>
	<option>JULIAN CORREA</option>
	<option>LUSSANDRA WESLEY</option>
	<option>THERESA SEBBEN</option>
	<option>SYLVIA JACQUES</option>
	<option>ERNESTINA SARINANA</option>
	<option>KELLIE FRITTS</option>
<option>KENNY SOTO</option>
</select></font></b></td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><b><font face="Verdana" size="1">
Closed/</font></b></p>
<p style="margin-top: -1; margin-bottom: -1"><b><font face="Verdana" size="1">
Unresolved:</font></b></td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana">
<!--webbot bot="Validation" s-display-name="date_created" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input name="closed_unresolved" size="30" value="<%=FP_FieldHTML(fp_rs,"closed_unresolved")%>" maxlength="255"></font></td>
</tr>
<tr>
<td width="92" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="220" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="6" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="123" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
<td width="281" valign="top">
<p style="margin-top: -1; margin-bottom: -1"> </td>
</tr>

	
	<tr>
	<td colspan="2" width="304" valign="top">
    <p style="margin-top: -1; margin-bottom: -1"><font size="1" face="Verdana"><input type="submit" value="    OK    "> <input type="reset" value=" Reset "></font></td>
	<td width="6" valign="top">
    <p style="margin-top: -1; margin-bottom: -1"> </td>
	<td width="6" valign="top">
    <p style="margin-top: -1; margin-bottom: -1"> </td>
	<td width="6" valign="top">
    <p style="margin-top: -1; margin-bottom: -1"> </td>
	<td width="123" valign="top">
    <p style="margin-top: -1; margin-bottom: -1"> </td>
	<td width="281" valign="top">
    <p style="margin-top: -1; margin-bottom: -1"> </td>
	</tr>

	</table>

	<font face="Verdana" size="1">

	<input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
    </font>
</form>

<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="65064" --><font face="Verdana" size="1">
</font>

</body>

</html>


Thanks for your help in advance.

< Message edited by dezeptus -- 9/8/2005 13:40:28 >
BeTheBall

 

Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Access DB Populated Drop Down (Frontpage) - 9/8/2005 13:43:03   
See if this helps:

http://www.frontpagewebmaster.com/m-224525/tm.htm

And welcome to OutFront!

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to dezeptus)
dezeptus

 

Posts: 11
Joined: 9/8/2005
Status: offline

  		RE: Access DB Populated Drop Down (Frontpage) - 9/8/2005 14:35:58   
Thanks for the quick response and the welcome Duane!

I tried the first part so far, the Results wizard. Now, it worked by polulating my stuff. But when I go submit, it says it goes thru, but it doesnt add the new record to my DB. In the database, I have it linked to another table with a relationship. Does this matter?

(in reply to BeTheBall)
BeTheBall

 

Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Access DB Populated Drop Down (Frontpage) - 9/8/2005 14:44:28   
Are you performing an update or inserting a new record? If inserting a new record, are you using FP's "Send to database" option? If it acts like it is submitting, i.e., you get a confirmation, then I would suspect the permissions are not set correctly on the fpdb folder. That folder must allow read, write and delete permissions to the Internet Guest Account.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to dezeptus)
dezeptus

 

Posts: 11
Joined: 9/8/2005
Status: offline

  		RE: Access DB Populated Drop Down (Frontpage) - 9/8/2005 14:47:37   
I am using FP's "send to database" option. And yes, it did give me a confirmation page and everything. Its the same form I was using before I added the results example you gave and was working fine. Actually, as soon as I removed the relationship and the lookup for the field I was using in access, it started working again. Any ideas?

Thanks in advance..

(in reply to BeTheBall)
dezeptus

 

Posts: 11
Joined: 9/8/2005
Status: offline

  		RE: Access DB Populated Drop Down (Frontpage) - 9/8/2005 17:53:08   
Also, I am using an intranet, where the database is stored in the fpdb folder. So (sorry for being such a rookie) how do I connect to this? I want anyone with access to the intranet to use it, only not everyone one has the source mapped in their cpus..

(in reply to dezeptus)
Page:   [1]
OutFront Discoveries

All Forums >> Web Development >> ASP and Database >> Access DB Populated Drop Down (Frontpage) 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2009 All Rights Reserved
  Click here to view our privacy statement.