Database Results

[Jim Wilson]

Can someone tell me how I could set focus to a text box
other than the one tha has the information for my
Database Results? I have the page so it opens with the
curser in the text bow I would like it in, but after the
database results come back from the query I need the
curser in a lower form text box on the page and I am not
sure how to do this.

Any Help
Jim W.

 

[John Cello]

Jim:

Try this:

<script language="JavaScript"><!--
document.myFormName.myTextField.focus();
//--></script>

Replace the myFormName and myTextField with the name of your form and the
name of the field you want to set the focus to.

Hope this helps

John Cello
www.johncelloconsulting.com

 

[Jim Wilson]

This is what I have tried to do, but I am not sure were I
should place it in the frontpage 2003 code. I have
placed something like this in the body onload and it is
working but after the page is updated with the query
results the curser don't move focus to the other text
box. Please help

Jim

 

[John Cello]

Jim:

Guess the where would have been helpful. Put it just before the closing body
tag:
<script language="JavaScript"><!--
document.myFormName.myTextField.focus();
//--></script>
</body>

This works with a DRW, FP2003, XP Pro hitting an Access 2003 database in
both IE6 and Firefox.

Hope this helps.

 

[Jim Wilson]

This works good, but it will not work with an onload in
the body tag to set focus to the result query text box.
Any help

Jim

 

[John Cello]

Could you paste your page code in here, or give me a link to the page (if its
on the net). If I can look at it I can save us a good bit of back and forth.

Thanks

 

[jim wilson]

this is the code of the two form on one page.

