A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data Entry Form.



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2010, 02:58 AM posted to microsoft.public.access.forms
Chiki
external usenet poster
 
Posts: 22
Default Data Entry Form.

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.
  #2  
Old April 27th, 2010, 06:08 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Data Entry Form.

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" wrote in message
...
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.

  #3  
Old April 27th, 2010, 05:31 PM posted to microsoft.public.access.forms
Chiki
external usenet poster
 
Posts: 22
Default Data Entry Form.

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.
  #4  
Old April 27th, 2010, 08:27 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Data Entry Form.

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/acc...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" wrote in message
...
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.