Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Loop thru a table to retreive criteria to run report

Status
Not open for further replies.
margaretLea

margaretLea

Programmer
Jul 25, 2011
1
US
Hi, Here's my question...

tblSupervisor - contains supervisors that will receive the report via email...

rptSupVacReport - report with dataSource = qryCompileVacRpt

qryCompileVacRpt - based on 2 tables with Vacation information used in the report

frmVacReport - form with button that runs code to run the report

Problem - I want to loop thru the tblSupervisor and print the report for each record in that table... I'll then send the report from access to their email...

Can you help, thanks, Maggie
 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
253
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
274
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
161
sxschech
sxschech
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
806
EwaFAMA
EwaFAMA
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
242
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top