PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Word > Microsoft Frontpage > ASP form auto populate based upon user input

Reply
Thread Tools Rating: Thread Rating: 3 votes, 1.00 average.

ASP form auto populate based upon user input

 
 
Mike Willard
Guest
Posts: n/a
 
      16th Nov 2004
I am way new to web page design. I know what I am trying to
accomplish. I wish to have a form that a user will fill out for
opening trouble tickets. The user will have a dropdown to choose store
number (that is working) from an MDB file. The City, State, Address
and Phone number will all be filled in based upon a query on the
database using the store number selected from the dropdown as part of
the query. I am assuming that I will need to kick the data to another
form and display that form to the user so they input other data before
submitting which will email to the help desk. I am assuming that I
will use onchange from the storenumber dropdown. Anyway I am really
struggling. I want the first form and the second form to look exactly
the same except the second one will have data filled in based upon the
choice from the dropdown box, and it will have a submit button on the
bottom of the form. Attached is the current code (reminder be kind
this is no masterpiece).

<%@ LANGUAGE="VBScript" %>

<%
' The adovbs.inc file must be in the root directory
' of your webserver for this example to work

Set oConn = Server.CreateObject("ADODB.Connection")
Set oRs = Server.CreateObject("ADODB.Recordset")
oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=d:\inetpub\wwwroot\bbros\call.mdb"

strSQL = "SELECT * FROM STORE"

oRs.Open strSQL, oConn, 3, 3

WHILE NOT oRs.EOF

' Change the 2 to a 1 to change the default option selected

IF oRs("store_num") = 1 THEN
strStore_num = strStore_num & "<option selected value=" &
oRs("city") & ">" & oRs("store_num") & "</option>"
ELSE
strStore_num = strStore_num & "<option value=" & oRs("city") & ">"
& oRs("store_num") & "</option>"

END IF

IF oRs("City") = "Lufkin" THEN
strCity = strCity & "<option selected value=" & oRs("store_num") &
">" & oRS("city") & "</option>"
ELSE
strCity = strCity & "<option value=" & oRs("store_num") & ">" &
oRs("city") & "</option>"

END IF

oRs.MoveNext

WEND

oRs.Close
oConn.Close

%>


<html>
<head>

<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Trouble Ticket</title>

</head>

<body>

<form method="POST" action="call.asp" name="BbrosTrouble">
<table border="1" width="640" id="table1" height="480"
bordercolor="#000000" bgcolor="#C0C0C0">
<tr>
<td colspan="8"><b><font face="Tahoma" size="1">
<img border="0" src="../graphics/bclogo1.jpg" width="168"
height="82"></font></b></td></tr><tr>
<td width="98%" colspan="8">&nbsp;</td>
</tr>
<tr>
<td width="8%"><b><font face="Tahoma"
size="1">Subject:</font></b></td><td width="89%" colspan="7"><font
face="Tahoma" size="1">
<input name="Subject" size="67" style="font-family:Tahoma;
font-size:8pt; background-color:#C0C0C0" value="Brookshire Brothers
Trouble Ticket #" </font <% =("Ticket") %>,></td></tr><tr>
<td width="97%" colspan="8">&nbsp;</td>
</tr>
<tr>
<td width="8%"><b><font face="Tahoma" size="1">Trouble Ticket
#</font></b></td><td width="26%"><font face="Tahoma" size="1">
<input name="Ticket" size="20" style="font-size:8pt;
font-family:Tahoma"></font></td><td width="12%"><b><font face="Tahoma"
size="1">Store #</font></b></td><td width="26%">
<table BORDER="0">
<tr>
<td>
<select size="1" name="Store_Num"
ONCHANGE=BbrosTrouble.submit()>
<option VALUE=<%=strStore_num%>
</option>

</td>
</tr>
</table>
<nobr>
</nobr></td><td width="6%"><b><font face="Tahoma"
size="1">City</font></b></td><td width="26%" colspan="3">
<input type="text" name="City" size="20" <option value=<%=strCity%>
</option style="font-family: Tahoma; font-size: 8pt">&nbsp;