<%
' 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
("RepairTags_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open "TblRepairTag", 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(13)
Dim arFormDBFields0(13)
Dim arFormValues0(13)

arFormFields0(0) = "CatalogNbr"
arFormDBFields0(0) = "CatalogNbr"
arFormValues0(0) = Request("CatalogNbr")
arFormFields0(1) = "PartNbr"
arFormDBFields0(1) = "PartNbr"
arFormValues0(1) = Request("PartNbr")
arFormFields0(2) = "OBFType"
arFormDBFields0(2) = "OBFType"
arFormValues0(2) = Request("OBFType")
arFormFields0(3) = "Problem"
arFormDBFields0(3) = "Problem"
arFormValues0(3) = Request("Problem")
arFormFields0(4) = "TagNbr"
arFormDBFields0(4) = "TagNbr"
arFormValues0(4) = Request("TagNbr")
arFormFields0(5) = "TagType"
arFormDBFields0(5) = "TagType"
arFormValues0(5) = Request("TagType")
arFormFields0(6) = "StagedDate"
arFormDBFields0(6) = "StagedDate"
arFormValues0(6) = Request("StagedDate")
arFormFields0(7) = "CustomerCMF"
arFormDBFields0(7) = "CustomerCMF"
arFormValues0(7) = Request("CustomerCMF")
arFormFields0(8) = "SerialNbr"
arFormDBFields0(8) = "SerialNbr"
arFormValues0(8) = Request("SerialNbr")
arFormFields0(9) = "PONbr"
arFormDBFields0(9) = "PONbr"
arFormValues0(9) = Request("PONbr")
arFormFields0(10) = "CustomerName"
arFormDBFields0(10) = "CustomerName"
arFormValues0(10) = Request("CustomerName")
arFormFields0(11) = "CaseID"
arFormDBFields0(11) = "CaseID"
arFormValues0(11) = Request("CaseID")
arFormFields0(12) = "StagedBy"
arFormDBFields0(12) = "StagedBy"
arFormValues0(12) = Request("StagedBy")

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:",_

"StageforRepair_copy(1).asp",_
"Return
to the form."

End If
End If

%>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Lookup Tag Number/Stage</title>

</head>

<body onload="form1.TagNbr.focus();"
background="../images/bg_level3_subpage.gif">





<p><a href="RepaiTagsMenu.html"><img border="0"
src="../images/goback.gif" width="68" height="21"></a></p>
<hr color="#800000">
<table border="0" width="100%" id="table1">
<tr>
<td><i><b><font face="Arial"
size="5">Stage for Repair</font></b></i></td>
</tr>
</table>
<hr color="#800000">
<form BOTID="0" METHOD="POST" action="StageforRepair_copy
(1).asp" name = "form1">
<input type="hidden" name="fpdbr_0_PagingMove"
value=" |&lt; ">
<table BORDER="0">
<tr>

<td><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<font face="Arial">Enter
Tag&nbsp; Number:</font>&nbsp; </b></td>
<td>
<input NAME="TagNbr" VALUE="<%
=Server.HtmlEncode(Request("TagNbr"))%>" size="10"
tabindex="-1"></td>
</tr>
</table>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;
<input TYPE="submit" tabindex="-1"
name="LookupTagNumber" value="Lookup Tag
Number">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;
<input TYPE="reset" tabindex="-1" value="Reset
Form" name="ResetForm"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " startspan --><!-
-webbot bot="SaveAsASP" endspan --><table width="0%"
border="0" id="table3">
<thead>
</thead>
<tbody>
<div style="display:none;">
<!--webbot bot="DatabaseRegionStart" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-
columntypes="200,200,135,200,200,200,200,200,202,200,200,2
00,200,200,200,200,135" s-dataconnection="database1" b-
tableformat="TRUE" b-menuformat="FALSE" s-
menuchoice="TagNbr" s-menuvalue="TagNbr" b-
tableborder="TRUE" b-tableexpand="TRUE" b-
tableheader="TRUE" b-listlabels="TRUE" b-
listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-
recordsource="TblRepairTagReceivingInformation" s-
displaycolumns="TagNbr,TagDateTime,CatalogNbr,SerialNbr,Ta
gType,CustomerCMF,CustomerName,CaseID,PartsRequestNbr,OBFT
ype,RepairText,Problem,PONbr" s-criteria="[TagNbr] EQ
{TagNbr} +" s-order s-sql="SELECT * FROM
TblRepairTagReceivingInformation WHERE (TagNbr
= '::TagNbr::')" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields="TagNbr=" s-
norecordsfound="No records returned." i-maxrecords="0" i-
groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc"
u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-
dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%
&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is
the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan b-
InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-
InputTypes="200" b-DataGridFormat="FALSE" b-
DGridAlternate="TRUE" sa-CritTypes="200" b-
WasTableFormat="TRUE" --><!--#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 TblRepairTagReceivingInformation
WHERE (TagNbr = '::TagNbr::')"
fp_sDefault="TagNbr="
fp_sNoRecords="<tr><td colspan=13 align=""LEFT""
width=""100%"">No records returned.</td></tr>"
fp_sDataConn="database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="TagNbr"
fp_sMenuValue="TagNbr"
fp_sColTypes="&TagNbr=200&RecEmployeeLogin=200&TagDateTime
=135&CatalogNbr=200&SerialNbr=200&TagType=200&CustomerCMF=
200&CustomerName=200&CaseID=202&PartsRequestNbr=200&OBFTyp
e=200&ShelfNbr=200&SystemNbr=200&RepairText=200&Problem=20
0&PONbr=200&LastUpdate=135&"
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-
CheckSum="55323" --><tr>

<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="TagNbr" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;TagNbr&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" s-
ColumnTypes="200,200,135,200,200,200,200,200,202,200,200,2
00,200,200,200,200,135" startspan --><%=FP_FieldVal
(fp_rs,"TagNbr")%><!--webbot bot="DatabaseResultColumn"
endspan i-CheckSum="14656" --></font></td>
<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="TagDateTime" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;TagDateTime&lt;fon
t size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"TagDateTime")%><!--
webbot bot="DatabaseResultColumn" endspan i-
CheckSum="29085" --></font></td>
<td>
<div style="display:none;">

