I don't find that at all in my code. Do I have to insert your piece
somewhere? If yes, can you tell me where?
I think it's better if I send the code:
<%@ Language=VBScript %>
<% Option Explicit %>
<% Response.Buffer = True %>
<!-- #include file="adovbs.inc" -->
<html>
<body class="formpage" style="background-color: #DFDFDF" topmargin="6"
leftmargin="0" rightmargin="0" bottommargin="0">
<table width="552" border="0">
<tr>
<td align="left" valign="top" height="14" width="548"><img border="0"
src="
http://www.myweb.com/BIE/images/c1_top.GIF" width="547" height="14"></td>
</tr>
</tr>
</table>
<%
Dim Connect_String
Dim Page_Size 'variable which holds the number of records to be viewed per
page.
Dim Current_Page 'variable which keeps track of which page is the current
page.
Dim MyConn
Dim RS
Dim SQL
Dim Page_Count 'variable which stores the number of pages that can be viewed.
Dim Form
'if using SQL Server then use
Connect_String = "DSN=access;Database=f:
www.myweb.com\Data\transferdb.mdb"
'if using DSN-Less then use
Connect_String = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("webopenoptionorders430010009000")
'if using DSN then use
Connect_String = "DSN=access;Database=f:
www.myweb.com\Data\transferdb.mdb"
Page_Size = 1 'here we set the number of records viewed per page to 15.
If Request("Page")="" Then
Current_Page = 1
Else
Current_Page = CInt(Request("Page")) 'the CInt function converts the value
to an integer.
End If
Set MyConn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.RecordSet")
MyConn.Open Connect_String
RS.CursorLocation = adUseClient
RS.PageSize = Page_Size
'below change the statement to reflect your query
SQL = "SELECT * FROM webopenoptionorders430010009000"
%>
<%
RS.Open SQL, MyConn, adOpenStatic, adLockReadOnly, adCmdText
Page_Count = RS.PageCount
If 1 > Current_Page Then Current_Page = 1
If Current_Page > Page_Count Then Current_Page = Page_Count
RS.AbsolutePage = Current_Page
Do While RS.AbsolutePage = Current_Page AND Not RS.EOF
%>
<table width="552">
<tr>
<td align="left" valign="top" class="formpagetablelabel"
style="text-align: left; font-family: Tahoma; font-size: 8pt;"
width="247"> Fecha</td>
<td width="295"><input class="formpagetablefield" type="text"
style="text-align: right; font-family: Tahoma; font-size: 8pt;" name="fecha"
size="50" Value="<%=trim(rs("fecha"))%>"></td>
</tr>
***********MORE RECORDS ARE SHOWN********************
</table>
<p align="center">
<table width="552" border="0">
<%
RS.MoveNext
Loop
'clean up
RS.Close
Set RS = Nothing
MyConn.Close
Set MyConn = Nothing
Response.Write "<br>"
If Current_Page <> 1 Then
Response.Write%><form method="Post"
action="
http://www.MYWEB.com/BIE/BIEmotor/43001000-8001/43001000-9000/optionopenorders430010009000.asp?Page=<%=Current_Page
- 1 %>"style="text-align: center"><input type="submit" value="<< registro
anterior" name="btnnext" class="formpagebutton">
</form>
<%
End If
If Current_Page < Page_Count Then
Response.Write%><form method="Post"
action="
http://www.MYWEB.com/BIE/BIEmotor/43001000-8001/43001000-9000/optionopenorders430010009000.asp?Page=<%=Current_Page
+ 1 %>"style="text-align: center"><input type="submit" value="después
registro >>" name="btnnext" class="formpagebutton">
<%
End If
%>
</p></table>
</body>
</html>