</select></nobr></td></tr><tr>
<td width="8%"><b><font face="Tahoma"
size="1">Lane/Dept</font></b></td><td width="26%"><font face="Tahoma"
size="1">
<input name="Lane" size="20" style="font-family:Tahoma;
font-size:8pt"></font></td><td width="12%"><b><font face="Tahoma"
size="1">
Phone #</font></b></td><td width="26%">
<input NAME="Phone" SIZE="20" style="font-family: Tahoma;
font-size: 8pt"></td><td width="6%"><b><font face="Tahoma" size="1">
Address</font></b></td><td width="26%" colspan="3">
<input NAME="Street" SIZE="28" style="font-family: Tahoma;
font-size: 8pt"></td></tr><tr>
<td width="8%"><b><font face="Tahoma" size="1">Corporate
Contact</font></b></td><td width="26%"><font face="Tahoma" size="1">
<input name="Corp_contact" size="20" style="font-family:Tahoma;
font-size:8pt"></font></td><td width="12%"><b><font face="Tahoma"
size="1">Store Contact</font></b></td><td width="26%"><font
face="Tahoma" size="1">
<input name="Store_contact" size="20" style="font-family:Tahoma;
font-size:8pt"></font></td><td width="11%" colspan="2"><b><font
face="Tahoma" size="1">Priority</font></b></td><td width="11%"
colspan="2"><font face="Tahoma" size="1">
<select size="1" name="Priority" style="font-family:Tahoma;
font-size:8pt">
<option value="1">1- Priority 1 (Emergency)</option>
<option selected value="2">2- Priority 2 (Next Business Day)
</option>
<option value="3">3- Priority 3 (When in Area)</option>
</select></font></td></tr><tr>
<td width="8%"><b><font face="Tahoma" size="1">Call
Date</font></b></td><td width="26%"><font face="Tahoma" size="1">
<input name="Date" size="20" style="font-family:Tahoma;
font-size:8pt" value="<%=Date()%>"></font></td><td
width="12%"><b><font face="Tahoma" size="1">Call
Time</font></b></td><td width="26%"><font face="Tahoma" size="1">
<input name="Time" size="20" style="font-family:Tahoma;
font-size:8pt" value="<%=Time()%>"></font></td><td width="6%"><b><font
face="Tahoma" size="1">New Call</font></b></td><td width="3%">
<input type="radio" value="New_Call" checked
name="R1"></td><td width="6%">
<p align="right"><b><font face="Tahoma"
size="1">Re-Call</font></b></td><td width="15%">
<input type="radio" name="R1"
value="Re_Call"></td></tr><tr>
<td width="98%" valign="top" colspan="8">&nbsp;</td>
</tr>
<tr>
<td width="8%" valign="top"><b><font face="Tahoma" size="1">Call
Summary</font></b></td><td width="89%" colspan="7"><font
face="Tahoma" size="1">
<input name="Summary" size="67" style="font-family:Tahoma;
font-size:8pt"></font></td></tr><tr>
<td width="99%" valign="top" colspan="8">&nbsp;</td>
</tr>
<tr>
<td width="8%" valign="top"><font face="Tahoma" size="1">
<span style="vertical-align: text-top; font-weight: 700">Call
Details</span></font></td><td width="89%" colspan="7"><font
face="Tahoma" size="1">
<textarea rows="7" name="Detail" cols="65"
style="font-family:Tahoma;
font-size:8pt"></textarea></font></td></tr></table><p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p></html>

<%
conn.close
set conn = Nothing
%>
 
Reply With Quote
 
 
 
 
clintonG
Guest
Posts: n/a
 
      16th Nov 2004
Google: "pass form data"

--
<%= Clinton Gallagher, "Twice the Results -- Half the Cost"
Architectural & e-Business Consulting -- Software Development
NET (E-Mail Removed)
URL http://www.metromilwaukee.com/clintongallagher/



