Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2005

Tip: Looking for answers? Try searching our database.

Printing current record label

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pastor Rod - 05 Dec 2005 18:00 GMT
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 - 06 Dec 2005 04:13 GMT
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

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 8 lines]
> tables) and then one for the parent with different columns. I'm using
> Microsoft Access 2002.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.