1. Home
  2. Docs
  3. Virtual Forms Designer
  4. Overview of the user interface

Overview of the user interface

The topics in this section provide a brief overview of Virtual Form Designer’s user interface

 

1. Title bar

Contains information about the name of Virtual Form Designer

Version of Virtual Form Designer installed

Current opened Virtual Form Designer project file

The last character of the title bar can be *. If this character is present this means that changes have been made and not saved to Project properties (number 4 in the screenshot).

 

2. Menu bar

 

Menu Name

Menu Item

Description

File

New Project

Opens new Virtual Form Designer project. It assigns a generic name for the project “VFProject1.vfdp”

If a project was opened before the start of this action and was not saved, it will first ask whether we want to save changes to the previous project

Open Project…

Allows us to open a saved Virtual Form Designer project

Save Project

Saves changes made to the Project properties (number 4 in the screenshot)

Save Project as…

Ask for the new filename and location where to save the project. Saves changes made to the Project properties (number 4 in the screenshot)

Exit

Closes the Virtual Form Designer and if in the meanwhile the project properties have changed, asks for saving the changes

 

Menu Name

Menu Item

Description

Help

About

Opens a form with the version info about the installed Virtual Form Designer

Goto Virtual Forms webpage

Opens the homepage of the Virtual Forms (https://www.virtual-forms.com)

 

3. Toolbar

Toolbar Name

Description

New Form

Opens the wizard that helps us to Create new Virtual Form

Properties

Opens the properties of selected item in the TreeView

Refresh

Refreshes the TreeView

Collapse All

The Collapse All collapses all the TreeNode objects, which includes all the child tree nodes, that are in the TreeView control

Expand All

The Expand All expands all the TreeNode objects, which includes all the child tree nodes, that are in the TreeView control

Check Update

Checks if there is a newer version available on the Virtual-Forms.com webpage, if available, it will download and install the latest version

4. Project properties

Virtual Form Definition File:

The file name of the Virtual Form Definition File that we are using in this Virtual Form Designer Project.

New – Allows us to create a new blank Virtual Definition File in the destination we want.

Select – Allows us to select an existing Virtual Form Definition File from our computer.

More about the Virtual Form Definition File can be found here.

 

Database Type:

Choose what database type we will use in this Project:

0 – Access Database, 

1 – MSSQL,

2 – MySQL,

3 – Excel Workbook

This is important because the Virtual Form control needs to know this info so that it can properly format the internal SQL syntax.

 

Connection String:

The connection string to the database that we use in this project.

Build – Allows us to visually create the Connection String (opens a connection builder dialog)

Samples of Connection Strings:

Database Type

Connection string example

Excel

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myExcelFile.xlsm;Extended Properties=’Excel 12.0 Macro;HDR=YES;’;Persist Security Info=False

Access

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myAccessFile.mdb;Persist Security Info=False

Access with Password

Provider=Microsoft.Jet.OLEDB.4.0;User ID=admin;Data Source=C:\myAccessFile.mdb;Persist Security Info=True;Jet OLEDB:Database Password=MyPassword

MySQL

DRIVER={MySQL ODBC 5.3 Unicode Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;

MSSQL (Microsoft SQL Server)

Driver={SQL Server Native Client 11.0};Server=tcp:xxxxxxxxx.database.windows.net,1433;Database=test;[email protected];Pwd=mypass;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

 

In the Connection string examples provided you need to change this values if they are used:

Data Source=

Path to your database file (if you are using file database, extension of the file must be also entered)

User ID=

User id

Password=

or

Database Password=

Password

More about the Connection Strings can be found on this webpage.

5. Virtual Form Designer Treeview

Visual representation of the Virtual Forms and their structure. More about the Treeview can be found here.

When we first open the Virtual Form Designer the TreeView will have one node. This node represents the definition file (VFFile) that is used in the Virtual Form control.

6. Properties window of selected item in Treeview

Shows the properties of selected item in Treeview. More about the Properties of selected item in Treeview can be found here.

Was this article helpful to you? Yes 1 No

How can we help?