A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo box that prints report



 
 
Thread Tools Display Modes
  #1  
Old May 13th, 2010, 11:42 AM posted to microsoft.public.access.forms
Richard
external usenet poster
 
Posts: 1,419
Default 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  
Old May 13th, 2010, 02:21 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default 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  
Old May 13th, 2010, 05:43 PM posted to microsoft.public.access.forms
Richard
external usenet poster
 
Posts: 1,419
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.