AddNew Method Example

 

This example uses the AddNew method to create a new record with the specified name. The AddName function is required for this procedure to run.

Sub AddNewX ()

Dim dbsNorthwind As Database
Dim rstEmployees As Recordset
Dim strFirstName As String
Dim strLastName As String

Set dbsNorthwind = OpenDatabase ("Northwind. mdb ")
Set rstEmployees = _
DbsNorthwind. OpenRecordset ("Employees", dbOpenDynaset)

Get data from the user.
StrFirstName = Trim (InputBox (_
"Enter first name :"))
StrLastName = Trim (InputBox (_
"Enter last name :"))

Proceed only if the user actually entered something

For both the first and last names.
If strFirstName <> "" and strLastName <> "" Then

Call the function that adds the record.
AddName rstEmployees, strFirstName, strLastName

Show the newly added data.
With rstEmployees
Debug. Print "New record :"&! FirstName &_
""&! LastName
Delete new record because this is a demonstration.
. Delete
End

Else
Debug. Print _
"You must input a string for first and last name! "

End If

RstEmployees. Close
DbsNorthwind. Close

End Sub

Function AddName (rstTemp As Recordset ,_
StrFirst As String, strLast As String)

Adds a new record to a Recordset using the data passed
By the calling procedure. The new record is then made
The current record.
With rstTemp
. AddNew
! FirstName = strFirst
! LastName = strLast
. Update
. Bookmark =. LastModified
End

End Function