<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="CatalogNbr" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;CatalogNbr&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"CatalogNbr")%><!--
webbot bot="DatabaseResultColumn" endspan i-
CheckSum="27243" --></font></td>
<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="SerialNbr" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;SerialNbr&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"SerialNbr")%><!--
webbot bot="DatabaseResultColumn" endspan i-
CheckSum="19352" --></font></td>
<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="TagType" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;TagType&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"

</font></td>

<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="CustomerCMF" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;CustomerCMF&lt;fon
t size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"CustomerCMF")%><!--
webbot bot="DatabaseResultColumn" endspan i-
CheckSum="25066" --></font></td>
<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="CustomerName" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;CustomerName&lt;fo
nt size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"CustomerName")%><!--
webbot bot="DatabaseResultColumn" endspan i-
CheckSum="30091" --></font></td>
<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="CaseID" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;CaseID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"

</font></td>

<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="PartsRequestNbr" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;PartsRequestNbr&lt
;font size=&quot;-
1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%
=FP_FieldVal(fp_rs,"PartsRequestNbr")%><!--webbot
bot="DatabaseResultColumn" endspan i-CheckSum="39564" --

</font></td>

<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="OBFType" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;OBFType&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"

</font></td>

<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="RepairText" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;RepairText&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"RepairText")%><!--
webbot bot="DatabaseResultColumn" endspan i-
CheckSum="30819" --></font></td>
<td>
<div style="display:none;">
<font size="1" color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="Problem" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Problem&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"

</font></td>

<td>
<div style="display:none;">
<font size="1">
<font color="#FFFFFF">
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="TagNbr,RecEmployeeLogin,TagDateTime,CatalogNb
r,SerialNbr,TagType,CustomerCMF,CustomerName,CaseID,PartsR
equestNbr,OBFType,ShelfNbr,SystemNbr,RepairText,Problem,PO
Nbr,LastUpdate" s-column="PONbr" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;PONbr&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"

</font></td>

</font><font size="2"
color="#FFFFFF">
</div>
<%SaveTagNbr = fp_rs("TagNbr")%>
<%SaveCatalogNbr = fp_rs("CatalogNbr")%>
<%SaveSerialNbr = fp_rs("SerialNbr")%>
<%SaveTagType = fp_rs("TagType")%>
<%SaveCustomerCMF = fp_rs("CustomerCMF")%>
<%SaveCustomerName = fp_rs
("CustomerName")%>
<%SaveCaseID = fp_rs("CaseID")%>
<%SavePartsRequestNbr = fp_rs
("PartsRequestNbr")%>
<%SaveOBFType = fp_rs("OBFType")%>

<%SavePONbr = fp_rs("PONbr")%>
<%StagedDate = Now()%>

<!--webbot bot="DatabaseRegionEnd" b-
tableformat="TRUE" b-menuformat="FALSE" u-
dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%
&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is
the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --

<!--#include file="../_fpclass/fpdbrgn2.inc"-->

<!--webbot bot="DatabaseRegionEnd" endspan i-
CheckSum="56926" --></font><font size="1">
</font>

</font>

</tbody>
</table></form>

<form method="POST" action="--WEBBOT-SELF--"
onsubmit="return FrontPage_Form2_Validator(this)"
name="FrontPage_Form2" language="JavaScript">
<!--webbot bot="SaveDatabase" SuggestedExt="asp"
S-DataConnection="RepairTags" S-
RecordSource="TblRepairTag" U-Database-
URL="../fpdb/RepairTagsData.mdb" S-Form-
Fields="CatalogNbr PartNbr OBFType Problem TagNbr TagType
StagedDate CustomerCMF SerialNbr PONbr CustomerName
CaseID StagedBy" S-Form-DBFields="CatalogNbr PartNbr
OBFType Problem TagNbr TagType StagedDate CustomerCMF
SerialNbr PONbr CustomerName CaseID StagedBy" startspan U-
ASP-Include-Url="../_fpclass/fpdbform.inc" --><input
TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include
file="../_fpclass/fpdbform.inc"--><!--webbot
bot="SaveDatabase" endspan i-checksum="34604" -->

