Assuming you want to create a new record in an existing Access database table named “tbl_user” with fields “user_id”, “user_cat”, and “psw”, the following VBA code should do the trick:   Sub CreateUser() ' Open a connection to the Access database Dim db As DAO.Database Set db = CurrentDb() ' Create a new record in the tbl_user table Dim rs ...

Read More »