I don't understand the line I found in a sample program.
Can someone please interpret for me the line:
rs!Vfield = Vdata
It appears in the second last line of the sample code below.
Can someone please interpret for me the line:
rs!Vfield = Vdata
It appears in the second last line of the sample code below.
Code:
Sub ADOXAddRecord(Tab_name As String, Vfield As Variant, Vdata As Variant)
Dim cat As New ADOX.Catalog
Dim tbL As New ADOX.Table
Dim arData() As String
Dim x As Integer, y As Integer
Dim i, j
Dim rs As ADOdb.Recordset
Set rs = New ADOdb.Recordset
Set cat.ActiveConnection = connDB
rs.Open "SELECT * FROM " & Tab_name & " Where 1=0", connDB, adOpenStatic, adLockOptimistic
rs.AddNew
rs!Vfield = Vdata
rs.Update