Search results

I'm new to databases. I've been given a task to make a questionnaire database. for example: Question 1 : How are you? Answer Choice : (i) Good (ii) Very Good (iii) Not Good (iv) Don't Know Question 2 : What's your age? Answer Choice : (i) 7 "numeric field to enter age in number" (ii) Don't Know...

I'm working on a questionnaire db & in this db, I've Question table where there answer will be "Yes/No/Don't" Know and another table Other Questions where the answer will be "Yes/No" only. There will be also another table where I'll put questions where user has to input the answer. I just find...

I've created a form where I've used 5 combo boxes all are working fine & i'm getting all information. Following are the combo boxes: City - School - Class - Gender - Grade --All - --All - --All - --All - --All --city1 - --school1 - --class1 -...

Access gives error on duplicate entry, duplicate indexed field, violation of validation rule etc. etc. but it does not give error code. I want to display custom error messages for common error that come during data entry for the end user but don't know where to find error codes so that I can do...

A company has offices at different states & they want to track their employees and user has to select the reasons from a combobox list. for example: cboReason has following options: Reason 1 Reason 2 Migrated to other state Reason 4 So, I want that, when a user selects 3rd reason (Migrated to...

I'm having two issues with scroll bars. I've Main Form (frmMain) which is just showing two combo boxes to filter results of the sub form. In the main form (frmMain), I've continuous sub form (fsubSchool). In sub form (fsubSchool), records are showing as Tabular form. Scroll bars are active on...

I've another issue regarding Combo Box I've tblEmployees & in that table I'm Resignation reason lookup table (tblReason) in which I've mentioned few reasons & there is also an "Others" option. So, during data entry, I want the user to select Resignation reason from the combo box list & if user...

hello everyone! Is there any way to disable auto saving functionality in Access ??? I've a main form (frmSchool) and a sub form (fsubStudents). sub form (fsubEmployees) is a continuous form. When I enter records (data) in main form and after last record, it moves to the fsubStudents, it saves...

Is there any way to replace the navigation buttons of main form (frmMain) with the navigation buttons of the continuously sub form (fsubStudents). I tried to hide the navigation buttons of main form which contains continuous sub form but it hides for that sub form too. So, I tried to make my sub...

Is there any way to allow a sub form to be a Continuous form which also includes a sub form ??? Actually, I've made a Main Form (frmMain) which includes only two combo box to filter. and then I've added a sub form (frmStudents) which also includes a sub form (frmAttendences). (frmStudents is...

I've main form (frmMain) where I've two combo boxes (cboState & cboCity) which are linked together. On the frmMain, when a user select State from cboState & then it must select a city from cboCity & when user select a City from 2nd combo box, I want to open my subform (frmStudent) right into the...

I really need help, below are the tables: tblCity City 1 City 2 tblSchools SCL-NY-01 SCL-NY-02 SCL-MI-01 SCL-MI-02 SCL-MI-03 tblStudents StudentName StudentAge (etc.) and I want the following result: I want to create a form for data entry purpose. Where, When the user Select City 1 from...

If anyone can help me to figure this out it would be great. Tables: tblStudents, tblSex, tblGrade, tblClass Student ID - Auto Number Student Sex - Text (Male or Female) Student Grade - Text (A, B, C, D, or E) Student Class - Text (One, Two, Three, Four, Five) Now I want to get the following...