Easier way to handle database apps creation with EXCEL (simple and error free)

[dageci]

Hello guys,

History
Years ago we had the challenge while building and maintaining dozens of applications with hundreds of CRUD (create, read, update and delete) Mater-Detail database forms and nonbound forms for creating parameters for reports or getting parameters for some kind of processing.
It’s not a problem when you have few forms, but when the app grows and the number of forms increases, men, then it gets messy.

This is how the Virtual Forms project was born.

So we decided to create a ActiveX control which will handle the 95% of all our database operations and for other 5% we would use the standard manual process.
The main challenges are:
* create forms without repetitive writing (copy/pasting) the same code over and over again
* forms must be reusable
* form creation must be quick
* the forms must have the options to be also used as LookUp Forms
* Master-Detail or relationships must be simple to implement (without coding) (eg.Order->OrderDetail, Order->OrderPayments,....)
* must have the ability to add new buttons with custom functions
* every control on the form must be accessible through code
* CRUD (create, read, update and delete) must be automatic
* forms can be database bound and nonbound (for creating parameters for reports or getting parameters for some kind of processing)
* must contain Events like: BeforeFormOpen, BeforeSave, AfterSave, EditChange, TextBoxValidation, TexBoxChange,.....
* Intelligent GridControl: automaticly handle sorting, filtering, formatting, summing, multi selecting
* Intelligent EditControl: some sort of responsive design, auto handling of fields types (Strings, Dates, Numeric, LookUp Form Fields)
* in the first quarter of 2017 the plan is to incorporate in the GridControl the algorithm for automatical handling of millions or even billions of rows by implementing pagination

With the experience and knowledge gathered over the years and the use of this control in a number of companies that specialize in creating applications for financial and accounting sector in the Croatian market we decided to allow others to also have the opportunity to use this control in their work.
And so the WinPIS j.d.o.o. company was born on 12. December 2012. (12.12.2012. :-).

In winter of 2016. the Beta version of Virtual Forms 32-bit edition is launched.

Why the name Virtual Forms
The forms that are created at run time doesn’t exist at design time.
There is only 1 physical form at design time that is hidden in control. When we create a Virtual form the control creates a virtual copy of this physical form. That way we can have many instances of the same form loaded.


You can download and play with it on http://www.virtual-forms.com

---

Here is a video to show you some of many features of the Virtual Forms:

---

---

Some screenshots from apps that were created with Virtual Forms:

Main Treeview Menu where we can attach forms or functions to Nodes

A simple Virtual Form

Master-Detail Form - Form with Relationships InvoicesMater -> InvoicesItems, InvoicesPayments, InvoicesAccounts, InvoicesNotes,.....

Auto generated filter Form from GridControl

Sample Unbound Form for getting user input for generating report

[dageci]

An update to the status of development of Virtual Forms for Excel (can't edit first post):
2017-12-22:
A lot of work has been done since I posted the first post. Some of:

• 32 & 64 bit of Office (Excel) is now supported
• because it now supports also the 64-bit, Main Treeview Menu has to be removed because it only works with 32-bit
• samples have been added, for Excel as the backend, but also Access and MySQL as the backend, while Excel & VBA as the frontend

You can check it out on https://virtual-forms.com

Davor

[dageci]

Today I am very proud and excited !!!

The "HIGHEST RATED" badge on the learning platform Udemy, in an exceptionally competitive category, Excel & VBA, after months of work on that course and then in the first week of publishing the course earned the "HIGHEST RATED" course badge.

In this category alone, Excel & VBA has thousands of courses, and thanks to the ratings and engagement of the participants, that course has been raised to such a respectable level.

VF Udemy Course Highest Rated_cut.png

If You are among them, THANK YOU very much for this, and if you want to see this course, here's the link with a fat big discount of 92% OFF for friends from ExcelForum community:

https://www.virtual-forms.com/EXCELFORUM

Davor