I’ll try to make this as clear as I can and still try to keep it short and sweet as possible.
About three years ago I wrote a simple interest calculator for my Dad to use, He has used it and my math skill ever since to figure out the loans for the people buying lots from him. He wants me to upgrade the program and add some new features, but I’m not sure how to go about doing some of this so your input is much appreciated. Here are the perimeters of what the program has to do. Store loan info and clients Name, Address, Loan info, Lot numbers and payment history into the access Database I created for the program. Be able to do simple and compound interest and show and store this information in an amortization table. Compute loan time based on max payment, APR, and Loan amount. And last the hard part at least for me to figure out, take the first two digits of the lot#, first three digits of the first and last name and put them into to a string, example: Lot# 123 First Name: John Last Name: Doe = 12JohDoe then convert that into a 16 digit hexadecimal string using a TBL file. 12JohDoe = 31324A6F68446F65 this Hex string would be imputed into the Client ID field on the form automatically and saved in the Database as the Primary Key. The user should not be able to manually enter this Client ID into the form as a new ID but can enter the ID to pull up the data from the database when doing a search. User should be able to make a printout of clients Loan status AKA Payment Schedule and payment history at any time. So far I have the MDI forms created and the access database created but can’t get the flex grid for the amortization table to show only the amortization table and not all the data from the data base and have no clue how to code the Client ID part. I’m using MS Visual Studio with VB6 since I know nothing about coding in C++ yet. Any Ideas on where go from here? Thanks in advance. P.S. The start date for the loan info is linked to the calendar.