I need an example program written in VB6 accessing a SQL database to show how to display list boxes, text fields, scrollable lists, multi-select lists. There should be all types of fields displayed, with pop up forms, modal forms and multi-function forms which can be display only, or edited / updated.
The program must include multiple forms with a command button to go from one form to another.
The forms must include the following types of fields (not necessarily all types on one form):
List box (code to show how to initially populate, add lines, remove lines and update lines within the data displayed)
Dynamically created object
Dynamically moveable Image
Dynamically moveable command button
Dynamically sizable listbox
ActiveX control ([url removed, login to view] specifically - or another button control which allows customisation)
Reading / writing / updating / deleting type of I/O should be included for single and multiple records sourced from single and multiple tables.
This program will be used as a reference library when converting an existing VB6 / Access project to VB6 / SQL Server.
An installation file must be created to install the app and SQL database on a PC that has just Windows XP / 7 / 8 installed.
SQL, Visual Basic