Tag Archives: Create

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

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

Access DataSheet Forms

In this article I will explain how to create datasheet forms in access. – What is it? Datasheet forms are forms that look like an Access table (a datasheet): – How to? Step 1: Click on the Form Wizard button on the Create Ribbon: Step

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

No Thumbnail

Tekla Open API: Cast Units

This article explains how you can create cast unit using  the Tekla Open API in VB.Net. Step 1: Add reference to the Tekla.Structures.Model and the Tekla.Structures library located in the path “C:Program FilesTekla Structures20.0ntbinplugins” and manually open the tekla model. This has been covered in the article below: VB.Net

No Thumbnail

Word VBA Creating Equations

In this article I will explain how you can create equations using VBA for word. – Step 1, Getting the Text String Associated with the Equation: The first step for creating an equation in VBA for word is to determine the text string associated with

No Thumbnail

Excel VBA, Create Gradient

This article provides code snippets for creating gradients. Note the codes in this article merely create the default gradient. In order to modify the gradients please see the topics covered in the article Excel VBA, Fill Effects, Gradient Jump To: Cell Range Column Row Sheet Cell:

No Thumbnail

VBA Access Create Table

In this article I will explain how you can create a table in an access database using VBA. The code below will create a table with the name “MyTable” using Docmd.RunSQL: Sub Example() DoCmd.RunSQL (“Create Table MyTable”) End Sub  Result: Note: Attempting to create a table

VBA Add Fields to External Access Database (Automation)

In this article I will explain how you can add fields to a table in an external access database using VBA. The first step would be to connect to an external database. The article below explains how you can connect to an existing database: VBA, Open

No Thumbnail

Word VBA, Adding Caption to Images

In this article I will explain how you can add captions to images using VBA. As previously explained there are 2 types of images: Inline Floating The concept of adding caption to the two different types of images is pretty much the same. – Inline