What is Virtual Forms Framework

  2. Home
  4. Docs
  6. What is Virtual Forms Framework
  8. What’s new

What’s new

3.0.0.2 – in developmet

  • databases used in Test and Example Apps resets it’s data every 24 hours (changed from locking the tables from updating)

3.0.0.1 – November 2021

  • Prelaunch of version 3
  • new modern user interface design of Virtual Forms (Excel Data Entry Forms)
  • added new Database Type (4 – MariaDB-MySQL)
  • added Hosting of MariaDB-MySQL databases with 2 server locations EU – Frankfurt, USA – Dallas

2.0.0.54 

  • Added: Virtual Forms Control – code – Properties (ExcelUserformOwnerCaption) – we are giving Virtual Form control the caption of this Userform, so that it can make all the forms to be child forms of this form, so that it will be always on top and modal

2.0.0.50  

  • Added: Virtual Forms Control – Report Viewer control. Now we can create Paginated reports in Microsoft Report Builder (for SSRS) and display them in Virtual Forms control.
  • Added: Virtual Forms Control – Main Menu – added ability to add reports without coding
  • Added: Virtual Forms Control – code – Properties (SSRSReportConnectionString, SSRSReportFileName, SSRSReportParameterAdd); Methods (SSRSReportParametersClearAll, SSRSReportShow)

2.0.0.37  

  • Fix: Virtual Form Designer – when we deleted a relationship it didn’t delete the definitions for the Grid & Edit control and we were left with orphan records in the definition file.

2.0.0.36 

  • Added: Virtual Form Control added a property GridControlAllowRowResizing if set to TRUE users can manually resize the rows in Grid Control
  • Added: Virtual Form Control added a property GridControlRowHeightMin, now you can control what minimal row height should be when the Grid control is populated

2.0.0.35

  • Fix: Virtual Form Designer when scanning fields from database if the field defined size is more than 32767 we limit it to 32767

2.0.0.34 

  • Fix: Deleting record when the data source is MySQL failed error in some cases

2.0.0.33 

  • Virtual Forms control: Added internal Main Menu Form. We can call it with ShowMainMenu property of the Virtual Form control

2.0.0.32 

  • Filter: Added vertical scrollbar if we have more fields than fit on the screen

2.0.0.31 

  • Downloads: Added VFFile_Empty.vf to the “Virtual Forms Framework” folder
  • Fix: When we used the MySQL as the data source in some cases after editing or adding records the Virtual Forms control reported that there is no transaction. Fixed

2.0.0.30 

  • Downloads: Created “Blank Template Excel-MySQL v1.0.xlsm” for easier getting started if you want to connect Excel & MySQL with Virtual Forms (for example if you want to have your data in MySQL and your Frontend in Excel & VBA)
  • Removed: Desktop link that previous version created is removed. Now we don’t begin with the “Virtual Forms Designer” but we start the “Virtual Forms Designer” through code or through the Virtual Form itself.

2.0.0.28 

  • Downloads: Created Excel workbook template for easier getting started

2.0.0.27 

  • Virtual Forms control: Right mouse click on a Virtual Form opens a menu from where you can open this Virtual Form in Virtual Forms Designer, open properties of a control (Textbox or Grid control) or reorder or reposition the controls or grid rows

2.0.0.25 

  • Virtual Form Designer: Corrected an error if the datasource type was Access, if we wanted to add relationships and the Mater Table had spaces in the name (for example: ‘Order Details’)

2.0.0.24 

    • Some minor bug fixes
    • The Store is up and running and ready to get your Early Access orders of Virtual Forms Framework, with help of Avangate, our e-commerce partner that is the provider of secure digital “shopping cart” and payment processing services for many software companies worldwide.  Go to store by clicking here.
    • The Affiliate Program is also ready for you to join and earn commissions if you refer a customer. Join here.
    • The documentation slowly gets its shape and is filling up with quality material.
    • We are still working on Video tutorials which will be both detailed and educational
  • Soon you will be able to get your hands on the download (we have temporarily disabled them until we get the green light from our testers who have expressed the desire to want to test unfinished versions)

