Hi,
I need to display in my form fields the last record in my access database, which is a numerical value, then add 1 to that value.
The code i have so far is:
<%
' Name of the Accessdb being read
accessdb="form1"
' Connect to the db with a DSN-less connection
cn="DRIVER={Microsoft Access Driver (*.mdb)};"
cn=cn & "DBQ=" & server.mappath(accessdb)
' Create a server recordset object
Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorType = 3
' Select specific fields from the table the_bird
sql = "select t1004, t6103 from doc"
' Execute the sql
rs.Open sql, cn
%>
<%
rs.movelast
%>
<%= rs("t1004") %>">
<%= rs("t6103") %>">
