Data Entry Form.
in [Form]
|
Prev: asdfasdf
Next: Cancel/BeforeUpdate Event Procedure
From: Chiki on 26 Apr 2010 21:58 I had created a form for entering the employees Contract Form with the employees table as the database.i had created the exact fields in the table & the form for entering data into the employees table through the form. I had created the base table named values with the same fields Like Department,Employee Name, DOJ (Date of Joining) & CED(Contract Expiry date) On my form i had created 2 comboboxes & 2 textboxes. The first combo box is to select a department the list.Upon selecting a department only the employees in that particular dept should appear. The 1st Text box is to show the Date of Joining of the Employee from the selection of the second combo box.The Second Text box should calculate the CED based on the DOJ of the Employee which is 6 months for every employee. Question 1:How would i get the values into the combox. From studying many examples,i found that the values can be obtained either from the table or query from the combo box properties. Is it correct to get the values from table/Query from the Combo box properties. Question 2: How to show/display the Contract Expiry Date based on the employee name from the table. Please tell me how to proceed.If i need any macros also do tell me.I want the code also.
From: Gina Whipp on 27 Apr 2010 01:08 Chiki, Answers in-line... -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Chiki" <Chiki(a)discussions.microsoft.com> wrote in message news:5BF58658-DC2B-416E-A1B0-250458FE8C22(a)microsoft.com... I had created a form for entering the employees Contract Form with the employees table as the database.i had created the exact fields in the table & the form for entering data into the employees table through the form. I had created the base table named values with the same fields Like Department,Employee Name, DOJ (Date of Joining) & CED(Contract Expiry date) On my form i had created 2 comboboxes & 2 textboxes. The first combo box is to select a department the list.Upon selecting a department only the employees in that particular dept should appear. The 1st Text box is to show the Date of Joining of the Employee from the selection of the second combo box.The Second Text box should calculate the CED based on the DOJ of the Employee which is 6 months for every employee. Question 1:How would i get the values into the combox. From studying many examples,i found that the values can be obtained either from the table or query from the combo box properties. Is it correct to get the values from table/Query from the Combo box properties. ***Yes it is correct to get the values from a table or query. However, you should create the table from which to draw your combo box values from. In your case that would be something like... tblDepartments dDepartmentID (PK - Autonumber) dDepartment Question 2: How to show/display the Contract Expiry Date based on the employee name from the table. ***Where is the Contract Expiry Date entered that it would know which Employee it belongs to? Is this date already entered into the table? Or is it going to be entered in your form. Please tell me how to proceed.If i need any macros also do tell me.I want the code also. ***You should not need any macros to do the above.
From: Chiki on 27 Apr 2010 12:31 Ok. Thanks for the replies. If u come across any examples of entering data through form pls post them. The Previous ones which are given as links are not understandable by me.I ma novice user learning access.so kindly , give me any examples which can be understood easily with out any prior knowledge.
From: Gina Whipp on 27 Apr 2010 15:27 Chiki, What previous links? If you are a novice then you really should start here... Jeff Conrad's resources page... http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page... http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP)... http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials... http://allenbrowne.com/links.html#Tutorials Sample data models... http://www.databasedev.co.uk/table-of-contents.html If the above links are what you eluded to AND you are having difficulty understanding them then I suggest studying them harder. Access has a steep learning curve and you should understand normalization, relational database design, naming conventions, data models, etc... before you even create your first table. You don't want your first database to be unusable in the upcoming months because the tables were done incorrectly! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Chiki" <Chiki(a)discussions.microsoft.com> wrote in message news:602D0C18-01F5-436C-9AA8-2B8953804D0C(a)microsoft.com... Ok. Thanks for the replies. If u come across any examples of entering data through form pls post them. The Previous ones which are given as links are not understandable by me.I ma novice user learning access.so kindly , give me any examples which can be understood easily with out any prior knowledge.
|
Pages: 1 Prev: asdfasdf Next: Cancel/BeforeUpdate Event Procedure |