I have decided to repost as my previous post did not contain all the requirements and details.
Management implemented the Rep Call Sheets after some representatives stole each other's customers by quoting them and selling them stationery etc. Every day each representative has to fill in a form with the following fields;
Type Of Call (Courtesy, Appointment, Delivery, etc.)
New Customer (Yes/No)
Contact Phone Number
Once they filled in the forms, it had to be handed to management who reviewed the Call Sheets on a daily basis.
The project should be written in Visual Basic 6.0 using an Microsoft Access Database (XP/2003).
Preferably the GUI should be attractive and easy to use, with confirmation if you want to enter another record for the representative. The representative's name should then be auto selected from the dropdown list, aswell as the date should stay the same... The rest of the input fields should be resetted if you selected "Yes", If you selected "No" all the fields should be resetted.
The following input fields are required;
Client Visited (Dropdown list with auto complete)
Client belongs to representative (Each client has an assigned representative with an unique ID, should be auto filled in once client has been selected and should give an error if the representative name selected and the unique ID does not match)
Type Of Call (Appointment, Delivery, Cold Canvas, After Sales, Installation, Courtesy)
Stationery Only (Yes/No)
New Client (Yes/No)
Contact Name (should be auto filled in once client has been selected from dropdown list)
Contact Phone Number (same as above)
Please see the attached file for more information regarding the project.
1) Complete and fully-functional working program(s) in executable form as well as
**complete source code** of all work done.
Windows XP Pro SP1
Microsoft Access XP/2003