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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo box that prints report
Hi
I am using Windows XP and Access 2000. The database is for shceduling courses. I have 2 tables. TRAINW and Courses. A form called ChooseCourse, and a report called PrintWaitingList. The form needs a Combo Box where users can select a course from the Courses table, then click on a 'Print' button that prints off the PrintWaitingList report. The PrintWaitingList report needs to have the Course name field and other fields like the name of the person which should come from the TRAINW table. Any help with this would be most appreciated. Thank you in advance. Richard |
#2
|
|||
|
|||
Combo box that prints report
If the idea is that you will schedule people for individual courses, the
situation is that one course may be attended by many people, and one person may attend many courses. This is known as a many-to-many relationship, so you need a third table (Enrollment) to resolve the relationship. tblCourse CourseID Dept Description etc. tblStudent StudentID FirstName LastName etc. tblEnrollment CourseID StudentID There are other considerations, such as whether a course is offered at different times, and whether you need the instructor information in the record. To briefly answer your specific question, for the report you need a query that combines the appropriate tables and contains the fields that need to be on the report. To print a report for a single record or a limited group of records, see VBA Help for information about OpenReport. Specifically, the Where argument is used to limit the report's recordset. Richard wrote: Hi I am using Windows XP and Access 2000. The database is for shceduling courses. I have 2 tables. TRAINW and Courses. A form called ChooseCourse, and a report called PrintWaitingList. The form needs a Combo Box where users can select a course from the Courses table, then click on a 'Print' button that prints off the PrintWaitingList report. The PrintWaitingList report needs to have the Course name field and other fields like the name of the person which should come from the TRAINW table. Any help with this would be most appreciated. Thank you in advance. Richard -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
#3
|
|||
|
|||
Combo box that prints report
Thanks Bruce
That has been very helpful. I will read up on VBA help. Richard "BruceM via AccessMonster.com" wrote: If the idea is that you will schedule people for individual courses, the situation is that one course may be attended by many people, and one person may attend many courses. This is known as a many-to-many relationship, so you need a third table (Enrollment) to resolve the relationship. tblCourse CourseID Dept Description etc. tblStudent StudentID FirstName LastName etc. tblEnrollment CourseID StudentID There are other considerations, such as whether a course is offered at different times, and whether you need the instructor information in the record. To briefly answer your specific question, for the report you need a query that combines the appropriate tables and contains the fields that need to be on the report. To print a report for a single record or a limited group of records, see VBA Help for information about OpenReport. Specifically, the Where argument is used to limit the report's recordset. Richard wrote: Hi I am using Windows XP and Access 2000. The database is for shceduling courses. I have 2 tables. TRAINW and Courses. A form called ChooseCourse, and a report called PrintWaitingList. The form needs a Combo Box where users can select a course from the Courses table, then click on a 'Print' button that prints off the PrintWaitingList report. The PrintWaitingList report needs to have the Course name field and other fields like the name of the person which should come from the TRAINW table. Any help with this would be most appreciated. Thank you in advance. Richard -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 . |
Thread Tools | |
Display Modes | |
|
|