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 »Microsoft Access
A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control
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 ...
Read More »