Category Archives: Access

No Thumbnail

Iterate and Search for Values in a Table, Access VBA

This article will explain how to perform a search operation on an Access table using VBA. Note: A faster approach for doing searches would be to use queries. For more information on this please see the link below: Recordset Query Search , Access VBA The article

No Thumbnail

Access Create Popup Form

This article explains how to create popup forms like the one below in Access: – Step 1: Open the form in design view: – Step 2: Change the Popup property to “Yes”: See also: Open Form When Database is Opened, Access Access Form Design View

No Thumbnail

Read Data from Table, Access VBA

In this article I will explain how you can read data from an Access table using VBA. 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 topic

No Thumbnail

Access VBA, Referencing Forms

In this article I will explain how you can reference access forms using VBA. For example: Form_MyTable1.Recalc Form_MyTable1.Requery Form_MyTable1.Controls.Item (1) Form_MyTable1.Width = 45 but before this can be done the Form_MyTable1 needs to be created. This can be done by following the steps below: – Step 1: Double

No Thumbnail

VBA Access Recordset, Object Library

If you are going to be working with the Recordset object in VBA for Access, there are 2 options. Early binding Late binding In the first method we add reference to the Access Object Library, before execution. It will run faster and we will have access to the VBA editor intellisense. On the other hand

Query Dates, Access

This article will explain how to run queries on dates in an access database. It will be assumed that our database has the following data: 3 fields with the second field storing dates. – Selecting the Right Datatype: It is essential that dates are stored

Access Form, Populate TextBoxes Based On ComboBox

In this article I will explain how you can create textboxes in an Access form that will be filled based on the value selected from a combo box and a Table. The Access form has multiple textboxes and a single combo box. The user will be able

No Thumbnail

Access Forms, Fields From Multiple Tables

This article explains how you can create a form which gets its data from multiple tables. Note that access forms can only get data from one table or query. Attempting to use expressions that reference fields from multiple table will result in the #Name? error. A workaround

No Thumbnail

Access DateSerial()

The DateSerial() function receives as input a year, month and day. It returns a date value. This function can be used to create date values to use in the criteria section of queries. – Syntax: DateSerial(Year, Month, Day) – Example: See also: Query Dates, Access Query

Access VBA, Import Excel Worksheet to Blank Table

In this article I will explain how you can import values from an excel worksheet to a new blank table in Access using VBA. – DoCmd.TransferSpreadsheet: The values are imported using the DoCmd.TransferSpreadsheet Method: Syntax: Call DoCmd.TransferSpreadsheet(TransferType, SpreadSheetType, TableName, Filename, HasFieldNames, Range) TransferType: The type of transfer