<table border="0" width="100%" id="table2">
<tr>
<td width="258" align="right"
height="25">
<p align="right"><b><font
face="Arial">Tag Number:</font></b></td>
<td height="25">
<font face="Arial, Helvetica,
sans-serif">
&nbsp;<!--webbot bot="Validation"
s-display-name="Repair Tag Number" s-data-type="String" b-
allow-digits="TRUE" b-value-required="TRUE" i-minimum-
length="7" i-maximum-length="12" --><input name="TagNbr"
value="<%=SaveTagNbr%>" size="10" maxlength="12"
style="float:left" tabindex="1"></font><td
height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>

<tr>
<td height="25" width="258"
align="right"><font face="Arial"><b>
Catalog Number:&nbsp;&nbsp;
</b></font></td>
<td height="25">
<input name="CatalogNbr" value="<%
=SaveCatalogNbr%>" size="8" maxlength="12"
style="float:left" tabindex="2"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><font face="Arial"><b>
Serial Number:&nbsp;&nbsp;
</b></font></td>
<td height="25">
<input name="SerialNbr" value="<%
=SaveSerialNbr%>" size="30" maxlength="12"
style="float:left" tabindex="3">
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><font face="Arial"><b>Tag
Type:&nbsp;&nbsp; </b></font></td>
<td height="25">
<input name="TagType" value="<%
=SaveTagType%>" size="8" maxlength="12"
style="float:left" tabindex="4"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><font face="Arial"><b>Customer
CMF:&nbsp;&nbsp; </b></font></td>
<td height="25">
<input name="CustomerCMF"
value="<%=SaveCustomerCMF%>" size="12" maxlength="12"
style="float:left" tabindex="5"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><b><font face="Arial">Customer
Name:&nbsp;&nbsp; </font></b></td>
<td height="25">
<input name="CustomerName"
value="<%=SaveCustomerName%>" size="30" maxlength="12"
style="float:left" tabindex="6"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><b><font face="Arial">Case ID:&nbsp;&nbsp;
</font></b></td>
<td height="25">
<input name="CaseID" value="<%
=SaveCaseID%>" size="8" maxlength="12" style="float:left"
tabindex="7"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><b><font face="Arial">Part
Number:&nbsp;&nbsp;
</font></b></td>
<td height="25">
<input name="PartNbr" value="<%
=SavePartsRequestNbr%>" size="10" maxlength="12"
style="float:left" tabindex="8"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><b><font face="Arial">OBF Type:&nbsp;&nbsp;
</font></b></td>
<td height="25">
<input name="OBFType" value="<%
=SaveOBFType%>" size="10" maxlength="12"
style="float:left" tabindex="9"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><b><font face="Arial">Problem:&nbsp;&nbsp;
</font></b></td>
<td height="25">
<input name="Problem" value="<%
=SavePONbr%>" size="60" maxlength="12" style="float:left"
tabindex="10"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><b><font face="Arial">PO Nbr:&nbsp;&nbsp;
</font></b></td>
<td height="25">
<input name="PONbr" value="<%
=SaveSerialNbr%>" size="30" maxlength="12"
style="float:left" tabindex="11"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258" align="right"
height="25"><font face="Arial"><b>
Staged BY:</b>:</font></td>
<td height="25">
<input name="StagedBy" size="9"
maxlength="12" style="float:left" tabindex="12"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
<tr>
<td width="258"
height="25">&nbsp;</td>
<td height="25"><input
type=hidden name="StagedDate" value="<%=StagedDate%>"
size="12" maxlength="12" style="float:left"></td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
<td height="25">&nbsp;</td>
</tr>
</table>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" value="Update Staged Date"
name="UpDateStagedDate"
tabindex="13">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;
<input type="reset" value="Reset Form"
name="ResetForm" tabindex="14"></p>
</form>
<font size="24" face="Arial" style="font-family: Arial,
Helvetica, sans-serif; font-size: 9pt">

<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>

<script language="JavaScript"><!--
document.FrontPage_Form2.StagedBy.focus();
//--></script>



</body>