[RESOLVED] Where to start?

[Kuyong_Chuin]

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.

[akhileshbc]

Hi pal,

Welcome to VBForums

Where did you reached in your coding..????

[Kuyong_Chuin]

Hi pal,

Where did you reached in your coding..????

How do I answer that one, LOL, Technically I have just about all the code for the program already written except for the client ID thing and linking the amortization table to the database correctly, But! Problem is I have it scattered through 3 different programs I have written over the years not counting the Math programs that I have in Q basic. On the actual Program I am working on now I just finished the design, built the forms and made the data base the only code on the program right now is the 16 pages of code that the App Wiz added while I was designing the Program. So Basically starting from scratch. After reading through this forum all night I have come to a conclusion that using MS Access 2003 is fine for Dads use but not if I ever want to make it usable to a company using a database on a server so I will need ideas on building a DB that doesn't have access' problems.

[akhileshbc]

Use left(variablename,3) for getting the first 3 letters from a string. For converting it into hexadecimal, use a for loop like this,
for i= 1 to len(variablename)
'code for converting each letter
next i

[Kuyong_Chuin]

Anyone have any ideas on what the easiest way to do this program? Should I rip apart all the code of the differant programs and try to make it fit or start from scratch and ignore are the codeI have already that would have to be updated and reworked?

[akhileshbc]

Try to combine all the code you have. Then change the part where you want to update. If you have developed the program in a systematic manner(i mean, a quite and clean way), then it will not be a problem. Then ask for the part where you have no solution.

[GettinBetter]

You seem to have come to a sensible conclusion in post #3. If you did all the previous programing while you were learning, you'll probably have realised by now that it isn't laid out in a methodical manner, and proves very difficult to expand and grow.
It may seem harder at first, but maybe a fresh start is the best way. One thing is sure, by scouring this site you will eventually find enough information to guide you in the best direction.
Good luck.

[Kuyong_Chuin]

Having to rethink some thing on the database part of this program, So thanks for all the help.