
Signature
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video
> I need your help. I want to automate the production of certificates at my
> company. I train students in different courses and now want to develop a
[quoted text clipped - 6 lines]
> re-issue. i should also be able to print report for certificates issues under
> each course or students. i hope my problem is clear to others. thank you
how do i start that my friend, give me more tips, i think your idea is the
best.
> Why don't you create a training registration database (as I am at the moment)?
>
[quoted text clipped - 8 lines]
> > re-issue. i should also be able to print report for certificates issues under
> > each course or students. i hope my problem is clear to others. thank you
JL Wright - 12 Sep 2007 16:52 GMT
Build yourself a table with fields like [LastName] and [FirstName]. One of
your fields can be [Printed] and it should be a “Yes” or “No” combo.
Now built the report. The report should look like your certificate. A Text
Box in your report could be [FirstName]&” “&[LastName]
The report could be built off of a query or use the SQL Statement Query
Builder to tell the report to print only the certificates that you have
selected.
Hope that makes sense to you.

Signature
Jerry Wright
> how do i start that my friend, give me more tips, i think your idea is the
> best.
[quoted text clipped - 11 lines]
> > > re-issue. i should also be able to print report for certificates issues under
> > > each course or students. i hope my problem is clear to others. thank you
scubadiver - 13 Sep 2007 08:32 GMT
The one I am doing is quite complicated. I will give you the basic tables to
help get you started. This is a many-to-many relationship since each employee
can attend many classes and each class can have many employees:
tble_booking
BookingID (PK) Autonumber)
RoomID
CourseID
Duration
Trainingdate
TrainingTime
SupervisorID
tble_employee
EmployeeID (PK)
Employee
tble_attend
EmployeeID (FK)
BookingID (FK)
Attendance
1) Put the Booking table fields in the main form
2) Put "EmployeeID" and "Attendance" from "tble_attend" in the subform.
"BookingID" will be linked from the main form.
3) In the subform make the "employeeID" a combo box and use "tble_employee"
as the source. Make the ID number the bound column (in the data tab) but show
the names by making the width of the first column "0cm" and width of the
second column "2cm" (column widths in the format tab). This will show the
name but store the ID number.
The attendance field is a checkbox. After the training has finished, the
supervisor can tick all those who attended and then you can calculate
attendance rates.
What you can also put on the main form is a button that will open an
attendance register report. Base the report on a query that restricts the
report to the training course field on the main form.
That is the very basic one. Mine has forms for supervisors, courses,
department and employee information and employee feedback questionnaires.

Signature
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video
> how do i start that my friend, give me more tips, i think your idea is the
> best.
[quoted text clipped - 11 lines]
> > > re-issue. i should also be able to print report for certificates issues under
> > > each course or students. i hope my problem is clear to others. thank you