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 Office
TYPE OF NETWORK
What is a Network? A Network comprises of two PCs that are connected to share a recourse (like printers files, folders, CDs etc.), exchange documents, or permit electronic communication. The PCs on a network might be connected through links, phone lines, radio waves, satellites, or infrared light beams. TYPE OF NETWORK This are all the type of network Personal Area ...
Read More »How to Move Archived Mail from a PST File to Office 365
Summary: When it comes to moving archived PST email to Office 365, you can choose to import the files with a few steps. However, migration may not be smooth when importing large-sized PST files to an Office 365 account. While most of the migration process may fare well, there’s a possibility that some of your email data might become corrupt ...
Read More »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 »