<%
sql= "SELECT * FROM tblitems "
set recobj = Server.CreateOb ject("ADODB.Rec ordset")
'recobj.LockTyp e=3
recobj.Open sql,connobj
%>
<td width="9%" height="1"><sel ect name = "Itemno">
<option selected ><%=recobj("ite mno")%></option>
<%
...
Paul Ouma
Last Activity: Apr 16 '07, 09:22 AM
Joined: Feb 28 '07
Location:
-
posting several transaction in a file
-
Multiple lines Transactions
Hi all
I have 3 access dbase 2000. One for Students details,one for Items and one to store the isuues of items to students.
My problem is to post several items to one student on a form. The form should search for existing Items using ItemNo, display the Item then I enter the qty. It should take me to the next line to enter the next item.
I should be able to repeat this until all items to be sold to that student are...
No activity results to display