Insert Values into Table Through Form By using VBA Macros

     

  • InsertValues_into_Table_ThroughForm_By_using_VBA Macros

    •  

     

    Private Sub Cmdbutton_Click()
    Dim db As Database
    Set db = CurrentDb
    Dim rs As Recordset
    Set rs = db.OpenRecordset("Sales")
    rs.AddNew
    rs!ID = Me.ID.Value
    rs!Item = Me.Item.Value
    rs!Quantity = Me.Quantity.Value
    rs!Price = Me.Price.Value
    rs!Location = Me.Location.Value
    rs.Update
    rs.Close
    Set rs = Nothing
    Set db = Nothing
    MsgBox ("Hi Pavan Inserted Record")
    End Sub

Hi Everyone,
Welcome to Access Tutorial. In this tutorial i explained:
(i) How to insert the data into Access Database
(ii) how to extract the Data from Aceess Database to Excel
(iii) How to insert the data into Database by using FORMS by using VBA Macros.
This Tutorial provides comprehensive knowledge on the procedure how to connect\interact with Access Database. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli