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 rstEmployees As ADODB.Recordset
	Dim strCnn As String
	Dim strFirstName As String
	Dim strLastName As String

	' Assign connection string to variable.
	strCnn = "driver={SQL Server};server=srv;" & _
		"uid=sa;pwd=;database=pubs"

	' Open employee table.
	Set rstEmployees = New ADODB.Recordset
	rstEmployees.CursorType = adOpenDynamic
	rstEmployees.LockType = adLockBatchOptimistic
	rstEmployees.Open "employee", strCnn

	 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: " & !fName & _
				" " & !lName
			' Delete new record because this is a demonstration.
			.Delete
		End With

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

	rstEmployees.Close

End Sub

Function AddName(rstTemp As ADODB.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
		!fName = strFirst
		!lName = strLast
		.Update
	End With

End Function

© 1997 Microsoft Corporation. All rights reserved. Terms of Use.