Tag Archives: Access

Is VBA Worth Learning? Yes, Believe it or Not

The answer to this question is undoubtedly “YES!!!” You may be thinking, “Is VBA even still a thing?” “Is it a dead programming language?” “Why should I even bother learning VBA?” Hear me out, and Iet me explain why the language is still worth learning.

Docmd.RunSQL in Access VBA

Microsoft Access is a Database Management System which helps to store and manage data, reporting using forms/queries/various other wizards. As discussed in older posts and articles, queries can be built in Microsoft Access using design view/SQL view/any available wizard. In another post I explain the

No Thumbnail

Open Google Earth Using VBA for Access. Google Earth API

This article explains how you can use VBA for Access to open google earth. Note: The google earth API will only be available if you have Google Earth installed on your computer. The first step would be to add reference to the Google Earth 1.0 Type Library. Note the

No Thumbnail

Access Startup Form

Previously in the article Open Form When Database is Opened, Access I’ve explained how you can use an “Autoexec” macro to open a certain form every time the access file is opened. In this article another method will be explained. – Step 1: Click on the File button: –

DLookUp, Access Expression Builder

This article will explain the DLookUp function used in the Access expression builder. A DLookup function is used to get the value of a particular field (for instance, a column of a table or a calculated field) from a specified set of records (for instance,

Excel VBA, Export Worksheet to Blank Access Table

In this article I will explain how you can export values from an excel worksheet to a new blank Access table. – Step 1: The first step would be to connect to an existing access database or create a new access database. In this example we

No Thumbnail

Recordset.AddNew Method VBA Access

The Recordset.AddNew method is a function used for adding records to a recordset. – Syntax: Call objRecordset.AddNew([FieldList], [Values]) objRecordset: A Recordset object. FieldList: A 1 dimensional array of the variant type. This array must contain the Field names. Values: A 1 dimensional array of the

Access Create Table

This article will explain how to create a blank table in access. – Step 1: Click on the Table or Design Table buttons on the Create Ribbon: – Step 2, Save Table: The table created in the previous step needs to be saved. This can be