1 Attachment(s)
How can I save input data in Access
Can anybody help me? Saving input data in access.
Written code:
Private Sub Command2_Click()
ado1DailyIncome.Recordset.Fields("Quntity") = Text2.Text
ado1DailyIncome.Recordset.Fields("Amount") = Text3.Text
ado1DailyIncome.Recordset.Fields("TQuntity") = Text17.Text
ado1DailyIncome.Recordset.Fields("TAmount") = Text18.Text
ado1DailyIncome.Recordset.Update
End Sub
Re: How can I save input data in Access
Apart from giving TextBoxes meaningful names, like Text2 rather be txtQuntity, you seem to have mastered alreadyeverything. Thr Recordset.Update method will write back to the Access database.
(And apart from using code tags when posting code.)
What seems to be your problem?
Re: How can I save input data in Access
Insert this statement before assigning text boxes values to your recordset
Code:
ado1DailyIncome.AddNew