Project: 1 form application for surveys
NOTE: This is a reposted project from [url removed, login to view] . The chosen .net solution did not work in the Citrix environment. Please note that only Delphi is accepted.
This is a very very simple project. Only 1 form is needed with two combo boxed, 1 text and two buttons and two labels.
The application must have the following functionalities
1 check windows user ID based on master DB information (MS Access)
2 load selected surveys (survey, questions, answers)
3 Display form
4 when closing the application, port the information in Master DB (Enquiry nr, question nr, UserID, date/time, answer value, follow up)
The form works as follows.
It contains two combo boxes:
1 for selecting the survey (attached to a process)
2 for the value (1-10 in the language)
When a value below 6 is selected, the follow up box appears (and needs to be entered)
3 when clicking next button, the form refreshed and the focus is set to the survey selection box.
After finishing the survey, the quit button does the transaction to the master DB and the app quits.
The tab key should easily walk through the application. The combo boxes need to dropdown when entered. The
I expect you to create this application in Visual studio or Delphi. Visual basic is preferred, So I could use and fine tune the code.
Screenshots will be send after approval.
An important restriction is that the application does not need to be installed on the host computers, since there are no administrator rights!
That is all.
1 The application is started up at the beginning of the workday. After each contact with a client the employee asks 1 (random) question to the client and enters the answer. The application then is NOT closed. After answering 1 question the employee continues his work. At a new contact with a new client, the whole thing repeats. Thus again select process, ask 1 question and then continue with work.
2 The application will be closed only at end of the workday. And then the answers will be uploaded to the database. Thus meanwhile an array with answers is stored inside the app.
3 There is NO need nor demand for a webbased solution. The company has 5 locations all over Europe with all different internet networks. Thecommon thing they share is the network drive. Thus the application is either Delphi or windows forms (made in visual studio) A .net solution is also not preferred since .net is blocked in the CITRIX environment.
4 The MS Access is stored on a network drive within the customers network. All users have reading/writing permissions to this database.
5 The application is shared by more users.
6 Testing will not be a major problem. Our customers business analysts and project managers will do this and give feedback.
7 Indeed if the the cooperation between you and us is succesful we will most probably have more upcoming project.
8 the total database model will be provided as soon as possible. For creating the application I think you only need to know which queries to load and where to save the data.
9 The Access version to retrieve and store information is Access 2000
10 After answering 1 question the application will not be terminated. The form will reload like as startup form (without a question and with selection of process)
11 The same question can be asked more than once. Thus you simply append the answers of the day to the answer table in the database. No need for replacing answers etc.
12 Not all questions need to be answered. The selection of questions is purely random. Note that +/- 100 employees will use the system, so in the end the randomness ensures that all questions are answered.
13 We have different languages and the answers and questions are in the language of the user preference. The questions are filled in the query and you simply fill the contents of the query in the label of the question. All very simple.
14 For the maintenance of questions a seperate forms database will be made. This database allows managers to add/remove users, add/edit/remove questions, same with processes, answrs, languages etc etc
Thus the application is only this form. No more, no less :)
15 Please do not use Access as basis for this system. We need a stand alone exe file for the system, since there are no administrator rights. We have tried to make this application in Excel and .net, but got into problems with softgrid and citrix. These files will be made available as an example.
16 All questions will be loaded upon start.
17 All things in the database are dynamic #labels, #questions, #languages, #answers (currently 1..10) etc
18 The application needs to be compatible with Delphi turbo explorer (free edition) Since I need to do maintenance myself.
As I say I will upload an example as soon as possible. Now time for coffee :)