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 ...

If you are using Microsoft access and you get an error such as the picture below you know that the source code in your form can never run. You must have discovered that other forms have their codes running but a particular form keeps giving you errors. One critical error I discovered recently while developing a database using Microsoft Access ...