access_input.asp

oa办公系统asp程序

<!--#include file="../title.asp"-->
<meta http-equiv="Content-Language" content="en-us">
    <form method="POST" action="rs_access.asp">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
  <tr>
    <td width="100%" align="center"><b><font size="5">PURCHASE ORDER<br>
	<select size="1" name="acceess_id">
	<%
	sql="select * from accessories"
	rs.open sql,conn,1,3
	do while not rs.eof
	%>
    <option value="<%=rs("id")%>"><%=rs("name")%></option>
    <%
    rs.movenext
    loop
    rs.close
    %>
    </select></font></b><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"  id="AutoNumber2" height="119" width="471">
      <tr>
        <td width=70 height="21">
    <span lang="zh-cn">REF NO：</span></td>
        <td width=163 height="21">
        <input type="text" name="ref_no" size="20" tabindex="1" value=""></td>
        <td width=60 height="21">Etd_Date</td>
        <td width=150 height="21">
        <input type="text" name="etd_date" size="20" tabindex="8"></td>
      </tr>
      <tr>
        <td width=61 height="11">Name：</span></td>
        <td width=163 height="11">
        <input type="text" name="name" size="20" tabindex="2"></td>
        <td width=243 height="70" rowspan="6" colspan="2">
        <textarea rows="10" name="meno" cols="29" tabindex="9">备注</textarea></td>
      </tr>
      <tr>
        <td width=61 height="13">Size：</td>
        <td width=163 height="13">
        <input type="text" name="size" size="20" tabindex="3"></td>
      </tr>
      <tr>
        <td width=61 height="10">Color：</td>
        <td width=163 height="10">
        <input type="text" name="quantity1" size="20" tabindex="5"></td>
      </tr>
      <tr>
        <td width=61 height="14">Quantity：</td>
        <td width=163 height="14">
        <input type="text" name="quantity" size="20" tabindex="5"></td>
      </tr>
      <tr>
        <td width=61 height="8">Destination：</td>
        <td width=163 height="8">
        <input type="text" name="T6" size="20" tabindex="6"></td>
      </tr>
      <tr>
        <td width=61 height="14">Unit Price：</td>
        <td width=163 height="14">
        <input type="text" name="unit_p" size="20" tabindex="7"></td>
      </tr>
      <tr>
        <td width="469" colspan="4" height="21">
        <p align="center">
        <input type="submit" value="Submit" name="B1" tabindex="10"><input type="reset" value="Reset" name="B2" tabindex="11"></td>
      </tr>
    </table>
</td>
  </tr>
</table>
   </form>