2.0.0.1 

    • The first release of new Virtual Forms Framework 2 Beta
    • Added support for Microsoft Excel 32-bit & Microsoft Excel 64-bit versions
    • Removed Virtual Forms Ribbon control
  • A new way of using the Virtual Form Control within Microsoft Excel. No more User control that you need to place on the Excel sheet. Now the control is used directly from VBA code

*************************************************************************************************

1.2.0.717 

    • changed: Virtual Form Ribbon control from now on doesn’t check if the workbook is saved or not. It leaves to the VF control to inspect and handle the VFFile
  • added: on first creation of VF control (inserting the control into the workbook) it asks if we want to select an existing or create a new VFFile (Virtual Forms definition file)

1.2.0.716 

  • minor bug fixes

1.2.0.715 

  • enhanced: Virtual Form Designer Field chooser

1.2.0.714  Test build

  • this is private test build for eliminating some errors found from some test users

1.2.0.713 

    • minor bug fixes
  • Added: error handling to adding new virtual forms in Virtual Forms Designer

1.2.0.709 

    • minor bug fixes
    • Virtual Form Ribbon – added a check function that verifies the version of Microsoft Office installed, if the version is 64-bit, then it shows a message that the current version of Virtual Forms works only with 32-bit Office environment.(For now)
  • extended: Virtual Forms Designer Beta 1.2 is functional until 30.04.2017.

1.2.0.708 

    • minor bug fixes
  • extended Beta testing till 28.02.2017.

1.2.0.707 

    • added: When creating new, or changing existing Virtual Form in Virtual Form Designer, on saving, the Designer asks if we want to add Columns to Grid control and Fields to Edit control
  • added: When creating Relationships, or changing existing, in Virtual Form Designer, on saving, the Designer asks if we want to add Columns to Grid control and Fields to Edit control

1.2.0.706 

    • fixed: error if we used a Excel Workbook as Datasource and Sheet had spaces in name
  • updated: Virtual Form Designer – new and better handling of treeview nodes clicking

1.2.0.705 

  • fixed: error while opening Virtual Form Designer (“Runtime Error 3709” & “VFile (Virtual Form File) does not exist D:\UFO\ActiveXOCX\VirtualFormDesigner.vf”)

1.2.0.704 

  • added: Relationships

1.2.0.703 

    • added: Compatibility with Visual Basic 6.0
  • minor bug fixes

1.2.0.702 

  • improved: Creating of Buttons Groups

1.2.0.701 

  • fixed: On some systems on startup of Virtual Forms Designer there was an Error: “Format of the initialization string does not conform to the OLE DB specification”. The solution was in replacing the single quotes with escaped doubles in the connection string.

Example:

ConnectionString = ….Extended Properties=’Excel 8.0;HDR=YES;’…

changed to:

ConnectionString = ….Extended Properties=”Excel 8.0;HDR=YES;”…

1.2.0.687

  • minor bug fixes

1.2.0.685 

  • added & improved: Virtual Form Designer > Creating LookUp Forms in Edit control

1.2.0.684 

  • changed: Virtual Form Designer > Virtual Forms > ‘Form caption’ on the automatic filling, if in the property ‘Master Table’ there is a sign $ it will be removed

1.2.0.682 

  • fixed: Virtual Form Designer > Tree selection bug fix

1.2.0.680 

    • added: on Edit Fields > Enabled > No – on save it will skip this field, in Excel this field contains Function (calculated expression)
    • added: Check if in your regional settings you have the same separator for Thousand and for Decimal. If yes it will display a warning  message.
  • corrected: In Edit control if decimals is set to 0 and we have in datasource decimal number it will display correctly

1.2.0.679 

    • added: on Edit Fields > Enabled > No – on save it will skip this field, in Excel this field contains Function (calculated expression)
    • added: Check if in your regional settings you have the same separator for Thousand and for Decimal. If yes it will display a warning  message.
  • corrected: In Edit control if decimals is set to 0 and we have in datasource decimal number it will display correctly

1.2.0.676

  • initial release
Was this article helpful to you? Yes No

How can we help?