"Mike Willard" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am way new to web page design. I know what I am trying to
> accomplish. I wish to have a form that a user will fill out for
> opening trouble tickets. The user will have a dropdown to choose store
> number (that is working) from an MDB file. The City, State, Address
> and Phone number will all be filled in based upon a query on the
> database using the store number selected from the dropdown as part of
> the query. I am assuming that I will need to kick the data to another
> form and display that form to the user so they input other data before
> submitting which will email to the help desk. I am assuming that I
> will use onchange from the storenumber dropdown. Anyway I am really
> struggling. I want the first form and the second form to look exactly
> the same except the second one will have data filled in based upon the
> choice from the dropdown box, and it will have a submit button on the
> bottom of the form. Attached is the current code (reminder be kind
> this is no masterpiece).
>
> <%@ LANGUAGE="VBScript" %>
>
> <%
> ' The adovbs.inc file must be in the root directory
> ' of your webserver for this example to work
>
> Set oConn = Server.CreateObject("ADODB.Connection")
> Set oRs = Server.CreateObject("ADODB.Recordset")
> oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};
> DBQ=d:\inetpub\wwwroot\bbros\call.mdb"
>
> strSQL = "SELECT * FROM STORE"
>
> oRs.Open strSQL, oConn, 3, 3
>
> WHILE NOT oRs.EOF
>
> ' Change the 2 to a 1 to change the default option selected
>
> IF oRs("store_num") = 1 THEN
> strStore_num = strStore_num & "<option selected value=" &
> oRs("city") & ">" & oRs("store_num") & "</option>"
> ELSE
> strStore_num = strStore_num & "<option value=" & oRs("city") & ">"
> & oRs("store_num") & "</option>"
>
> END IF
>
> IF oRs("City") = "Lufkin" THEN
> strCity = strCity & "<option selected value=" & oRs("store_num") &
> ">" & oRS("city") & "</option>"
> ELSE
> strCity = strCity & "<option value=" & oRs("store_num") & ">" &
> oRs("city") & "</option>"
>
> END IF
>
> oRs.MoveNext
>
> WEND
>
> oRs.Close
> oConn.Close
>
> %>
>
>
> <html>
> <head>
>
> <meta http-equiv="Content-Language" content="en-us">
> <meta http-equiv="Content-Type" content="text/html;
> charset=windows-1252">
> <title>Trouble Ticket</title>
>
> </head>
>
> <body>
>
> <form method="POST" action="call.asp" name="BbrosTrouble">
> <table border="1" width="640" id="table1" height="480"
> bordercolor="#000000" bgcolor="#C0C0C0">
> <tr>
> <td colspan="8"><b><font face="Tahoma" size="1">
> <img border="0" src="../graphics/bclogo1.jpg" width="168"
> height="82"></font></b></td></tr><tr>
> <td width="98%" colspan="8">&nbsp;</td>
> </tr>
> <tr>
> <td width="8%"><b><font face="Tahoma"
> size="1">Subject:</font></b></td><td width="89%" colspan="7"><font
> face="Tahoma" size="1">
> <input name="Subject" size="67" style="font-family:Tahoma;
> font-size:8pt; background-color:#C0C0C0" value="Brookshire Brothers
> Trouble Ticket #" </font <% =("Ticket") %>,></td></tr><tr>
> <td width="97%" colspan="8">&nbsp;</td>
> </tr>
> <tr>
> <td width="8%"><b><font face="Tahoma" size="1">Trouble Ticket
> #</font></b></td><td width="26%"><font face="Tahoma" size="1">
> <input name="Ticket" size="20" style="font-size:8pt;
> font-family:Tahoma"></font></td><td width="12%"><b><font face="Tahoma"
> size="1">Store #</font></b></td><td width="26%">
> <table BORDER="0">
> <tr>
> <td>
> <select size="1" name="Store_Num"
> ONCHANGE=BbrosTrouble.submit()>
> <option VALUE=<%=strStore_num%>
> </option>
>
> </td>
> </tr>
> </table>
> <nobr>
> </nobr></td><td width="6%"><b><font face="Tahoma"
> size="1">City</font></b></td><td width="26%" colspan="3">
> <input type="text" name="City" size="20" <option value=<%=strCity%>
> </option style="font-family: Tahoma; font-size: 8pt">&nbsp;
>
>
> </select></nobr></td></tr><tr>
> <td width="8%"><b><font face="Tahoma"
> size="1">Lane/Dept</font></b></td><td width="26%"><font face="Tahoma"
> size="1">
> <input name="Lane" size="20" style="font-family:Tahoma;
> font-size:8pt"></font></td><td width="12%"><b><font face="Tahoma"
> size="1">
> Phone #</font></b></td><td width="26%">
> <input NAME="Phone" SIZE="20" style="font-family: Tahoma;
> font-size: 8pt"></td><td width="6%"><b><font face="Tahoma" size="1">
> Address</font></b></td><td width="26%" colspan="3">
> <input NAME="Street" SIZE="28" style="font-family: Tahoma;
> font-size: 8pt"></td></tr><tr>
> <td width="8%"><b><font face="Tahoma" size="1">Corporate
> Contact</font></b></td><td width="26%"><font face="Tahoma" size="1">
> <input name="Corp_contact" size="20" style="font-family:Tahoma;
> font-size:8pt"></font></td><td width="12%"><b><font face="Tahoma"
> size="1">Store Contact</font></b></td><td width="26%"><font
> face="Tahoma" size="1">
> <input name="Store_contact" size="20" style="font-family:Tahoma;
> font-size:8pt"></font></td><td width="11%" colspan="2"><b><font
> face="Tahoma" size="1">Priority</font></b></td><td width="11%"
> colspan="2"><font face="Tahoma" size="1">
> <select size="1" name="Priority" style="font-family:Tahoma;
> font-size:8pt">
> <option value="1">1- Priority 1 (Emergency)</option>
> <option selected value="2">2- Priority 2 (Next Business Day)
> </option>
> <option value="3">3- Priority 3 (When in Area)</option>
> </select></font></td></tr><tr>
> <td width="8%"><b><font face="Tahoma" size="1">Call
> Date</font></b></td><td width="26%"><font face="Tahoma" size="1">
> <input name="Date" size="20" style="font-family:Tahoma;
> font-size:8pt" value="<%=Date()%>"></font></td><td
> width="12%"><b><font face="Tahoma" size="1">Call
> Time</font></b></td><td width="26%"><font face="Tahoma" size="1">
> <input name="Time" size="20" style="font-family:Tahoma;
> font-size:8pt" value="<%=Time()%>"></font></td><td width="6%"><b><font
> face="Tahoma" size="1">New Call</font></b></td><td width="3%">
> <input type="radio" value="New_Call" checked
> name="R1"></td><td width="6%">
> <p align="right"><b><font face="Tahoma"
> size="1">Re-Call</font></b></td><td width="15%">
> <input type="radio" name="R1"
> value="Re_Call"></td></tr><tr>
> <td width="98%" valign="top" colspan="8">&nbsp;</td>
> </tr>
> <tr>
> <td width="8%" valign="top"><b><font face="Tahoma" size="1">Call
> Summary</font></b></td><td width="89%" colspan="7"><font
> face="Tahoma" size="1">
> <input name="Summary" size="67" style="font-family:Tahoma;
> font-size:8pt"></font></td></tr><tr>
> <td width="99%" valign="top" colspan="8">&nbsp;</td>
> </tr>
> <tr>
> <td width="8%" valign="top"><font face="Tahoma" size="1">
> <span style="vertical-align: text-top; font-weight: 700">Call
> Details</span></font></td><td width="89%" colspan="7"><font
> face="Tahoma" size="1">
> <textarea rows="7" name="Detail" cols="65"
> style="font-family:Tahoma;
> font-size:8pt"></textarea></font></td></tr></table><p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p>
> <p>&nbsp;</p></html>
>
> <%
> conn.close
> set conn = Nothing
> %>
 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      17th Nov 2004
