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

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 are the code and the database used in the video:

Attachment 143659

---

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

https://www.youtube.com/watch?v=jxhXIAh4C4Y

---

Video How to create a simple Database Desktop App in vb6:

https://www.youtube.com/watch?v=72-DuknS_Y4

I would be very grateful for your comments.

Thank you

Some screenshots from apps that were created with Virtual Forms:

---

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

Attachment 143683

---

This is a simple Virtual Form:

Attachment 143681

---

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

Attachment 143677

---

Auto generated filter Form from GridControl:

Attachment 143679

---

Sample Unbound Form for getting user input for generating report:

Attachment 143685

Just tested it within a VMware windows 7, with Excel 2010.
And I have "Runtime Error 3709"
Then "VFile (Virtual Form File) does not exist"
D:\UFO\Active\OCX\VirtualFormDesigner.vf
And of course Error 440

It seems that one of you r OCX is not registered

Thierry69 thank you very much for taking the time to test it.

I need to create a new test environment and test it there. I will post here when I solve the problem.

:-) Once again, thank you!!
Davor

Quote:

---

Originally Posted by Thierry69

Just tested it within a VMware windows 7, with Excel 2010.
And I have "Runtime Error 3709"
Then "VFile (Virtual Form File) does not exist"
D:\UFO\Active\OCX\VirtualFormDesigner.vf
And of course Error 440


It seems that one of you r OCX is not registered

---

The problem is solved and the new version 1.2.0.705 is available for download on http://www.virtual-forms.com/