Category Archives: Access

No Thumbnail

Check If Table Exists, Access VBA

In this article I will explain how you can check if a table exists in an access database using VBA. Previously in the article below I’ve explained how you can get the name of all the Tables in an external access database using VBA: VBA

No Thumbnail

VBA Access Get Record Count

In this article I will explain how you can get the number of records in a Recordset object. This article uses the ADODB.Recordset object. In order to use this object you may need to add reference to ADODB object library. For more information on this

No Thumbnail

Access Form Design View

This article explains how to display Access forms in design view. – Method 1: Right click the form on the navigation pane and click on design view: Result: – Method 2: Step 1: Open the form you want to display in design view: Step 2: On the Home Ribbon click on

No Thumbnail

Access, Convert User Input to Lowercase

This article explains how to convert user input to Lowercase in Access. This applies to user input in Tables and Forms. – Tables: Open the table in design view: Select the field you would like its values to be converted to lowercase. Change the format to:

No Thumbnail

Access Check If Field is Null, Conditional Macro

This article explains how you can create a conditional macro that will check if the value in a field is Null or not. If the value is null, it will set the field with a default value. Consider the database below: We want to create a

No Thumbnail

First Letter Uppercase Only Access Form

This article explains how you can format the user input in an Access form so that the first character will appear as uppercase and the rest of the input will appear as lowercase, regardless of the way the user has input the data. The method explained

No Thumbnail

First Letter Uppercase Only Access Tables

This article explains how you to create a macro that will force the first letter of a field to appear as uppercase and the rest as lowercase no matter what the user inputs. Consider the table below: We want to assign a macro to this

Get Field Types in External Access Database, VBA Automation,

In this article I will explain how you can get the types of all the fields in a table in an external access database using VBA. The first step would be to connect to an external database.I’ve explained this in the article below VBA, Open Access Database From

No Thumbnail

Append Data to Table, Access VBA

In this article I will explain how you can append data to an Access table using VBA. The article uses the ADODB.Recordset object. In order to use this object you may need to add reference to ADODB object library. For more information on this topic please see the