I have decided to repost as my previous post did not contain all the requirements and details.
Background:
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;
Representative Name
Date
Client Visited
Type Of Call (Courtesy, Appointment, Delivery, etc.)
Quoted (Yes/No)
New Customer (Yes/No)
Followup Date
Contact Name
Contact Phone Number
Memo
Once they filled in the forms, it had to be handed to management who reviewed the Call Sheets on a daily basis.
Project Goal:
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;
Representative Name
Date
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)
Quoted (Yes/No)
Stationery Only (Yes/No)
New Client (Yes/No)
Followup Date
Contact Name (should be auto filled in once client has been selected from dropdown list)
Contact Phone Number (same as above)
Memo
Please see the attached file for more information regarding the project.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as
**complete source code** of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
## Platform
Windows XP Pro SP1
Microsoft Access XP/2003