that is the standard code that you get from WROX books. Actually I have read link9's FAQ, The 3 most important recordset properties faq333-618
I am just not sure how to put it all together.
I am attempting to create a menu system that will have at least the following five buttons.
FIRST PREVIOUS NEXT LAST Search by Record Number
well here is quick example:
<%
var x = rs("Myfield"
rs.MoveFirst
rs.Find "Myfield = 'something' "
If (objRecordset.BOF = True) OR (objRecordset.EOF = True) Then
MsgBox "Record not found"
End If
%>
here is a real simple example. I search for the a record starting at the first one, (1 is the defualt starting position), until the field "Myfield" is equal to 'something'. If it is not found i pop up a box saying so. Very simple and easy. Also note that this is really no faster than just performing a "Select" statement for your criteria every time, the algorithm is exactly the same.
Good luck
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.