Private Sub Command1_Click() Data1.Recordset.AddNew Data1.Recordset.Fields(0) = Val(Text1.Text) Data1.Recordset.Fields(1) = Val(Text2.Text) Data1.Recordset.Fields(2) = Val(Text3.Text) Data1.Recordset.Update End Sub
with Data1 .DataBaseName="C:\My Document\Sample.MDB" .RecordSource="Person" .Refresh .Recordset.AddNew .Recordset("Name").Value="张三" .Recordset("Sex").Value=True .Recordset("Birthday").Value=#1973-01-01# .Recordset("Memo").Value=Text1.Text .Recordset.Update end with
Data1.Recordset.AddNew
Data1.Recordset.Fields(0) = Val(Text1.Text)
Data1.Recordset.Fields(1) = Val(Text2.Text)
Data1.Recordset.Fields(2) = Val(Text3.Text)
Data1.Recordset.Update
End Sub
.DataBaseName="C:\My Document\Sample.MDB"
.RecordSource="Person"
.Refresh
.Recordset.AddNew
.Recordset("Name").Value="张三"
.Recordset("Sex").Value=True
.Recordset("Birthday").Value=#1973-01-01#
.Recordset("Memo").Value=Text1.Text
.Recordset.Update
end with