Combo box that prints report
in [Form]
|
From: Richard on 13 May 2010 06:42 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
From: BruceM via AccessMonster.com on 13 May 2010 09:21 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/Forums.aspx/access-forms/201005/1
From: Richard on 13 May 2010 12:43 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/Forums.aspx/access-forms/201005/1 > > . >
|
Pages: 1 Prev: cant type more than 11 numbers Next: how can I replace SQL query with VBA logic |