Scribd
Upload
3 views3 pages

Methods

The document outlines various methods for navigating and manipulating a Recordset in a database, including moving to first, next, previous, and last records, as well as editing, updating, adding, and deleting records. It also describes methods for finding records based on specified criteria and properties indicating the end and beginning of the records. Each method is accompanied by example code demonstrating its implementation.

Uploaded by

Maha Devi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views3 pages

Methods

The document outlines various methods for navigating and manipulating a Recordset in a database, including moving to first, next, previous, and last records, as well as editing, updating, adding, and deleting records. It also describes methods for finding records based on specified criteria and properties indicating the end and beginning of the records. Each method is accompanied by example code demonstrating its implementation.

Uploaded by

Maha Devi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

S.

No Methods Functions
1. MoveFirst This method moves to the first row in the
Recordset.
Private Sub cmdMoveFirst_Click()
[Link]
[Link] = [Link] ("id")
[Link] = [Link] ("name")
End Sub
2. MoveNext This method moves to the next row in the
Recordset.
Private Sub cmdMoveNext_Click()
[Link]
If [Link] Then
[Link]
[Link] = [Link]("id")
[Link] = [Link] ("name")
Else
[Link] = [Link]("id")
[Link] = [Link]("name")
End If
End Sub
3. MovePrevious This method moves to the previous row in the
Recordset.
Private Sub cmdMovePrevious_Click()
[Link]
[Link] = [Link]("id")
[Link] = [Link]("name")
End Sub
4. Movelast This method moves to the last row in the
Recordset.
Private Sub cmdMoveLast_Click()
[Link]
[Link] = [Link]("id")
[Link] = [Link]("name")
End Sub
5. Edit The user can edit the current record using Edit
method.
Private Sub cmdEdit_Click()
[Link]
End Sub
6. Update This method is used to save necessary
changes made to the record.
Private Sub cmdSave_Click()
[Link]!id = [Link]
[Link]!Name = [Link]
[Link]
MsgBox "New record added"
End Sub
7. AddNew This method can be used to create a new
record in the recordset.
Private Sub cmdAdd_Click()
[Link]
[Link] = ""
[Link] = ""
End Sub
8. Delete This method can be used to delete an existing
record in the Recordset.
Private Sub cmdDelete_Click()
[Link]
[Link]
If [Link] Then
[Link]
[Link] = [Link]("id")
[Link] = [Link]("name")
Else
[Link] = [Link]("id")
[Link] = [Link]("name")
End If
End Sub
9. FindFirst This method finds the first record satisfying
the specified criteria.
10. FindLast This method finds the last record satisfying
the specified criteria.
11. FindNext This method finds the next record satisfying
the specified criteria, searching forward from
the current record.
12. FindPrevious This method finds the previous record
satisfying the specified criteria, searching
backward from the current record.
[Link] Property
1. EOF This is True when the user moves beyond the
last record in the recordset.
2. BOF This is True when the user has moved to a
position before the first record in the
recordset

You might also like