Tag Archives: Tables

Access Tables Design View

This article explains how to display Access tables in design view. – Method 1: Right click the table on the left and click on design view: Result: – Method 2: Step 1: Open the table you want to display in design view: Step 2: On either

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

VBA, Word Table Insert/Remove Rows/Columns

In this article I will explain how you can add and delete rows and columns from tables in a word document using VBA. Every word document has a Tables collection The first step in working with a table in VBA for word is to determine the

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

Modify Existing Data in Table, Access VBA Recordsets

In this article I will explain how you can modify  existing data in an Access table using the Recordset object in 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

No Thumbnail

Access, Convert User Input to Uppercase

This article explains how to convert user input to uppercase 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 uppercase. Change the format

No Thumbnail

Access Delete Tables

This article explains how to delete tables from an Access database. – Step 1: Right click on the tables tab and click on close: – Step 2: Right click the table on the left and click on Delete: See also: Access Create Table Access Tables

Delete Record, Access VBA Recordset

In this article I will explain how you can delete a record from an Access table using the Recordset object in 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

#Deleted Text in Tables, VBA Access

If you are working directly with Access tables in VBA and attempt to delete records, the records will be replaced by a #Delete text. There are 2 workarounds to fix this: Method 1: User manually updates the table Method 2: Using userforms as the user

No Thumbnail

VBA Access Table Not Updating

When modifying access table using VBA, there are times the values being displayed in the table will not update. There is no direct VBA solution to update the values the table is displaying, but there are 2 workarounds: Method 1: User manually updates the table