You have some very mangled HTML and ASP
- your option tags are invalid
- your While / Wend needs to be within the page not the head section and can not ref vague options

Suggest you take a look at some practical samples of valid ASP like at asp101.com
- say http://asp101.com/samples/db_pulldown_linked.asp?id=3

PS remove all your inline styles from the input tags
- not globally supported and in many cases the form will not display
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Mike Willard" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| I am way new to web page design. I know what I am trying to
| accomplish. I wish to have a form that a user will fill out for
| opening trouble tickets. The user will have a dropdown to choose store
| number (that is working) from an MDB file. The City, State, Address
| and Phone number will all be filled in based upon a query on the
| database using the store number selected from the dropdown as part of
| the query. I am assuming that I will need to kick the data to another
| form and display that form to the user so they input other data before
| submitting which will email to the help desk. I am assuming that I
| will use onchange from the storenumber dropdown. Anyway I am really
| struggling. I want the first form and the second form to look exactly
| the same except the second one will have data filled in based upon the
| choice from the dropdown box, and it will have a submit button on the
| bottom of the form. Attached is the current code (reminder be kind
| this is no masterpiece).
|
| <%@ LANGUAGE="VBScript" %>
|
| <%
| ' The adovbs.inc file must be in the root directory
| ' of your webserver for this example to work
|
| Set oConn = Server.CreateObject("ADODB.Connection")
| Set oRs = Server.CreateObject("ADODB.Recordset")
| oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};
| DBQ=d:\inetpub\wwwroot\bbros\call.mdb"
|
| strSQL = "SELECT * FROM STORE"
|
| oRs.Open strSQL, oConn, 3, 3
|
| WHILE NOT oRs.EOF
|
| ' Change the 2 to a 1 to change the default option selected
|
| IF oRs("store_num") = 1 THEN
| strStore_num = strStore_num & "<option selected value=" &
| oRs("city") & ">" & oRs("store_num") & "</option>"
| ELSE
| strStore_num = strStore_num & "<option value=" & oRs("city") & ">"
| & oRs("store_num") & "</option>"
|
| END IF
|
| IF oRs("City") = "Lufkin" THEN
| strCity = strCity & "<option selected value=" & oRs("store_num") &
| ">" & oRS("city") & "</option>"
| ELSE
| strCity = strCity & "<option value=" & oRs("store_num") & ">" &
| oRs("city") & "</option>"
|
| END IF
|
| oRs.MoveNext
|
| WEND
|
| oRs.Close
| oConn.Close
|
| %>
|
|
| <html>
| <head>
|
| <meta http-equiv="Content-Language" content="en-us">
| <meta http-equiv="Content-Type" content="text/html;
| charset=windows-1252">
| <title>Trouble Ticket</title>
|
| </head>
|
| <body>
|
| <form method="POST" action="call.asp" name="BbrosTrouble">
| <table border="1" width="640" id="table1" height="480"
| bordercolor="#000000" bgcolor="#C0C0C0">
| <tr>
| <td colspan="8"><b><font face="Tahoma" size="1">
| <img border="0" src="../graphics/bclogo1.jpg" width="168"
| height="82"></font></b></td></tr><tr>
| <td width="98%" colspan="8">&nbsp;</td>
| </tr>
| <tr>
| <td width="8%"><b><font face="Tahoma"
| size="1">Subject:</font></b></td><td width="89%" colspan="7"><font
| face="Tahoma" size="1">
| <input name="Subject" size="67" style="font-family:Tahoma;
| font-size:8pt; background-color:#C0C0C0" value="Brookshire Brothers
| Trouble Ticket #" </font <% =("Ticket") %>,></td></tr><tr>
| <td width="97%" colspan="8">&nbsp;</td>
| </tr>
| <tr>
| <td width="8%"><b><font face="Tahoma" size="1">Trouble Ticket
| #</font></b></td><td width="26%"><font face="Tahoma" size="1">
| <input name="Ticket" size="20" style="font-size:8pt;
| font-family:Tahoma"></font></td><td width="12%"><b><font face="Tahoma"
| size="1">Store #</font></b></td><td width="26%">
| <table BORDER="0">
| <tr>
| <td>
| <select size="1" name="Store_Num"
| ONCHANGE=BbrosTrouble.submit()>
| <option VALUE=<%=strStore_num%>
| </option>
|
| </td>
| </tr>
| </table>
| <nobr>
| </nobr></td><td width="6%"><b><font face="Tahoma"
| size="1">City</font></b></td><td width="26%" colspan="3">
| <input type="text" name="City" size="20" <option value=<%=strCity%>
| </option style="font-family: Tahoma; font-size: 8pt">&nbsp;
|
|
| </select></nobr></td></tr><tr>
| <td width="8%"><b><font face="Tahoma"
| size="1">Lane/Dept</font></b></td><td width="26%"><font face="Tahoma"
| size="1">
| <input name="Lane" size="20" style="font-family:Tahoma;
| font-size:8pt"></font></td><td width="12%"><b><font face="Tahoma"
| size="1">
| Phone #</font></b></td><td width="26%">
| <input NAME="Phone" SIZE="20" style="font-family: Tahoma;
| font-size: 8pt"></td><td width="6%"><b><font face="Tahoma" size="1">
| Address</font></b></td><td width="26%" colspan="3">
| <input NAME="Street" SIZE="28" style="font-family: Tahoma;
| font-size: 8pt"></td></tr><tr>
| <td width="8%"><b><font face="Tahoma" size="1">Corporate
| Contact</font></b></td><td width="26%"><font face="Tahoma" size="1">
| <input name="Corp_contact" size="20" style="font-family:Tahoma;
| font-size:8pt"></font></td><td width="12%"><b><font face="Tahoma"
| size="1">Store Contact</font></b></td><td width="26%"><font
| face="Tahoma" size="1">
| <input name="Store_contact" size="20" style="font-family:Tahoma;
| font-size:8pt"></font></td><td width="11%" colspan="2"><b><font
| face="Tahoma" size="1">Priority</font></b></td><td width="11%"
| colspan="2"><font face="Tahoma" size="1">
| <select size="1" name="Priority" style="font-family:Tahoma;
| font-size:8pt">
| <option value="1">1- Priority 1 (Emergency)</option>
| <option selected value="2">2- Priority 2 (Next Business Day)
| </option>
| <option value="3">3- Priority 3 (When in Area)</option>
| </select></font></td></tr><tr>
| <td width="8%"><b><font face="Tahoma" size="1">Call
| Date</font></b></td><td width="26%"><font face="Tahoma" size="1">
| <input name="Date" size="20" style="font-family:Tahoma;
| font-size:8pt" value="<%=Date()%>"></font></td><td
| width="12%"><b><font face="Tahoma" size="1">Call
| Time</font></b></td><td width="26%"><font face="Tahoma" size="1">
| <input name="Time" size="20" style="font-family:Tahoma;
| font-size:8pt" value="<%=Time()%>"></font></td><td width="6%"><b><font
| face="Tahoma" size="1">New Call</font></b></td><td width="3%">
| <input type="radio" value="New_Call" checked
| name="R1"></td><td width="6%">
| <p align="right"><b><font face="Tahoma"
| size="1">Re-Call</font></b></td><td width="15%">
| <input type="radio" name="R1"
| value="Re_Call"></td></tr><tr>
| <td width="98%" valign="top" colspan="8">&nbsp;</td>
| </tr>
| <tr>
| <td width="8%" valign="top"><b><font face="Tahoma" size="1">Call
| Summary</font></b></td><td width="89%" colspan="7"><font
| face="Tahoma" size="1">
| <input name="Summary" size="67" style="font-family:Tahoma;
| font-size:8pt"></font></td></tr><tr>
| <td width="99%" valign="top" colspan="8">&nbsp;</td>
| </tr>
| <tr>
| <td width="8%" valign="top"><font face="Tahoma" size="1">
| <span style="vertical-align: text-top; font-weight: 700">Call
| Details</span></font></td><td width="89%" colspan="7"><font
| face="Tahoma" size="1">
| <textarea rows="7" name="Detail" cols="65"
| style="font-family:Tahoma;
| font-size:8pt"></textarea></font></td></tr></table><p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p>
| <p>&nbsp;</p></html>
|
| <%
| conn.close
| set conn = Nothing
| %>
 
Reply With Quote
 
 
 
Reply

« fp extensions | function FrontPage_Form1_Validator(this) not generated by FrontPage »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to populate a list box based on user input? =?Utf-8?B?d29ya3NmaXJlMQ==?= Microsoft Access VBA Modules 11 2nd Sep 2007 08:03 PM
Auto Populate a Field on a Form based on Certain Criteria =?Utf-8?B?SmFrZQ==?= Microsoft Access 1 30th Aug 2007 03:59 AM
Populate a form based on user input =?Utf-8?B?RHJvd25pbmcgaW4gVkIgY29kZQ==?= Microsoft Access Forms 6 26th Feb 2007 11:44 PM
Can I auto populate criteria for a query based on a form? =?Utf-8?B?R3JldGNoZW4=?= Microsoft Access Forms 7 28th Nov 2006 11:11 PM
Auto populate text box in form based on two tables =?Utf-8?B?SiBpbiBLQw==?= Microsoft Access Form Coding 0 19th May 2005 03:54 PM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 11:18 AM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top