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),
- 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.
If you have not already, download the Virtual Forms Framework from the download section.
Extract the downloaded files into a folder on your computer.
Find the file that starts with VFSetup (for example VFSetupBeta184.108.40.206.exe) and run it.
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.
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.
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: