Data Entry Form.


C

Chiki

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.
 
Ad

Advertisements

G

Gina Whipp

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

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.
 
C

Chiki

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.
 
Ad

Advertisements

G

Gina Whipp

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top