Printing current record label

[Pastor Rod]

I'm trying to create a data base for our Sunday School, where we register
children as they arrive. As I click on the present tag (In the Student Input
Form)I would like Microsoft Access to select (on click) the current related
record (as the date and time tables are related to the student table) Send it
to a label report and print one for the student with some of the fields
(Name, Group Name, Time, Allergies Unique ID number etc - all columns in the
tables) and then one for the parent with different columns. I'm using
Microsoft Access 2002.

 

[Allen Browne]

The solution will depend on how you have this data stored.

Presumably you have already set up tables for:
- students,
- parents,
- the connection between students and parents,
- issues (such as allegies),
- the connection between students and issues,
- events (dates when Sunday School events are held),
- attendance (link between students and events),
as well as other tables such as Staff.

When the parent drops the child off for an event, you are therefore entering
the attendance record. This record includes the StudentID and the ParentID
(related to their respective tables). You can therefore use these values to
limit the label reports to just the student and parent in this record.

Steps:

1. Create a query containing Student and StudentIssue tables.
To ensure this works even if a student has no allegies, double-click the
line joining the 2 tables. Access opens a dialog offering 3 options. Choose,
"All records from Student, and any matches from StudentIssue."

2. Create a label report based on this query.
Don't worry about the fact that this currently prints all students.

3. Create another label report linked to the Parent table.
Don't worry that it prints all parents.

4. On the form where you enter the Attendance record, add a command button
that performs these actions:
a) Saves the entry.
b) Prints the first label report, filtered to the student.
c) Prints the second label report, filtered to the parent.

For an example of how to filter the reports, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html