Create an application that manages cable account information. A form allows the entry of the following data: accountholder id (integer), first name(string), last name(string), debits (decimal), and credits (decimal). The form should have the buttons: Add (which adds a customer to the [login to view URL] sequential file), Clear (which clears all text boxes for a new account entry), Balance (credits – debits), and Exit (which closes the form). When the Balance button is clicked, an independent function is called that calculates the balance from the given credits and debits of that user and returns the balance to be displayed in the balance label.
The sequential file must hold the following information:
a) Accountholder id
b) First name
c) Last name
d) Debits
e) Credits
f) balance
The accountholder id must be between 6000 and 22000 (inclusive). If it is not within this range, an error message should be displayed to the user via an error message label on the form and the Add button disabled until an accountholder id within range is entered.
The number of credits and debits must be greater than 0. If it is not within this range, an error message should be displayed to the user via an error message label on the form and the Add button disabled until credits/debits within this range is entered. If the calculated balance is less than 0, an error “Account In Debit” must appear in red in an error message on the appropriate tab.
On another form or in the same form (with additional buttons), allow the user to find an account via the accountholder id. If the account is not found, display an “Account Not Found” in a label beside the Search button. If the account is found, the account info is displayed in the accountholder id, first name, last name, credits, debits, and balance text boxes. The user is allowed to edit any of these fields, except accountholder id or balance. After they finish editing, the modified information for the account is saved, with an updated balance, in their record when the user clicks on the Save button. There is also a Clear and Close button whose functionalities are similar to the account entry form.
Menu options that mirror the actions of buttons, when clicked, should be added.
When the form closes, a dialog box must ask the user if they wish to save the current information to file. If the user chooses yes, the arrays are written to the text file. Otherwise, the form closes.
- All work must be your own and the project must be thoroughly commented throughout the code
- Test your project thoroughly to insure that no illegal actions are allowed and if the user performs an illegal action, a warning message should be displayed to them via a label
I can do this exactly as you described. I have 9 years of experience in Application Development. Select my bid as soon as possible to get me started working on it. Thanks.
Hello. We are a German Company with a team of 3 dedicated VBA developers and we've done the similar projects. We are sure that we will provide you with a very robust high quality solution. We assume high quality work both in terms of technical background and time frame issues. Please check your PMB.
I can develop the application you want, it would be a customer management software, as well as we can make it extra feature that can remotely log in from, this means establishing a client application and a server, the server stores data and client application with the log in, the modified or you resign in the system. Any questions I am available
15+ years of experience working on various technolgies and significant experience in VB. Developing such an application is an easy task. Please check PMB for details. Thanks.