Auto Fill

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I'm trying to enter employee training information. I want to be able to type
in an identifier (last name or employee number) and it will bring up
information showing what training they received, and the date they received
it. I know I have to make a table with all the information I need, but that's
where I'm stuck. I dont' know what to use (form, query, etc.) and I don't
know how to set any of that up. Basically, I'm totally lost :(

Any help is GREATLY appreciated!
 
I'm trying to enter employee training information. I want to be able to type
in an identifier (last name or employee number) and it will bring up
information showing what training they received, and the date they received
it. I know I have to make a table with all the information I need, but that's
where I'm stuck. I dont' know what to use (form, query, etc.) and I don't
know how to set any of that up. Basically, I'm totally lost :(

Any help is GREATLY appreciated!
Click to expand...

The data would be *stored* in a table; selected and organized in a Query; and
*displayed* on a Form. You will need at least three tables: Employees (with
the employee ID, last name, first name, and other biographical data); Courses,
a list of all the training courses available, with CourseID, CourseName, and
other info about the course; and CoursesTaken, with fields for the EmployeeID,
CourseID, and other info about this employee's participation in this course
(e.g. date taken, satisfactor/unsatisfactory performance, etc.)

For some resources (including a couple of sample training applications) see
the links at these sites:

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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Thank you for helping! Here is my next problem :)
I have created the tables to store all the information. My question now, is
how do I get it all to connect? I have created a query and a form but I don't
think I did it right. I would like to be able to type in the employee's name
and have all the training they have completed show up.

If I type information such as employee name and course into a form, how is
the data stored? Is it saved somewhere?
 
Thanks for your help. But is there any way you could dumb it down for me? :)
I am unfamiliar with entering any kind of code. Your help is SOOO much
appreciated!!!

KenSheridan via AccessMonster.com said:
Your form should be based on a query on the CoursesTaken table which
references a combo box of employees on the same form. I'll come back to the
combo box later, but the query would be:

SELECT *
FROM [CoursesTaken]
WHERE [EmployeeID] = Form![cboEmployee];

Make the form a continuous form. If you use the form wizard to create it
select 'tabular' as the layout. You only need controls in the form for the
CourseID and other columns like the date taken etc, not for the EmployeeID.

In the form make the control bound to the CourseID column a combo box set up
like this:

ControlSource: CourseID

RowSource: SELECT [CourseID], [CourseName]FROM [Courses] ORDER BY
[CourseName];

BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0cm;8cm

If your units of measurement are imperial rather than metric Access will
automatically convert them. The important thing is that the first dimension
is zero to hide the first column and that the second is at least as wide as
the combo box.

In the form's header add a combo box and set it up like this:

Name: cboEmployee

ControlSource: Leave this blank

RowSource: SELECT [EmployeeID], [FirstName] & " " & [LastName] FROM
[Employees] ORDER BY [LastName], [FirstName];

BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0cm;8cm

In the AfterUpdate event procedure of this combo box put:

Me.Requery

This requeries the form so it shows only the courses for the selected
employee. If you are unfamiliar with entering code in event procedures you
do this by selecting the cboEmployee combo box in form design view and
opening its properties sheet if its not already open. Then select the After
Update event property in the properties sheet. Click on the 'build' button;
that's the one on the right with 3 dots. Select 'Code Builder' in the
dialogue, and click OK. The VBA window will open at the event procedure with
the first and last lines already in place. Enter the line of code between
these two existing lines.

When the form opens it will not show any records. Select an employee from
the combo box and it should then show any courses taken by the employee.
You can add a new attendance at a course for the current employee by adding a
new record in the blank row below the existing course attendance records
simply by selecting a course in the combo box and entering the date taken etc
as appropriate.

Ken Sheridan
Stafford, England
Thank you for helping! Here is my next problem :)
I have created the tables to store all the information. My question now, is
how do I get it all to connect? I have created a query and a form but I don't
think I did it right. I would like to be able to type in the employee's name
and have all the training they have completed show up.

If I type information such as employee name and course into a form, how is
the data stored? Is it saved somewhere?
I'm trying to enter employee training information. I want to be able to type
in an identifier (last name or employee number) and it will bring up
Click to expand...
[quoted text clipped - 33 lines]
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
Click to expand...
Click to expand...

--
Message posted via AccessMonster.com


.
Click to expand...
 
Back
Top