1. Home
  2. Docs
  3. Getting Started
  4. Step by Step: Getting Started with Virtual Forms

Step by Step: Getting Started with Virtual Forms

To create new database applications (or move already created apps from one programming language to another) with Virtual Forms Framework you can use:

  • Visual Basic for Applications (like Microsoft Excel & VBA),
  • Python,
  • C#,
  • VB.NET or
  • any other programming language that supports ActiveX.

In any case, you need to install the Virtual Forms Framework on the computer where you want to create or use these database applications.

 

Step 1

Download and install the VFSetup

If you have not already, download the Virtual Forms Framework from the download section.

Extract the downloaded files into a folder on your computer.

 

VFSetupBeta2.0.0.36

 

Find the file that starts with VFSetup (for example VFSetupBeta2.0.0.36.exe) and run it.

This will install the Virtual Form Control and also the Virtual Form Designer on this computer.

 

Step 2

Create a folder with the .vf file

Create a new folder on your computer and copy in this new folder the file VFFile_Empty.vf  from the folder where you have found the VFSetup file. You can also rename this file but be sure to leave the .vf extension.

This VFFile_Empty.vf is the file that contains the definitions data, find out more here.

 

My VF Project Folder

 

Step 3

Create the data source for the data

Because the Virtual Forms are data bound forms, we need to have or create a data source for our data.

Virtual Forms are tested and compatible with this data sources:

  • MySQL databases
  • Microsoft SQL Server databases
  • Microsoft Access databases
  • Excel Workbooks

You can use any worksheet, table or view from your data source (database) for the source for your Virtual Form.

Have in mind that you can at any time add new, change or remove worksheets, tables, views or fields to your data source.

For tips and limitations when choosing a suitable data source (database) read this article.

 

Step 4

Start using Virtual Forms in your preferred programming language

How to Get Started in Microsoft Excel & VBA

In the first few articles, we will focus on different scenarios how we can open the Main Menu or a Virtual Form from within VBA. In later articles, we will focus on how to work with Main Menu, how to create Virtual Forms with Virtual Form Designer and how to respond to events that Virtual Form Control fires and how to interact with controls that are on the Virtual Forms (for example TextBoxes, Buttons, labels, grid control,…)

Here are some of the scenarios how you can get started with using Virtual Forms within Excel VBA with just a few lines of VBA code:

Getting Started: Start Main Menu with Excel Startup

 

 

Was this article helpful to you? Yes 5 No 1

How can we help?