How can I search for the last updated record in my Access 2003 database from VB 6, the code I'm using only returns the first record on the database.
On Error GoTo err:
Dim sql As String
Set con = New ADODB.Connection
con.CursorLocation = adUseClient
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program Filesjosoftdatabasejosoft.mdb;Persist Security Info=False"
Set rs = New ADODB.Recordset
rs.Open "Select * from [FeeBalance] where [AdmnNo] = '" & Text1.Text & "'", con, 3, 3
If rs.EOF And rs.BOF Then
MsgBox ("No Fee Balance Found in the Above Student!")
Text15.Text = rs!Amountpaid
Text17.Text = rs!balance
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!