Coin Group Program

Create a grid that would dynamically change to adapt to various sets of coins. Some will be displayed by the minting city others by denomination. The grid must be able to change the number of columns and of course rows. The fields that are needed to populate this grid are contained in the following tables: ProgramNames ProgramDataDesign ProgramDataContent The main program form should contain a combo box to pick the appropriate “Coin-set?? or create a totally new one. If the user selects an existing program the system should automatically show the heading information. The left hand column will always be the year but Columns 1 to what ever can be titled whatever the user needs them to be. The user should be able to move the headings around - which should be quite easy to do with the flexgrid. The program automatically will save the position of each header (1,2,3 etc). Position (0) is always the year. The user also needs to be able to enter new coins into the grid and have them displayed properly. I have included a small sampling of the type of data that you would need to handle. The user should be able to add new coins to an existing Coin-set or create a new Coin-set and populate it on the form you are making. He should be able to save his entries and edit them. We do not want you to use field names that are non descriptive ??" we want code that is very readable and you must have it easy for a user to move around it in. The user should be able to press enter to move between fields and/or use the mouse. The form/s should look professionally done not like it some temporary form. This program will be used by owners of our company, so we want this work done with no repercussions from them on its functionality. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). Use an external file that contains the path to the database that contains the data for this form. Do not bind the fields to the form. Use code to connect to the tables - like: If OpenADO_CoinData Then ' this will stay open now Set rec = New [login to view URL] With rec .Source = "Select lastinvno,commtype, seeashouse from companyinstall;" .ActiveConnection = CoinDataConn .CursorType = adOpenDynamic: 'adOpenKeyset .LockType = adLockOptimistic ' must declare a lock type or you can not edit or add a record .Open End With If [login to view URL] <> 0 Then [login to view URL] HouseID = rec!seeashouse If rec!commtype = 2 Then WholeSale = -1 ' get the markup Else WholeSale = 0 End If MyNewRecNo = rec!lastinvno + 1 rec!lastinvno = MyNewRecNo GetOrdID = MyNewRecNo [login to view URL] [login to view URL] End If End If End If ## Platform Must be created in Visual basic and use VS Flexgrid to display the data.